Oracle Database Discussions

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!

How i can kill all the connections?

739193Mar 11 2010 — edited Mar 11 2010

Hi All,

I need to kill all the users connecting to my database now and dont let them to connect for next two hours.

What in my mind is

1. Alter system enable restricted session
2.Kill all the sessions
3. after two hours disabling the restricted session.

But i have a doubt here. When the last time i killed a session i cud see the session even after i killed it.. Does it takes time to kill the session? How can i minimise that time?

Regards
Arun

This post has been answered by 759542 on Mar 11 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2010

Added on Mar 11 2010

#general-database-discussions

22 comments

8,011 views