Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disconnect All Users from Database

blamaSep 14 2004 — edited Sep 20 2004
Hello,
I'm searching for a possibility to find out which users are connected to my DB. Is there a table which keeps
eye on all connections like in MS-SQL-Server?

It would be great if it is possible to disconnect all users from a DB by script / stored procedure so that I can
restore the database afterwards.

I don't want to kill all users connected to the Oracle instance, as there are many developers each connected to his own DB on the same instance.
Therefore I can't just shut down and restart Oracle.

Thanks in advance,
Salek Talangi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2004
Added on Sep 14 2004
8 comments
2,297 views