Database Administration (MOSC)

MOSC Banner

How to know which user session has been killed when a user session has reached resource limit specif

edited Aug 15, 2011 4:57AM in Database Administration (MOSC) 5 commentsAnswered
Hello Everyone,
How can I know which user sessions have been killed due to reaching limits set by user profile

Example:
create user profile with resource limits set . ex. LOGICAL_READS_PER_SESSION. run a query against that user such that the resource limit is reached. That particular session throws error message. How to find out as a DBA which sessions have reached that resource limit

Thanks a lot

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center