The Top Blocked Objects collection provides a list of top blocked objects for TX locks.
The number of waits for a specific segment during the selected time range |
The Top Sessions collection provides instance current sessions details.
The currently executing action name set by DBMS_APPLICATION_INFO.SET_MODULE | |
The amount of CPU time used by a session from the time a user call starts until it ends | |
The amount of time used by a session from the time a user call starts until it ends | |
The client information; contains the information set by DBMS_APPLICATION_INFO.SET_CLIENT_INFO | |
The number of times a consistent read was requested for a block by this session | |
The number of times a current block was requested by this session | |
Time spent waiting for the CPU to process SQL statements and other types of calls made to Oracle | |
The number of logical writes performed by the session since login. | |
The currently executing module name, set by DBMS_APPLICATION_INFO.SET_MODULE. | |
The Parallel Query status; can have one of the following values: ENABLED — the session is in a Parallel Query enabled mode DISABLED — the Parallel Query enabled mode is not supported for the session FORCED — the session has been altered to force Parallel Query) | |
In multitenant architectures, the name of the pluggable database | |
The number of physical writes carried out by the session since logon | |
The amount of redo entries issues by the session since logon | |
The operating system process ID for the Oracle shadow process. | |
The currently executing action name, set by DBMS_APPLICATION_INFO.SET_MODULE. | |
The gap (by a percentage) between the average number of rows per fetch that the array can hold, as defined in the arraysize parameter of the various fetch operations of the specified SQL query, and the number of rows actually retrieved. For example: if the average setting of the arraysize parameter was 5, and the average number of rows actually retrieved per operation was 10, the value indicated will be 50. | |
CPU time used by this cursor for parsing, executing, and fetching | |
Elapsed time used by this cursor for parsing, executing, and fetching | |
Number of executions that took place on this object since it was brought into the library cache | |
The average number of fetches per a single execution associated with the SQL statement | |
The average number of loads per a single execution associated with the SQL statement | |
Total time spent waiting for buffer gets on all SQL statements other than the selected statement. | |
Total CPU time consumed for executing all SQL statements other than the selected statement. | |
The total number of disk reads carried out by all SQL statements except the selected statement. | |
Number of executions that took place on this object since it was brought into the library cache. | |
Total time spent on wait events due to executing all SQL statements except the selected statement. | |
Total number of executions performed by Parallel execution servers. | |
The average number of sorts per a single execution associated with the SQL statement | |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center