Broken down wait class shows the same information
Displaying Session-Related Statistics |
---|
Displaying Session-Related Statistics
You can display current session information for each user logged on by querying V$SESSION. For example, you can use V$SESSION to determine whether a session represents a user session, or was created by a database server process (BACKGROUND).
You can also query the V$SESSMETRIC view to display the performance metric values for all active sessions. This view lists performance metrics such as CPU usage, number of physical reads, number of hard parses, and the logical read ratio.
Oracle Database 10g: Administration Workshop II 9-13
|
---|
Oracle Database 10g: Administration Workshop II 9-14