Dynamic performance views

Dynamic performance views (V$) are owned by SYS. The dynamic performance views maintained by the Oracle database instance reflect various database metrics since the time when the instance was started. There are three categories of V$ views: current state views, accumulated views, and information views.

The following is a list of a few important V$ views with a short description of each:

• V$VERSION: displays database version details

• V$LOCK: lists details of currently held locks in the database

• V$PROCESS: displays information about currently active processes

• V$SESSION: sessions currently connected to the database

• V$SESSION_EVENT: provides information about the event that each session is waiting for

• V$SESSION_WAIT: displays information about wait events for which active sessions are currently waiting

• V$SESSTAT: displays statistics for all the sessions connected to the database

• V$SQL: displays statistics on each shared SQL cursor

• V$SQLTEXT: displays...