To use this statement, your instance must have the database open, and your session and the session to be terminated must be on the same instance unless you specify integer3. You can find the instance ID by querying the GV$ tables. KILL SESSION ' integer1, integer2'įor integer1, specify the value of the SID column.įor integer2, specify the value of the SERIAL# column.įor the optional integer3, specify the ID of the instance where the session to be killed exists. Issue the ALTER SYSTEM KILL SESSION and specify the session index number (SID) and serial number of a session that you identified with the GV$SESSION dynamic performance view. Query the value of the INST_ID column in the GV$SESSION dynamic performance view to identify which session to terminate. To terminate sessions, follow these steps: You can use Application Continuity to hide the cancellation of a transaction from the user, if the application initially used an Application Continuity-enabled dynamic database service to connect to the database instance.įor a more granular approach to service-level management, Oracle recommends that you use Oracle Database Quality of Service Management (Oracle Database QoS Management) for all Oracle RAC-based databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |