Oracle Useful Information

V$ table reference list

Updated : 1-January-1999
Version : 1.0

Description

This contains a list of all the Oracle 7 and Oracle 8 v$ tables groups by category..

V$ Table Reference

DATABASE BACKUPS, ARCHIVE FILES, AND RECOVERY

V$ARCHIVE				
V$ARCHIVED_LOG (V8)
V$ARCHIVE_DEST (V8)		
V$BACKUP
V$BACKUP_CORRUPTION (V8)	
V$BACKUP_DATAFILE (V8)
V$BACKUP_DEVICE (V8)		
V$BACKUP_PIECE (V8)
V$BACKUP_REDOLOG (V8)	
V$BACKUP_SET (V8)
V$DELETED_OBJECT (V8)		
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG			
V$RECOVERY_STATUS
V$RECOVER_FILE

CACHE MANAGEMENT

V$CACHE (V8)				
V$DB_OBJECT_CACHE
V$LIBRARYCACHE			
V$ROWCACHE
V$SUBCACHE (V8)

CONTROL FILES

V$CONTROLFILE	
V$CONTROLFILE_RECORD_SECTION (V8)

CURSORS AND SQL STATEMENTS

V$OPEN_CURSOR			
V$SQL
V$SQLAREA				
V$SQLTEXT
V$SQLTEXT_WITH_NEWLINES	
V$SQL_BIND_DATA (V8)
V$SQL_BIND_METADATA (V8)
V$SQL_CURSOR
V$SQL_SHARED_MEMORY

DATABASES AND INSTANCES

V$ACTIVE_INSTANCES		
V$BGPROCESS
V$BH (V8)				
V$COMPATIBILITY
V$COMPATSEG			
V$COPY_CORRUPTION (V8)
V$DATABASE				
V$DATAFILE
V$DATAFILE_COPY (V8)	
V$DATAFILE_HEADER (V8)
V$DBFILE			
V$DBLINK
V$DB_PIPES				
V$INSTANCE
V$LICENSE				
V$OFFLINE_RANGE (V8)
V$OPTION				
V$SGA
V$SGASTAT				
V$TABLESPACE (V8)
V$VERSION

SQL*LOADER DIRECT LOAD OPTION

V$LOADCSTAT	
V$LOADPSTAT (V8)
V$LOADTSTAT

FIXED VIEWS

V$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
V$INDEXED_FIXED_COLUMN

I/O

V$FILESTAT
V$WAITSTAT

LATCHES AND LOCKS

V$BUFFER_POOL (V8)		
V$CACHE_LOCK
V$CLASS_PING (V8)			
V$DLM_CONVERT_LOCAL (V8)
V$DLM_CONVERT_REMOTE (V8)	
V$DLM_LATCH (V8)
V$DLM_MISC (V8)			
V$ENQUEUE_LOCK (V8)
V$EVENT_NAME			
V$FALSE_PING 
V$FILE_PING (V8)			
V$LATCH
V$LATCHHOLDER			
V$LATCHNAME
V$LATCH_CHILDREN			
V$LATCH_MISSES
V$LATCH_PARENT			
V$LOCK
V$LOCK_ACTIVITY			
V$LOCK_ELEMENT
V$LOCKED_OBJECT			
V$LOCKS_WITH_COLLISIONS
V$PING				
V$RESOURCE
V$RESOURCE_LIMIT (V8)		
V$TRANSACTION_ENQUEUE (V8)
V$_LOCK				
V$_LOCK1

MISCELLANEOUS

V$TIMER
V$TYPE_SIZE
V$_SEQUENCES (V8)

MULTI-THREADED AND PARALLEL SERVERS

V$CIRCUIT				
V$DISPATCHER
V$DISPATCHER_RATE (V8)		
V$MTS
V$QUEUE				
V$REQDIST
V$SHARED_SERVER			
V$THREAD

OVERALL SYSTEM PERFORMANCE

V$GLOBAL_TRANSACTION (V8)	
V$OBJECT_DEPENDENCY
V$SHARED_POOL_RESERVED	
V$SORT_SEGMENT
V$SORT_USAGE (V8)			
V$STATNAME
V$SYSSTAT				
V$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT			
V$TRANSACTION

PARALLEL QUERY OPTION

V$EXECUTION			
V$EXECUTION_LOCATION (V8)
V$PQ_SESSTAT		
V$PQ_SLAVE
V$PQ_SYSSTAT		
V$PQ_TQSTAT

ORACLE PARAMETERS

V$NLS_PARAMETERS			
V$NLS_VALID_VALUES
V$PARAMETER			
V$SYSTEM_PARAMETER

REDO LOGS

V$LOG				
V$LOGFILE
V$LOGHIST			
V$LOG_HISTORY

ROLLBACK SEGMENTS

V$ROLLNAME
V$ROLLSTAT

SECURITY AND PRIVILEGES

V$ENABLEDPRIVS
V$PWFILE_USERS

SESSIONS

V$ACCESS				
V$MYSTAT
V$PROCESS				
V$SESSION
V$SESSION_CONNECT_INFO		
V$SESSION_CURSOR_CACHE
V$SESSION_EVENT			
V$SESSION_LONGOPS (V8)
V$SESSION_OBJECT_CACHE (V8)	
V$SESSION_WAIT
V$SESSTAT				
V$SESS_IO

Return to Index of SQL Scripts

Oracle Useful Information

V$ table reference list

Updated : 1-January-1999 Version : 1.0

Description

V$ Table Reference

Updated : 1-January-1999
Version : 1.0