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.