top of page

Oracle AD Views


Statistics on the number of performed insert, update, delete operations to a specific table. Automatic monitoring of work


This view contains the names of the system views and their brief description.


Shows information about the locks that are currently being applied to library cache objects


Shows the correspondence between the names and numbers of all instances currently in the mounted database


Shows information about all active services in the database.


Shows the available methods for distributing active resource pool sessions.


Shows snapshots of active database sessions taken approximately once per second. This view includes sessions for which the pending event at the time of the snapshot does not belong to the Idle class.


Shows information about the progress of the Advisor.


Shows statistics for queues in the database.


Shows information about redo log files in need of archiving.
Each line shows information for one stream only.
This information is also available in the V$LOG view recommended for queries instead of V$ARCHIVE.


Shows, for the current instance, all destinations in the Data Guard configuration, including the current value of each destination, its mode, and status.
The view displays several locations (directories, services) where log files will be copied after archiving, as well as the status and mode in which these destinations are located (available, disabled, inactive, etc.). The number of lines displayed is the same as the number of LOG_ARCHIVE_DEST_n initialization parameters.


Shows information about archive intervals on the standby database. This view can be used to find out the current archive span that is blocking recovery.


Shows the ARCH status of instance processes.


Shows information about archived logs. The data is taken from the control file and includes the names of the logs. An entry in the view appears only when the online log is archived or cleared (in the latter case, the NAME field will be NULL). If the log is archived twice, then the view will have two entries with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name.
An archived log entry also appears in the view whenever the archived files are restored from a backup or when a copy of the log is made with the RMAN COPY command.


Shows encryption information for each mounted Oracle ACFS.


Shows snapshot information for each mounted Oracle ACFS.


Shows information about mounted Oracle ACFS volumes associated with V$ASM_FILESYSTEM


Displays one row for each alias in each disk group that has been mounted in an Automatic Storage Management instance. In a normal instance, this view is empty.


Shows one line for each set attribute. In addition to the attributes set by the CREATE DISKGROUP and ALTER DISKGROUP statements, the view can show other attributes that are automatically generated.
Attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.


In an ASM instance, the view identifies databases using the disk groups that the ASM instance manages. In a database instance, the view shows information about the ASM instance if the database has any open ASM file.


Shows one row for each disk that ASM detects, including disks that are not part of a disk group.


Shows disk I / O statistics information for each ASM client. A database instance displays information for that instance only.


Shows performance statistics in the same way as V$ASM_DISK does, but does not detect new disks. Since no disks have been detected, the information in this view does not include disk data that is new to the system.


Displays one row for each ASM diskgroup discovered by the ASM instance on the node.


Shows performance statistics in the same way as V$ASM_DISKGROUP does, but does not detect new disk groups. Since no disk discovery has been performed, the information in this view does not include disk group information that is new to the system.


Shows information for each mounted Oracle ACFS.


In an instance, ASM displays one row for each active, long-running operation. The view shows nothing in the database instance.


In an instance, ASM displays one row for each template in each disk group mounted in ASM. The database instance displays one row for each template in each disk group mounted in the ASM instance that the database instance communicates with.


Shows the names of operating system users, mounted database instances, and file owners.


Shows the creator for each ASM File Access Control group.


Shows the members of each ASM File Access Control group.


Shows the aggregation operators available in analytical workspaces.


Shows the distribution of operators available in analytical workspaces.


Shows a report on the performance of the various caches used by Oracle OLAP during dynamic aggregation.


Shows information about the status of active SQL cursors triggered in the analytic workspace.


Shows a list of active sessions and their use with analytic workspaces. A string is generated whenever an analytic workspace is created or attached. The first line for the session is created when the first command is executed. The view also contains information about the SYS.EXPRESS workspace, which is automatically attached per session. Rows associated with a specific analytic workspace are removed when the workspace is detached from the session or the session has ended.


Shows information about each active session. Transaction is the only exchange between the client session and Oracle OLAP. Composite commands can be executed within a single transaction.


