SQL>Select * from v$session where type = ‘USER’ and status = ‘ACTIVE’ Take the sid and serial# values from there and use the below command to kill particular session. Toad for Oracle is the 1 commercial Oracle development/management tool for over twenty years Toad for Oracle enables you to maximize your investment in Oracle technology by empowering database professionals to automate processes, minimize risks and cut project delivery timelines by nearly half. The specification declares the attributes, subprograms (functions and procedures) and other object type elements, such as map order functions. An object type definition consists of an object specification and an object body. Open the Database → Monitor → Session Browser tab or directly clicking on the session toolbar button and find the ACTIVE one and press the X button. Oracle Database supports database objects in the relational model and uses object types to convey the concept of the objects. You can see here not only the session and their SQL statement, cursor, explain plan and DML progress but you can see the database lock, blocking locks, database object being accessed and activities of rollback segment You need to have DBA privilege to carry out such activity using toad, click on Session Browser, expand the program under program list, select the intended process on the top click on Kill X button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |