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!

Exclusive access to an instance

Milan TDec 14 2022

On the Oracle DB instance that we use for load testing, usually many users have concurrent access and can execute their queries, but sometimes only 1 DB user should have exclusive access and perform load test. How can I temporarily prevent other users form logging in and performing any queries while the tester perform load tests? After the tester finish with load testing other users should be able to access that Oracle DB instance concurrently until the next user requires exclusive access to the instance.

This post has been answered by L. Fernigrini on Dec 14 2022
Jump to Answer
Comments
Post Details
Added on Dec 14 2022
3 comments
317 views