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!

Detecting Restricted Session mode

156733Aug 27 2007 — edited Aug 28 2007

Hi,

We are using the RESTRICTED SESSION mode to disable logins during batch runs and backup. We are using JDBC-connection pools for web services.
Since these pools remain connected, no ORA-01035 will be raised when a connection is taken from the pool. It's not a new login.
Is there a way to detect RESTRICTED SESSION mode (eg. by queying a DBA-view)?

Greets,

Roel

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2007

Added on Aug 27 2007

#general-database-discussions

2 comments

219 views