Shows the backup status of all online data files. In the normal state, all files are displayed in the NOT ACTIVE view, that is, no backup is performed.


The view contains information about all recoverable archived logs. Includes all archived logs copied to the backup set or to the Proxy copy.


Shows summary information based on archived logs in backup sets or proxy copies.


Shows performance information about ongoing and recently completed RMAN backups and restores. For each backup, the view contains one row for each input data file, one row for the aggregate total performance of all data files, and one row for the backup portion. Data is not persistently stored, nor is it persistent when the instance is restarted.


Shows information about restored control files. The information includes all the backup control files in the backup set, the mapping copy, and the proxy copy.


Shows summary information of control files based on either file backup, mapping copies, or proxy copies.


Shows summary information for the output data file and the control file copy.


Shows information about the area of ​​the bad block in the backup data files, taken from the control file. Note: This corruption is not carried over to the control file and archived logs.


Shows information about control files and data files in backup sets taken from the control file.



Shows information about recoverable data files. The information will include all the backup data files in the backup set, the mapping copy, and the proxy copy.


Shows summary information for a specific set of criteria based on the backup job, the time range applicable to the jobs, and a specific data file.


Shows information about supported backup devices. If the device type is not supported by the named device, then the view displays one line with the device type and a null device name. If the device type supports named devices, then one row is returned for each available device of that type. The special DISK device type is not returned by this view because this device is always available.


Shows information about all RMAN backups (mapping copies and backup sets) and also displays a list of archived log files.
This view emulates the RMAN commands LIST BACKUP and LIST COPY. The view requires the database to be installed using the DBMS_RCVMAN.SETDATABASE procedure.


Shows information about the fragments of backups (from the control file). Each backup set consists of one or more fragments.


Shows information about all available backup fragments.


Shows information about all archive logs in backup sets (from the control file).


Shows information about backup sets (from a control file). A backup set entry was inserted after the backup set was successfully completed.


Shows detailed information about the backup set. This view contains an additional line for each backup session that performs a BACKUP BACKUPSET (that is, creates new copies for the same backup set, or copies the backup set information from disk to tape). In this case, the values ​​of other columns of the row will belong to the full backup set.


Shows summary information for the backup set.



Displays information about the server parameter files in backup sets (from the control file).


Shows information about all recoverable server parameter files copied to backup sets.


Shows summary information about server parameter files based on either the backup job or the time range applicable to the jobs.


Shows information about ongoing and recently completed RMAN backups and restorations. For each backup, the view contains one line for each input data file, one line for all data files, and one line for each output fragment of the backups. This data is not permanently stored, and is not retained when the instance is restarted.


Shows information about background processes.



Shows the status and number of pings for each buffer in the SGA.


Shows the block change tracking status for the database.


Shows a session that is blocking, or may block a quiesce operation.


The view displays statistics for the Block Server Process (BSPn) used in the Fusion cache.


Shows information about all buffer pools available for an instance.


Shows statistics for all buffer pools available for the instance.


Shows information about all buffered publishers in an instance. One line per sender queue. The values ​​are cleared to zero when the instance is rebooted.


Shows information about all buffer queues in the instance. One line per queue.


Shows subscriber information for all buffered queues in an instance. One line for each subscriber in the queue.


Shows information from the header of each SGA of the current instance. The blocks in this view correspond to database objects.


The view is deprecated. Information from it is now displayed in the V$INSTANCE_CACHE_TRANSFER and V$SEGMENT_STATISTICS views.


The view is identical to V $ CACHE, but only shows blocks that have been unloaded from the cache at least once.


The view is not documented, but is related in some way to Automatic Workload Manager.


Shows information about valid pipes, which are user connections to the database (via dispatcher and server processes).


The view is deprecated. Information from it is now displayed in the V$INSTANCE_CACHE_TRANSFER and V$SEGMENT_STATISTICS views.


Shows the values ​​of statistics collected for sessions with a client ID. The statistics available in this view are a subset of the data in the V$SESSTAT and V$SESS_TIME_MODEL views.


Shows one or more connections that are used for cluster communication.



Shows all connections that Oracle knows about.


Shows the attributes set in the current session.


Shows the names of control files


Shows information about records of sections of the control file.


Shows information about the corruption of copies of data files (from the control file).


Shows identifiers (XIDs) of corrupted transactions.


Shows information about the pool-to-connection class of the Database Resident Connection Pooling.


Displays information about the connection class level statistics of a persistent connection pool database.


Shows information about each connection to a connection broker.


Shows information about database persistent pool statistics.


Shows statistics of the Global Cache Service processes (LMS) used in cache synchronization.


Shows information about the database (from the control file).


Shows information about database blocks that have been corrupted since the last backup.


Shows information about all database incarnations. Oracle creates a new incarnation whenever the database is opened with the RESETLOGS option. Records of current and previous incarnations are also contained in the V $ DATABASE view.


Shows information about data files (from control file).


Shows information about copying data files (from control file).


Shows information about data files (from data file headers).


Shows the unique database names defined in the initialization parameters DB_UNIQUE_NAME and LOG_ARCHIVE_CONFIG, allowing any database in configuration to view the Data Guard environment.
The first line of the view displays the unique name of the current database that was specified in the initialization parameter DB_UNIQUE_NAME. The additional lines reflect the unique names of other databases that were specified with the DG_CONFIG keyword in the LOG_ARCHIVE_CONFIG initialization parameter.


Shows information about the Data Guard metrics (only on the standby database).


Shows messages recently written to the alert log or server process trace files regarding physical database standby or redo transport for all standby types.


Shows information that predicts the number of physical reads for various cache sizes. For each size, a "physical read factor" is calculated, which is the ratio of the number of estimated and actual reads that the real cache buffer performs during the measurement interval.


Displays database objects that are cached in the library cache. Objects include tables, indexes, clusters, synonyms, PL / SQL procedures, packages and triggers


Displays the channels that are currently represented in the shared pool for this instance.


Shows all platforms to which the database can be transported using the RMAN CONVERT DATABASE command. The database transport function only supports transports of the same endian platform. Therefore, the V$DB_TRANSPORTABLE_PLATFORM view shows fewer rows than the V$TRANSPORTABLE_PLATFORM view.


Shows all data files that make up the database. Obsolete. It is recommended to use V $ DATAFILE instead.


Describes all database links (links with IN_TRANSACTION = YES) opened by the sessions making the request. These database links must be committed or rolled back before being closed.


Shows information about deleted archived logs, data file copies and backup parts (from the control file). The sole purpose of this view is to optimize the resynchronization operation of the recovery directory. When an archived log, a copy of a data file, or a backup part is deleted, the corresponding entry is marked as deleted.


The view is not described in the documentation. Supposedly showing information about disconnected sessions.


The view is not described in the documentation. Presumably shows information about the location of the most important ADR (Automatic Diagnostic Repository) directories.


Shows information about manager processes.


Shows information about dispatching configurations and their attributes.


Displays high-speed performance statistics of active dispatcher processes. The collected samples have a certain lifetime (TTL_columns). Statistics are shown in the context of two types of time intervals:
Current statistics (CUR_ columns). Current statistics use samples collected over the last lifetime.
Historical statistics (AVG_, and most of the max_ columns). Historical statistics use all samples that no longer exist.
During statistics collection, the sample is always current. After the expiration of the lifetime, the sample becomes historical. Each activity factor has a specific scale (represented by SCALE_ columns) based on which statistics are displayed.


Shows information about Oracle process connections (pipes) open to NFS servers.


Shows information about Oracle process files opened via Direct NFS.


Shows information about available Direct NFS servers.


Shows statistics about Oracle process NFS operations performed over Direct NFS.


Shows statistical information about dynamic remastering processes. All temporal statistics are given in hundredths of a second. The statistic totals reflect what has been collected since the start of the instance.

bottom of page