0455-0459

Previous Table of Contents Next

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 
Previous Table of Contents Next


Oracle Unleashed
Oracle Development Unleashed (3rd Edition)
ISBN: 0672315750
EAN: 2147483647
Year: 1997
Pages: 391

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net