Session Information (ORCL)
Go Up to Data, Schema, and Miscellaneous Utilities
Oracle tracks detailed information about the resources used by each session on a database. This information is useful for analyzing resource utilization patterns between user sessions to monitor performance.
The information displayed is derived from the Oracle system tables, SYS.V_$STATNAME and SYS.V_$SESSTAT. Consult the Oracle documentation or detailed descriptions in the meanings of each session parameter.
- Tip: Waits lets you analyze bottlenecks and discover what a database is waiting on.
Viewing Session Information
- On the Utilities menu, select Session Information.
- DBArtisan opens the User Session Information dialog.
- Complete the User Session Information Dialog Box.
- When you finish viewing SQL, click Close to return to the User Session Information dialog.
- When you finish viewing the session information, click Close.