Find Active Sessions in Oracle Database
2008 June 8
There are times that you may need to issue a “SHUTDOWN IMMEDIATE” command to an Oracle Database. It is critical that you should consider checking who are the users that are currently running sessions on that Database. You don’t want to shutdown on your Boss or VP on Finance. Here’s a simple SQL to find all Active sessions in your Oracle Database:
-Marlon Ribunal
Shameless Ad:
In need of Virtual Assistance? Visit Virtual IT Specialist Now!
If you have a RAC configuration, you can use the next SQL to show the same information plus the instance identification on which the session is connected to:
SELECT Inst_Id, SID, Serial#, UserName, Status, SchemaName, Logon_Time
FROM GV_$Session
WHERE Status=’ACTIVE’ AND
UserName IS NOT NULL;
Hello webmaster
I would like to share with you a link to your site
write me here preonrelt@mail.ru
Cool….Thanks
This functionality is readily available as a menu item in PL/SQL Developer (Tools->Sessions…).