Page 455
Object Purpose | Prefix | Object Name | Displays |
MISC | ALL, USER , DBA | _JOBS | Jobs in the job queue, including who submitted the job, when it was executed last, the next execution date, and the PL/SQL for the job (if the DBMS_JOB server package has been used to schedule jobs). |
MISC | ALL, USER, DBA | _TAB_COMMENTS | Comments on tables created using the COMMENT command. |
MISC | DEPTREE | Dependence between database objects. Created by the Oracle-supplied script utldtree.sql. | |
MISC | DUAL | Dummy table used in some SQL SELECT statements. | |
MISC | V$LOADCSTAT | Statistics on SQL*Loader direct load jobs, which bypass some of the architectural overheads of Oracle by doing more on SQL*Loader. This object is not useful, because the table cannot be accessed during load or afterward ”the data disappears. | |
MISC | V$LOADTSTAT | Used by SQL*Loader direct load jobs. No useful access can be made. See V$LOADCSTAT. | |
MISC | V$TIMER | Current time in hundredths of a second since midnight. | |
MON | DBA | _2PC_NEIGHBORS | Transactions involved in a distributed transaction if the distributed option is installed for the database server. Useful for the DBA when he must perform a manual recovery of a failed distributed transaction. |
MON | DBA | _2PC_PENDING | Transactions that failed during a distributed update operation if the Distributed Database option is installed. Includes a column that advises the DBA whether a commit or rollback should be forced. |
continues
Page 456
Table 19.2. continued
Object Purpose | Prefix | Object Name | Displays |
MON | DBA | _EXP_FILES | Information about full, cumulative, or incremental exports that have been performed against the database, including the name of the export file, the user doing the export, and the time of the export. |
MON | DBA | _EXP_OBJECTS | Objects taken by an incremental export. |
MON | DBA | _EXP_VERSION | Version number of the latest export. |
MON | DBA | _JOBS_RUNNING | Information about the jobs currently running that use the DBMS_JOB package, including the date when the job last ran and the time when it started to run for the current execution. |
MON | USER, DBA | _OBJECT_SIZE | Sizes, in bytes, of various PL/SQL objects, including the source and the parsed version. |
MON | V$ACCESS | Objects that currently are locked and by which sessions. | |
MON | V$ARCHIVE | Information about the archived redo log files for each thread of the database. | |
MON | V$BACKUP | Information about which database files have been backed up using online tablespace backup commands to do hot backups . It includes the time and the SCN (System Change Number) when the backup started. | |
MON | V$BGPROCESS | A description of the background processes and the latest error encountered with the background process. | |
MON | V$CIRCUIT | Information about which server and dispatcher processes used by the user server are processed when the multithreaded server configuration is used. |
Page 457
Object Purpose | Prefix | Object Name | Displays |
MON | V$COMPATIBILITY | Information about whether a downgrade to a previous re-lease is possible for this instance. This object might change when the instance is shut down and started up again. | |
MON | V$COMPATSEG | Information about which release of the software introduced the new features of the database. This object is used with v$compatibility. | |
MON | V$CONTROLFILE | Names and statuses of the control files. | |
MON | V$DATABASE | Name, creation date, database mode, and information about the last SCN archived and checkpointed. This information is gathered from the control file during instance startup. | |
MON | V$DATAFILE | Information about the database files, including each data file's current status, the size and name of the data file, and the SCN at the last checkpoint. | |
MON | V$DB_PIPES | Information on the database pipes currently in use, including the owner, on the database. | |
MON | V$DBLINK | All the database links currently open. | |
MON | V$DISPATCHER | Information on the status of the dispatcher processes and the amount of use when running the instance with the multithreaded server setup. Also includes information useful in deciding whether to increase or reduce the number of dispatcher processes. | |
MON | V$INSTANCE | Status of the current instance, including whether it was started with RESTRICTED SESSION and whether it currently is being shut down. |
continues
Page 458
Table 19.2. continued
Object Purpose | Prefix | Object Name | Displays |
MON | V$LATCHHOLDER | Which processes and latches currently are being held. | |
MON | V$LICENSE | Information to help you determine whether the number of concurrent user limits for your license is being breached. Also shows the maximum number of simultaneous user connections since this instance started. | |
MON | V$LOCK | Information about the locks currently taken out on this instance, including locks taken out by user processes and locks taken out by the system processes. | |
MON | V$LOG | Information about the online redo log groups currently defined, including the log sequence number and archive status. This information is obtained from the control file. | |
MON | V$LOG_HISTORY | Information about when the redo log files were archived to the archive destination and the name of the archived file. Ensures that archived files are not created too frequently or infrequently. It is useful for determining which redo log files to apply during a recovery procedure. | |
MON | V$LOGFILE | Information about log files, including the status of the redo log file and the group to which the log file belongs. | |
MON | V$MTS | Information about the performance of the multithreaded server, including how many shared server processes were started automatically. | |
MON | V$NLS_PARAMETERS | Values set for the national language support for the whole instance. |
Page 459
Object Purpose | Prefix | Object Name | Displays |
MON | V$OBJECT_DEPENDENCY | Dependencies on objects currently loaded in the shared pool area. | |
MON | V$PROCESS | Which processes currently are connected to the instance, including the operating system process ID and the background processes. | |
MON | V$PWFILE_USERS | Users who have been given the SYSDBA and SYSOPER privileges. | |
MON | V$RECOVER_FILE | Information about files that must go through a media-recovery process. | |
MON | V$RECOVERY_LOG | Information about the number and names of the archive logs needed to get the database files back into synchronization. Used while a media recovery is in progress. It is a subset of the information in the v$log_history view. | |
MON | V$RESOURCE | Information about database resources. | |
MON | V$ROLLNAME | Names of the currently active rollback segments. | |
MON | V$SESSION | Information about each of the sessions connected to the instance. | |
MON | V$SQLTEXT | SQL text of SQL statements in the shared cursors in the SGA. | |
MON | V$SQLTEXT_WITH_NEWLINES | Similar to V$SQLTEXT but with newline and tab characters to improve legibility. | |
MON | V$THREAD | Information about the threads that are using the database if it is running in Parallel Server mode with many instances. |
continues