Skip to Main Content

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 To Disable Connections or Freeze Database

cmennensMay 1 2012 — edited May 1 2012
I have no need to do so right now but I'm curious what the recommended process would be if there's an issue with Oracle 11g & one had to keep the database engine up and running but stop all users from connecting while 'X' was investigated. Do you guys have any recommendations (examples) on standard / simple procedure to stop users from connecting to Oracle 11g and querying the database or altering the database?

Thanks for any info and like I said, this is a hypothetical question as to what would one do if this issue came up. I don't have an actual performance issue that requires me from limiting database access.

Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2012
Added on May 1 2012
8 comments
4,414 views