EXA_DBA_SESSION_RESOURCES

This table shows all sessions and associated resource limits known to the system. Users with SELECT ANY DICTIONARY privilege has access to the table.

Column Name Description
SESSION_ID Id of the session
RESOURCE_TYPE Name of the resource
LIMIT_SCOPE Scope of the limit
LIMIT_TYPE Name of the limit
USAGE Current usage
LIMIT_VALUE Value of the limit