How to know which user session has been killed when a user session has reached resource limit specif
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
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
0