Oracle 11gR1
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 |
|
|
| 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. |
|
|
| 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. |
|
|
| Current state of the session: · · · · · · · · · · |
|
|
| Indicates whether the session is currently active ( · Session is in the top call · Session has a transaction in progress · Session is using temporary space objects · Session holds user enqueues |
|
|
| Number of seconds the session has been idle (in states |
|
|
| Amount of time the session has waited for CPU because of resource management (in state |
|
|
| Cumulative amount of time 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 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) |
|
|
| Amount of time 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 consumed by the session (in its lifetime) |
|
|
| Amount of time the current request from the session has been queued (in state |
|
|
| Total amount of time 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) |
|
|
| Cumulative amount of I/O wait time by the session (in its lifetime) |
|
|
| Current I/O waits by session |
|
|
| Cumulative I/O waits by session (in its lifetime) |
|
|
| Number of single block megabytes read by the session |
|
|
| Total number of single block megabytes read by the session (in its lifetime) |
|
|
| Number of multiblock megabytes read by the session |
|
|
| Total number of multiblock megabytes read by the session (in its lifetime) |
|
|
| Number of single block megabytes written by the session |
|
|
| Total number of single block megabytes written by the session (in its lifetime) |
|
|
| Number of multiblock megabytes written by the session |
|
|
| Total number of multiblock megabytes written by the session (in its lifetime) |
|
|
| Number of single block read requests by the session |
|
|
| Total number of single block read requests by the session (in its lifetime) |
|
|
| Number of single block write requests by the session |
|
|
| Total number of single block write requests by the session (in its lifetime) |
|
|
| Number of multiblock read requests by the session |
|
|
| Total number of multiblock read requests by the session (in its lifetime) |
|
|
| Number of multiblock write requests by the session |
|
|
| Total number of multiblock write requests by the session (in its lifetime) |
Note:
The following query identifies CPU usage Per schema in a simple resource plan scenario (Metalink note 728613.1):
select sum(r.CONSUMED_CPU_TIME) "CONSUMED CPU TIME" , s.username "SCHEMA"
from V$RSRC_SESSION_INFO r, v$session s
where r.sid = s.sid group by username;
No comments:
Post a Comment