V$RSRC_SESSION_INFO displays Resource Manager statistics per session.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Session identifier |
|
|
|
Object ID of the consumer group in which the session currently belongs; NULL if the session has not yet logged in |
|
|
|
The name of the consumer group in which the session currently belongs |
|
|
|
Object ID of the consumer group in which the session was placed by the consumer group mappings; NULL if the session has not yet logged in This group may not be the current group because the |
|
|
|
Session attribute that was used to map the session into its original consumer group; NULL if no mapping was used See Also: "DBA_RSRC_GROUP_MAPPINGS" for more details |
|
|
|
Consumer group to which the session was originally mapped; NULL if no mapping was used This may not correspond to the original consumer group, because the mapped group may not be part of the current plan. See Also: "DBA_RSRC_GROUP_MAPPINGS" for more details |
|
|
|
Current state of the session:
|
|
|
|
Indicates whether the session is currently active (
|
|
|
|
Number of seconds the session has been idle (in states |
|
|
|
Amount of time (in milliseconds) the session has waited for CPU because of resource management (in state |
|
|
|
Cumulative amount of time (in milliseconds) the session has waited for CPU (in its lifetime) because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
|
|
|
Number of times the session had to wait for CPU because of resource management while in this consumer group; NULL if the current Resource Manager plan does not require updating this statistic. This does not include waits due to latch or enqueue contention, I/O waits, and so on. If |
|
|
|
Cumulative number of times the session had to wait for CPU (in its lifetime) because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
|
|
|
Amount of CPU time (in milliseconds) consumed by the session while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. If |
|
|
|
Cumulative amount of CPU time consumed by the session (in its lifetime) (in milliseconds) |
|
|
|
Amount of time (in milliseconds) the session has been active while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. Active time is time spent running and waiting while executing a call. It does not include the time a session waited for CPU resources. If |
|
|
|
Cumulative amount of active time (in milliseconds) consumed by the session (in its lifetime) |
|
|
|
Amount of time (in milliseconds) the current request from the session has been queued (in state |
|
|
|
Total amount of time (in milliseconds) the session has spent in the QUEUED state (in its lifetime) |
|
|
|
Number of times the session had to yield the CPU to other sessions (due to quantum expiration) while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. If |
|
|
|
Cumulative number of times the session had to yield CPU to other sessions due to quantum expiration (in its lifetime) |
|
|
|
Current amount (in KB) of undo consumed by the session; NULL if the current Resource Manager plan does not have an |
|
|
|
Maximum amount of undo consumed (in KB) during the session's lifetime. This value may not be updated because the current Resource Manager plan may not have an |
|
|
|
Number of times SQL queries running in the session were canceled due to exceeding the Resource Manager plan's |
|
|
|
Number of times requests from the session timed out because they queued longer than the Resource Manager plan's limit |
|
|
|
Number of times requests from the session were not run because the optimizer's estimated time to execute the query exceeded the |
|
|
|
Current I/O wait time of the session (in milliseconds) for the current SQL operation |
|
|
|
Cumulative amount of I/O wait time by the session (in its lifetime) (in milliseconds) |
|
|
|
Current I/O waits by session for the current SQL operation |
|
|
|
Cumulative I/O waits by session (in its lifetime) |
|
|
|
Number of single block megabytes read by the session for the current SQL operation |
|
|
|
Total number of single block megabytes read by the session (in its lifetime) |
|
|
|
Number of multiblock megabytes read by the session for the current SQL operation |
|
|
|
Total number of multiblock megabytes read by the session (in its lifetime) |
|
|
|
Number of single block megabytes written by the session for the current SQL operation |
|
|
|
Total number of single block megabytes written by the session (in its lifetime) |
|
|
|
Number of multiblock megabytes written by the session for the current SQL operation |
|
|
|
Total number of multiblock megabytes written by the session (in its lifetime) |
|
|
|
Number of single block read requests by the session for the current SQL operation |
|
|
|
Total number of single block read requests by the session (in its lifetime) |
|
|
|
Number of single block write requests by the session for the current SQL operation |
|
|
|
Total number of single block write requests by the session (in its lifetime) |
|
|
|
Number of multiblock read requests by the session for the current SQL operation |
|
|
|
Total number of multiblock read requests by the session (in its lifetime) |
|
|
|
Number of multiblock write requests by the session for the current SQL operation |
|
|
|
Total number of multiblock write requests by the session (in its lifetime) |
|
|
|
Amount of time that the current active parallel statement has been executing for the current SQL operation, not including the amount of time that the statement has been queued (in milliseconds). If the parallel statement is queued, then the value is 0. |
|
|
|
Cumulative amount of time that parallel statements have been executed over the lifetime of the session (in milliseconds) |
|
|
|
Degree of parallelism for the active or queued parallel statement, if there are any in the session |
|
|
|
The number of active parallel servers if the session is active and running the parallel query. If the query is queued, the number of parallel servers that this query is trying to run with is shown. |
|
|
|
Estimated execution time for the parallel statement, as estimated by the optimizer (in milliseconds). You can compare this value to |
|
|
|
Amount of time that the current parallel statement in the session has been queued (in milliseconds) for the current SQL operation. If the session does not have a queued parallel statement, then the value is 0. |
|
|
|
Total amount of time that the session has spent in the |
|
|
|
Number of times that parallel statements in the session have been queued |
|
|
|
Number of times that parallel statements in the session timed out because their queue time exceeded the Resource Manager plan's |
|
|
|
Indicates whether the session is actively running a parallel statement ( |
|
|
|
The status of the parallel statement running in this session:
|
|
|
|
Number of logical I/O requests by the session for the current SQL operation |
|
|
|
Total number of logical I/O requests in this session's lifetime |
|
|
|
Elapsed time of the session's current SQL operation |
|
|
|
Total elapsed time for all of this session's SQL operations in its lifetime |
|
|
|
The most recent action that was taken on this SQL operation by Resource Manager. Its value is one of the following:
For the last value, <CG NAME> is the name of the consumer group that the SQL operation was switched to. If the Resource Plan has since been changed then <CG NAME> is the ID of the consumer group. |
|
|
|
The reason for the most recent action that was taken on this SQL operation by Resource Manager. Its value is one of the following:
|
|
|
|
The time of the most recent action that was taken on this SQL operation by Resource Manager |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|