First page Back Continue Last page Graphics

Dynamic Performance Views


Notes:

Dynamic performance views are updated at startup time and usually throughout the life of the instance. The names of these views always starts with “V$” (There are also like-named views whose names start with the characters “GV$”. These are used for the global, Real Application Clusters version of the view).
The following is a brief description of some common dynamic views. We will use these views in the upcoming lessons in this course:
V$PARAMETER contains one row for every database initialization parameter and includes parameter name, current value and indicates if the parameter can be dynamically modified.
V$DATABASE – Contains one row describing the database state including database name, database ID (DBID), creation date, archivelog mode and checkpoint information used in recovery.
V$INSTANCE – Contains one row describing the current instance. Contains instance name, host (server) name and status (open, mount, nomount).
V$SESSION – Contains one row for every active session, including database background processes.
Notes for this slide continue on the next page…