![]() The INSTANCE option of ALTER SYSTEM ARCHIVE LOG enables you to archive each online redo log file for a specific instance.The INSTANCE option of ALTER SYSTEM ARCHIVE LOG enables you to archive each online redo log file for a specific instance To force a global log switch, use the ALTER SYSTEM ARCHIVE LOG CURRENT statement. ALTER SYSTEM SWITCH LOGFILE affects only the current instance. ![]() ![]() ALTER SYSTEM CHECKPOINT or ALTER SYSTEM CHECKPOINT GLOBAL affects all instances in the cluster database.Select the session you want to terminate and click Kill Session: 4. ALTER SYSTEM CHECKPOINT LOCAL affects the current instance. Identify the session you want to terminate.Some examples of how SQL*Plus commands affect instances are: You need only the proper database account with the privileges that you normally use for a non-cluster Oracle database. You do not need to run SQL*Plus commands as root on Linux and UNIX systems or as Administrator on Windows systems. You can use SQL*Plus to start and stop instances in the Oracle RAC database. Most SQL statements affect the current instance. Show the current instance parameter and SGA informationĭisplays information about the current instance 5 How SQL*Plus Commands Affect Instances SQL*Plus CommandĪffects the default instance if no instance is specified in the CONNECT commandĭoes not affect any particular instance, but rather the database
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |