Oracle Database System Views | CerebroSQL
top of page
CerebroSQL

Oracle AD Views

dba_tab_modifications

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

DICTIONARY

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

V$ACCESS

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

V$ACTIVE_INSTANCES

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

V$ACTIVE_SERVICES

Shows information about all active services in the database.

V$ACTIVE_SESS_POOL_MTH

Shows the available methods for distributing active resource pool sessions.

V$ACTIVE_SESSION_HISTORY

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.

V$ADVISOR_PROGRESS

Shows information about the progress of the Advisor.

V$AQ

Shows statistics for queues in the database.

V$ARCHIVE

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.

V$ARCHIVE_DEST

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.

V$ARCHIVE_DEST_STATUS

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.

V$ARCHIVE_PROCESSES

Shows the ARCH status of instance processes.

V$ARCHIVED_LOG

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.

V$ASM_ACFS_ENCRYPTION_INFO

Shows encryption information for each mounted Oracle ACFS.

V$ASM_ACFSSNAPSHOTS

Shows snapshot information for each mounted Oracle ACFS.

V$ASM_ACFSVOLUMES

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

V$ASM_ALIAS

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.

V$ASM_ATTRIBUTE

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.

V$ASM_CLIENT

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.

V$ASM_DISK

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

V$ASM_DISK_IOSTAT

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

V$ASM_DISK_STAT

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.

V$ASM_DISKGROUP

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

V$ASM_DISKGROUP_STAT

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.

V$ASM_FILESYSTEM

Shows information for each mounted Oracle ACFS.

V$ASM_OPERATION

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

V$ASM_TEMPLATE

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.

V$ASM_USER

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

V$ASM_USERGROUP

Shows the creator for each ASM File Access Control group.

V$ASM_USERGROUP_MEMBER

Shows the members of each ASM File Access Control group.

V$AW_AGGREGATE_OP

Shows the aggregation operators available in analytical workspaces.

V$AW_ALLOCATE_OP

Shows the distribution of operators available in analytical workspaces.

V$AW_CALC

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

V$AW_LONGOPS

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

V$AW_OLAP

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.

V$AW_SESSION_INFO

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.

V$BACKUP

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.

V$BACKUP_ARCHIVELOG_DETAILS

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

V$BACKUP_ARCHIVELOG_SUMMARY

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

V$BACKUP_ASYNC_IO

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.

V$BACKUP_CONTROLFILE_DETAILS

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.

V$BACKUP_CONTROLFILE_SUMMARY

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

V$BACKUP_COPY_SUMMARY

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

V$BACKUP_CORRUPTION

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.

V$BACKUP_DATAFILE

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

 

V$BACKUP_DATAFILE_DETAILS

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.

V$BACKUP_DATAFILE_SUMMARY

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.

V$BACKUP_DEVICE

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.

V$BACKUP_FILES

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.

V$BACKUP_PIECE

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

V$BACKUP_PIECE_DETAILS

Shows information about all available backup fragments.

V$BACKUP_REDOLOG

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

V$BACKUP_SET

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

V$BACKUP_SET_DETAILS

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.

V$BACKUP_SET_SUMMARY

Shows summary information for the backup set.

 

V$BACKUP_SPFILE

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

V$BACKUP_SPFILE_DETAILS

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

V$BACKUP_SPFILE_SUMMARY

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

V$BACKUP_SYNC_IO

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.

V$BGPROCESS

Shows information about background processes.

 

V$BH

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

V$BLOCK_CHANGE_TRACKING

Shows the block change tracking status for the database.

V$BLOCKING_QUIESCE

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

V$BSP

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

V$BUFFER_POOL

Shows information about all buffer pools available for an instance.

V$BUFFER_POOL_STATISTICS

Shows statistics for all buffer pools available for the instance.

V$BUFFERED_PUBLISHERS

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.

V$BUFFERED_QUEUES

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

V$BUFFERED_SUBSCRIBERS

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

V$CACHE

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

V$CACHE_LOCK

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

V$CACHE_TRANSFER

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

V$CALLTAG

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

V$CIRCUIT

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

V$CLASS_CACHE_TRANSFER

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

V$CLIENT_STATS

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.

V$CLUSTER_INTERCONNECTS

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

 

V$CONFIGURED_INTERCONNECTS

Shows all connections that Oracle knows about.

V$CONTEXT

Shows the attributes set in the current session.

V$CONTROLFILE

Shows the names of control files

V$CONTROLFILE_RECORD_SECTION

Shows information about records of sections of the control file.

V$COPY_CORRUPTION

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

V$CORRUPT_XID_LIST

Shows identifiers (XIDs) of corrupted transactions.

V$CPOOL_CC_INFO

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

V$CPOOL_CC_STATS

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

V$CPOOL_CONN_INFO

Shows information about each connection to a connection broker.

V$CPOOL_STATS

Shows information about database persistent pool statistics.

V$CR_BLOCK_SERVER

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

V$DATABASE

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

V$DATABASE_BLOCK_CORRUPTION

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

V$DATABASE_INCARNATION

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.

V$DATAFILE

Shows information about data files (from control file).

V$DATAFILE_COPY

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

V$DATAFILE_HEADER

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

V$DATAGUARD_CONFIG

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.

V$DATAGUARD_STATS

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

V$DATAGUARD_STATUS

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

V$DB_CACHE_ADVICE

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.

V$DB_OBJECT_CACHE

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

V$DB_PIPES

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

V$DB_TRANSPORTABLE_PLATFORM

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.

V $ DBFILE

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

V$DBLINK

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.

V$DELETED_OBJECT

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.

V$DETACHED_SESSION

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

V$DIAG_INFO

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

V$DISPATCHER

Shows information about manager processes.

V$DISPATCHER_CONFIG

Shows information about dispatching configurations and their attributes.

V$DISPATCHER_RATE

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.

V$DNFS_CHANNELS

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

V$DNFS_FILES

Shows information about Oracle process files opened via Direct NFS.

V$DNFS_SERVERS

Shows information about available Direct NFS servers.

V$DNFS_STATS

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

V$DYNAMIC_REMASTER_STATS

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