-
Book Overview & Buying
-
Table Of Contents
Oracle Database XE 11gR2 Jump Start Guide
By :
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...
Change the font size
Change margin width
Change background colour