oracle视图大全

视图大全
Advisors	Information related to cache advisors V$ Views: V$PGA_TARGET_ADVICE, V$PGA_TARGET_ADVICE_HISTOGRAM, V$MTTR_TARGET_ADVICE, V$PX_BUFFER_ADVICE, V$DB_CACHE_ADVICE, V$SHARED_POOL_ADVICE, V$JAVA_POOL_ADVICE, V$STREAMS_POOL_ADVICE (10.2), V$SGA_TARGET_ADVICE (10.2), and V$ADVISOR_PROGRESS (10.2)
ASM	V$ASM_ALIAS (10.1), V$ASM_CLIENT(10.1), V$ASM_DISK(10.1), V$ASM_DISK_STAT(10.2), V$ASM_DISKGROUP(10.1), V$ASM_DISKGROUP_STAT(10.2), V$ASM_FILE(10.1), V$ASM_OPERATION(10.1), V$ASM_TEMPLATE(10.1)
Backup/recovery	Information related to database backups and recovery, including last backup, archive logs, state of files for backup, and recovery V$ Views: V$ARCHIVE, V$ARCHIVED_LOG, V$ARCHIVE_DEST, V$ARCHIVE_DEST_STATUS , V$ARCHIVE_GAP , V$ARCHIVE_PROCESSES, V$BACKUP, V$BACKUP_ASYNC_IO, V$BACKUP_CORRUPTION, V$BACKUP_DATAFILE, V$BACKUP_DEVICE, V$BACKUP_PIECE, V$BACKUP_REDOLOG, V$BACKUP_SET, V$BACKUP_SYNC_IO, V$BLOCK_CHANGE_TRACKING, V$COPY_CORRUPTION, V$DATABASE_BLOCK_CORRUPTION, V$DATABASE_INCARNATION, V$DATAFILE_COPY, V$DELETED_OBJECT, V$FAST_START_SERVERS, V$FAST_START_TRANSACTIONS, V$INSTANCE_RECOVERY, V$MTTR_TARGET_ADVICE, V$PROXY_ARCHIVEDLOG, V$PROXY_DATAFILE, V$RMAN_CONFIGURATION , V$RECOVERY_FILE_STATUS, V$RECOVERY_LOG, V$RECOVERY_PROGRESS, V$RECOVERY_STATUS, V$RECOVER_FILE, V$BACKUP_ARCHIVELOG_DETAILS(10.2), V$BACKUP_ARCHIVELOG_SUMMARY(10.2), V$BACKUP_CONTROLFILE_DETAILS(10.2), V$BACKUP_CONTROLFILE_SUMMARY(10.2), V$BACKUP_COPY_DETAILS(10.2), V$BACKUP_COPY_SUMMARY(10.2), V$BACKUP_FILES(10.1), V$BACKUP_PIECE_DETAILS(10.2), V$BACKUP_SET_DETAILS(10.2), V$BACKUP_SET_SUMMARY(10.2), V$BACKUP_SPFILE, V$BACKUP_SPFILE_DETAILS(10.2), V$BACKUP_SPFILE_SUMMARY(10.2), V$DATAFILE_HEADER, V$FLASH_RECOVERY_AREA_USAGE(10.2), V$FLASHBACK_DATABASE_LOG(10.1), V$FLASHBACK_DATABASE_STAT(10.1), V$OBSOLETE_BACKUP_FILES, V$OFFLINE_RANGE, V$PROXY_ARCHIVELOG_DETAILS(10.2), V$PROXY_ARCHIVELOG_SUMMARY(10.2), V$PROXY_COPY_DETAILS(10.2), V$PROXY_COPY_SUMMARY(10.2), V$RECOVERY_FILE_DEST(10,1), V$RESTORE_POINT(10.2), V$RMAN_BACKUP_JOB_DETAILS(10.2), V$RMAN_BACKUP_SUBJOB_DETAILS(10.2), V$RMAN_BACKUP_TYPE(10.2), V$RMAN_ENCRYPTION_ALGORITHMS(10.2), V$RMAN_OUTPUT(10.1), V$RMAN_STATUS(10.1), V$UNUSABLE_BACKUPFILE_DETAILS(10.2)
Caches	Information related to the various caches, including objects, library, cursors, and the dictionary V$ Views: V$ACCESS, V$BUFFER_POOL, V$BUFFER_POOL_STATISTICS, V$DB_CACHE_ADVICE, V$DB_OBJECT_CACHE, V$JAVA_POOL_ADVICE, V$LIBRARYCACHE, V$LIBRARY_CACHE_MEMORY, V$PGASTAT, V$PGA_TARGET_ADVICE, V$PGA_TARGET_ADVICE_HISTOGRAM, V$ROWCACHE, V$ROWCACHE_PARENT, V$ROWCACHE_SUBORDINATE, V$SESSION_CURSOR_CACHE, V$SGA, V$SGASTAT, V$SGA_CURRENT_RESIZE_OPS, V$SGA_DYNAMIC_COMPONENTS, V$SGA_DYNAMIC_FREE_MEMORY, V$SGA_RESIZE_OPS, V$SGAINFO, V$SHARED_POOL_ADVICE, V$SHARED_POOL_RESERVED, V$SYSTEM_CURSOR_CACHE, V$SUBCACHE, V$JAVA_LIBRARY_CACHE_MEMORY(10.1), V$PROCESS_MEMORY(10.2), V$SGA_TARGET_ADVICE(10.2)
Cache Fusion/RAC	V$ACTIVE_INSTANCES, V$BH, V$CLUSTER_INTERCONNECTS(10.2), V$CONFIGURED_INTERCONNECTS(10.2), V$CR_BLOCK_SERVER, V$CURRENT_BLOCK_SERVER(10.1), V$GC_ELEMENT, VGCSHVMASTER_INFO, V$GCSPFMASTER_INFO, V$GES_BLOCKING_ENQUEUE, V$GES_CONVERT_LOCAL, V$GES_CONVERT_REMOTE, V$GES_ENQUEUE, V$GES_LATCH, V$GES_RESOURCE, V$GES_STATISTICS, V$HVMASTER_INFO, V$INSTANCE_CACHE_TRANSFER, V$RESOURCE_LIMIT
Control files	Information related to instance control files V$ Views: V$CONTROLFILE, V$CONTROLFILE_RECORD_SECTION
Cursors/SQL statements	Information related to cursors and SQL statements, including the open cursors, statistics, and actual SQL text V$ Views: V$OPEN_CURSOR, V$SQL, V$SQLAREA, V$SQLTEXT, V$SQLTEXT_WITH_NEWLINES, V$SQL_BIND_DATA, V$SQL_BIND_METADATA, V$SQL_CURSOR, V$SQL_OPTIMIZER_ENV, V$SQL_PLAN, V$SQL_PLAN_STATISTICS, V$SQL_PLAN_STATISTICS_ALL, V$SQL_REDIRECTION, V$SESSION_CURSOR_CACHE, V$SQL_SHARED_CURSOR, V$SQL_SHARED_MEMORY, V$SQL_WORKAREA, V$SQL_WORKAREA_ACTIVE, V$SQL_WORKAREA_HISTOGRAM, V$SYSTEM_CURSOR_CACHE V$MUTEX_SLEEP(10.2), V$MUTEX_SLEEP_HISTORY(10.2) (for those dubious shared latches), V$SQL_BIND_CAPTURE(10.1), V$SQL_JOIN_FILTER(10.2), V$SQL_AREA_PLAN_HASH(10.2), V$SQLSTATS(10.2), V$SYS_OPTIMIZER_ENV(10.1), V$VPD_POLICY
Database instances	Information related to the actual database instance V$ Views: V$ACTIVE_INSTANCES, V$BGPROCESS, V$DATABASE, V$INSTANCE, V$PROCESS, V$SGA, V$SGASTAT, V$BLOCKING_QUIESCE(10.2), V$CLIENT_STATS(10.1) RAC Views: V$BH, V$ACTIVE_INSTANCES
Direct Path Operations	Information related to the SQL*Loader direct load option V$ Views: V$LOADISTAT, V$LOADPSTAT
Distributed/ Heterogeneous Services	V$ Views: V$DBLINK, V$GLOBAL_TRANSACTION, V$GLOBAL_BLOCKED_LOCKS, V$HS_AGENT, V$HS_PARAMETER, V$HS_SESSION
Fixed view	Information related to the v$ tables themselves V$ Views: V$FIXED_TABLE, V$FIXED_VIEW_DEFINITION, V$INDEXED_FIXED_COLUMN
General	General information related to various system information V$ Views: V$DBPIPES, V$CONTEXT, V$GLOBALCONTEXT, V$LICENSE, V$OPTION, V$RESERVED_WORDS, V$TIMER, V$TIMEZONE_NAMES, V$TYPE_SIZE, V$_SEQUENCES, and V$VERSION. V$DB_TRANSPORTABLE_PLATFORM(10.2), V$TRANSPORTABLE_PLATFORM(10.1), and V$SCHEDULER_RUNNING_JOBS(10.2)
I/O	Information related to I/O, including files and statistics V$ Views: V$DBFILE, V$FILESTAT, V$WAITSTAT, V$TEMPSTAT, V$FILE_HISTOGRAM(10.1), V$FILEMETRIC(10.1), V$FILEMETRIC_HISTORY(10.1), V$SYSAUX_OCCUPANTS(10.1). V$TABLESPACE, V$TEMP_HISTOGRAM(10.1), V$TEMP_SPACE_HEADER, V$TEMPFILE, V$TEMPSEG_USAGE
Latches/locks	Information related to latches and locks V$ Views: V$ENQUEUE_LOCK, V$ENQUEUE_STAT, V$EVENT_NAME, V$FILE_CACHE_TRANSFER, V$GLOBAL_BLOCKED_LOCKS, V$LATCH, V$LATCHHOLDER, V$LATCHNAME, V$LATCH_CHILDREN, V$LATCH_MISSES, V$LATCH_PARENT, V$LOCK, V$LOCKED_OBJECT, V$RESOURCE, V$RESOURCE_LIMIT, V$TRANSACTION_ENQUEUE, V$_LOCK, V$_LOCK1, V$ENQUEUE_STATISTICS. RAC Views: V$CR_BLOCK_SERVER, V$GCSHVMASTER_INFO, V$GCSPFMASTER_INFO, V$GC_ELEMENT, V$GES_BLOCKING_ENQUEUE, V$GES_ENQUEUE, V$HVMASTER_INFO, V$GES_LATCH, V$GES_RESOURCES
Log Miner	Information related to Log Miner V$ Views: V$LOGMNR_CALLBACK, V$LOGMNR_CONTENTS, V$LOGMNR_DICTIONARY, V$LOGMNR_LATCH, V$LOGMNR_LOGFILE, V$LOGMNR_LOGS, V$LOGMNR_PARAMETERS, V$LOGMNR_PROCESS, V$LOGMNR_REGION, V$LOGMNR_SESSION, V$LOGMNR_STATS, V$LOGMNR_TRANSACTION, V$LOGMNR_DICTIONARY_LOAD(10.2)
Metrics	Information related to Metrics (ALL New in 10g!) V$ Views: V$METRICNAME, V$SERVICEMETRIC, V$EVENTMETRIC, V$FILEMETRIC, V$FILEMETRIC_HISTORY, V$SERVICEMETRIC_HISTORY, V$SESSMETRIC, V$SYSMETRIC, V$SYSMETRIC_HISTORY, V$SYSMETRIC_SUMMARY, V$THRESHOLD_TYPES, V$WAITCLASSMETRIC, V$WAITCLASSMETRIC_HISTORY
Multithreaded/ shared servers	Information related to multithreaded and parallel servers, including connections, queues, dispatchers, and shared servers V$ Views: V$CIRCUIT, V$DISPATCHER, V$DISPATCHER_RATE, V$QUEUE, V$QUEUEING_MTH, V$REQDIST, V$SHARED_SERVER, V$SHARED_SERVER_MONITOR, V$DISPATCHER_CONFIG(10.1)
Object Usage	Information related to object use and dependencies V$ Views: V$OBJECT_DEPENDENCY, V$OBJECT_USAGE
Overall system	Information related to the overall system performance V$ Tables: V$GLOBAL_TRANSACTION, V$SHARED_POOL_RESERVED, V$RESUMABLE, V$SORT_SEGMENT, V$TEMPSEG_USAGE, V$STATNAME, V$SYS_OPTIMIZER_ENV, V$SYS_TIME_MODEL, V$SYSSTAT, V$SYSTEM_CURSOR_CACHE, V$SYSTEM_EVENT, V$TEMPFILE, V$TEMPORARY_LOBS, V$TEMP_EXTENT_MAP, V$TEMP_EXTENT_POOL, V$TEMP_SPACE_HEADER, V$TRANSACTION, V$ALERT_TYPES(10.1), V$EVENT_HISTOGRAM(10.1), V$OSSTAT(10.1), V$SYSTEM_WAIT_CLASS(10.1), V$TEMP_HISTOGRAM(10.1), V$XML_AUDIT_TRAIL
Parallel Query	Information related to the Parallel Query option V$ Views: V$EXECUTION, V$PARALLEL_DEGREE_LIMIT_MTH, V$PQ_SESSTAT, V$PQ_SLAVE, V$PQ_SYSSTAT, V$PQ_TQSTAT, V$PX_PROCESS, V$PX_PROCESS_SYSSTAT, V$PX_SESSION, V$PX_SESSTAT
Parameters	Information related to various Oracle parameters, including initialization and NLS per session V$ Views: V$NLS_PARAMETERS, V$NLS_VALID_VALUES, V$OBSOLETE_PARAMETER, V$PARAMETER, V$PARAMETER2, V$SPPARAMETER, V$SYSTEM_PARAMETER, V$SYSTEM_PARAMETER2, V$PARAMETER_VALID_VALUES(10.2)
Redo logs	Information related to redo logs, including statistics and history V$ Views: V$LOG, V$LOGFILE, V$LOGHIST, V$LOG_HISTORY, V$THREAD (RAC related)
Replication and materialized views	Information related to replication and materialized views V$ Views: V$MVREFRESH , V$REPLPROP, V$REPLQUEUE
Resource Manager	Information related to resource management V$ Views: V$ACTIVE_SESSION_POOL_MTH, V$ACTIVE_SESSION_POOL_HISTORY, V$RSRC_CONS_GROUP_HISTORY(10.2), V$RSRC_CONSUMER_GROUP, V$RSRC_CONSUMER_GROUP_CPU_MTH, V$RSRC_PLAN, V$RSRC_PLAN_CPU_MTH, V$RSRC_PLAN_HISTORY(10.2), V$RSRC_SESSION_INFO(10.2)
Rollback segments And Undo	Information on rollback segments, including statistics and transactions V$ Views: V$ROLLNAME, V$ROLLSTAT, V$TRANSACTION, V$UNDOSTAT
Security/privileges	Information related to security V$ Views: V$ENABLEDPRIVS, V$PWFILE_USERS, V$VPD_POLICY, V$WALLET(10.2), and V$XML_AUDIT_TRAIL(10.2)
Sessions (includes some replication information and heterogeneous services)	Information related to a session, including object access, cursors, processes, and statistics V$ Views: V$ACTIVE_SESSION_HISTORY, V$MYSTAT, V$PROCESS, V$SESS_TIME_MODEL, V$SESSION, V$SESSION_CONNECT_INFO, V$SESSION_CURSOR_CACHE, V$SESSION_EVENT, V$SESSION_LONGOPS, V$SESSION_OBJECT_CACHE, V$SESSION_WAIT, V$SESSION_WAIT_CLASS, V$SESSION_WAIT_HISTORY, V$SESSTAT, V$SESS_IO, V$SES_OPTIMIZER_ENV, V$SESSMETRIC, and V$CLIENT_STATS, and V$TSM_SESSIONS(10.2)
Services (all new for 10.1)	V$ACTIVE_SERVICES, V$SERV_MOD_ACT_STATS, V$SERVICE_EVENT, V$SERVICE_STATS, V$SERVICE_WAIT_CLASS, V$SERVICES
Sorting	Information related to sorting V$ Views: V$SORT_SEGMENT, V$TEMPSEG_USAGE, V$TEMP_EXTENT_MAP, V$TEMP_EXTENT_POOL, V$TEMP_HISTOGRAM(10.1), V$TEMP_SPACE_HEADER, V$TEMPFILE, V$TEMPSTAT
Standby databases (Data Guard)	Information related to standby databases V$ Views: V$DATAGUARD_STATUS, V$LOGSTDBY, V$LOGSTDBY_STATS, V$MANAGED_STANDBY, V$STANDBY_LOG, V$DATAGUARD_CONFIG(10.1), V$DATAGUARD_STATS(10.2), V$LOGSTDBY_PROCESS(10.2), V$LOGSTDBY_PROGRESS(10.2), V$LOGSTDBY_STATE(10.2), V$LOGSTDBY_TRANSACTION(10.2)
File mapping interface	Information related to file mapping V$ Views: V$MAP_COMP_LIST, V$MAP_ELEMENT, V$MAP_EXT_ELEMENT, V$MAP_FILE, V$MAP_FILE_EXTENT, V$MAP_FILE_IO_STACK, V$MAP_LIBRARY, and V$MAP_SUBELEMENT
Streams	Information related to streams V$ Views: V$AQ,V$STREAMS_APPLY_COORDINATOR, V$STREAMS_APPLY_READER, V$STREAMS_APPLY_SERVER, V$STREAMS_CAPTURE, V$BUFFERED_PUBLISHERS(10.1), V$BUFFERED_QUEUES(10.1), V$BUFFERED_SUBSCRIBERS(10.1), V$PROPAGATION_RECEIVER(10.1), V$PROPAGATION_SENDER(10.1), V$RULE(10.1), V$RULE_SET(10.1), V$RULE_SET_AGGREGATE_STATS(10.1), V$STREAMS_TRANSACTION(10.2)
Statistics	Information related to statistics in general V$ Views: V$SEGMENT_STATISTICS, V$SEGSTAT, V$SEGSTAT_NAME, V$STATISTICS_LEVEL, V$STATNAME, V$WAITSTAT
Transactions	Information related to transactions in general V$ Views: V$GLOBAL_TRANSACTION, V$LOGSTDBY_TRANSACTION, V$RESUMABLE, V$STREAMS_TRANSACTION, V$TRANSACTION, V$TRANSACTION_ENQUEUE