Session Information (ORCL)

From DBArtisan
Jump to: navigation, search

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

  1. On the Utilities menu, select Session Information.
    DBArtisan opens the User Session Information dialog.
  2. Complete the User Session Information Dialog Box.
  3. When you finish viewing SQL, click Close to return to the User Session Information dialog.
  4. When you finish viewing the session information, click Close.