Table of Contents
- Title and Copyright Information
- About This Content
- What's New
-
1
System Tables and Views
- Overview of System Tables and Views
- Primary System Tables
- System Tables of Secondary Importance
- Static Data Dictionary Views
- GV$ and V$ Views
- SYS.ALL_ARGUMENTS
- SYS.ALL_DEPENDENCIES
- SYS.ALL_DIRECTORIES
- SYS.ALL_ERRORS
- SYS.ALL_IDENTIFIERS
- SYS.ALL_OBJECTS
- SYS.ALL_PLSQL_OBJECT_SETTINGS
- SYS.ALL_PROCEDURES
- SYS.ALL_SOURCE
- SYS.ALL_STORED_SETTINGS
- SYS.ALL_SYNONYMS
- SYS.ALL_TABLES
- SYS.ALL_TAB_PRIVS
- SYS.ALL_TAB_SIZES
- SYS.ALL_USERS
- SYS.ALL_VIEWS
- SYS.CACHE_GROUP
- SYS.COLUMNS
- SYS.COL_STATS
- SYS.DBA_ARGUMENTS
- SYS.DBA_DEPENDENCIES
- SYS.DBA_DIRECTORIES
- SYS.DBA_ERRORS
- SYS.DBA_IDENTIFIERS
- SYS.DBA_OBJECTS
- SYS.DBA_OBJECT_SIZE
- SYS.DBA_PLSQL_OBJECT_SETTINGS
- SYS.DBA_PROCEDURES
- SYS.DBA_PROFILES
- SYS.DBA_SOURCE
- SYS.DBA_STORED_SETTINGS
- SYS.DBA_SYNONYMS
- SYS.DBA_SYS_PRIVS
- SYS.DBA_TABLES
- SYS.DBA_TAB_PRIVS
- SYS.DBA_TAB_SIZES
- SYS.DBA_USERS
- SYS.DBA_VIEWS
- SYS.DUAL
- SYS.GV$BACKUP_STATUS
- SYS.GV$BLOCK_INFO
- SYS.GV$BOOKMARK
- SYS.GV$CACHE_GROUP_INTERVAL_STATS
- SYS.GV$CACHE_GROUP_STATS
- SYS.GV$CKPT_CONFIG
- SYS.GV$CKPT_HISTORY
- SYS.GV$COMMIT_BUFFER_STATS
- SYS.GV$CONFIGURATION
- SYS.GV$CONTEXT
- SYS.GV$DATASTORE_STATUS
- SYS.GV$DB_COMPACT_CONFIG
- SYS.GV$DB_CONFIG
- SYS.GV$DB_WRTE_CONCURRENCY_MODE
- SYS.GV$DEADLOCKCYCLES
- SYS.GV$DEADLOCKS
- SYS.GV$DEADLOCKVICTIMS
- SYS.GV$DISTRIBUTION_CURRENT
- SYS.GV$DISTRIBUTION_MAP
- SYS.GV$DISTRIBUTION_STATE
- SYS.GV$DISTRIBUTION_VERSION
- SYS.GV$EPOCH_LATEST
- SYS.GV$EPOCH_SESSION
- SYS.GV$ERROR
- SYS.GV$EXECUTION_TIME_HISTOGRAM
- SYS.GV$GRIDSTATS
- SYS.GV$HEAP_INFO
- SYS.GV$HOST_NAME
- SYS.GV$INDEX_ADVICE_OUTPUT
- SYS.GV$LATCH_STATS
- SYS.GV$LOG_HOLDS
- SYS.GV$MONITOR
- SYS.GV$OPT_COL_STATS
- SYS.GV$OPT_FLAG
- SYS.GV$OPT_JOIN_ORDER
- SYS.GV$OPT_MAX_CMD_FREELIST_CNT
- SYS.GV$OPT_ORDER
- SYS.GV$OPT_STATS
- SYS.GV$PLSQL_MEMORY_STATS
- SYS.GV$REDUNDANT_INDEX
- SYS.GV$SQL_CMD_CACHE
- SYS.GV$SQL_CMD_CACHE_INFO
- SYS.GV$SQL_CMD_QUERY_PLAN
- SYS.GV$STATS_CONFIG
- SYS.GV$SYSTEMSTATS
- SYS.GV$TABLE_SIZES
- SYS.GV$TTSTATS_AGGR_SCHEDULES
- SYS.GV$TTSTATS_ALERTS
- SYS.GV$TTSTATS_CKPTHIST_HIST
- SYS.GV$TTSTATS_CPU_HIST
- SYS.GV$TTSTATS_DISK_HIST
- SYS.GV$TTSTATS_ELEMENT_AGGR
- SYS.GV$TTSTATS_ELEMENT_METRICS
- SYS.GV$TTSTATS_GENERIC_HIST
- SYS.GV$TTSTATS_LOGHOLD_HIST
- SYS.GV$TTSTATS_NETWORK_HIST
- SYS.GV$TTSTATS_SNAPSHOT_ANNOTATION
- SYS.GV$TTSTATS_SQL_COMMAND_HIST
- SYS.GV$TTSTATS_TOP_SQL_CMD_TEXT
- SYS.GV$TTSTATS_TXN_LOG_HIST
- SYS.GV$TTSTATS_VMEM_HIST
- SYS.GV$VERSION
- SYS.GV$XACT_ID
- SYS.INDEXES
- SYS.MONITOR
- SYS.PLAN
- SYS.PUBLIC_DEPENDENCY
- SYS.SEQUENCES
- SYS.SYSTEMSTATS
- SYS.TABLES
- SYS.TBL_STATS
- SYS.TCOL_STATS
- SYS.TINDEXES
- SYS.TRANSACTION_LOG_API
- SYS.TTABLES
- SYS.TTBL_STATS
- SYS.USER_ARGUMENTS
- SYS.USER_DEPENDENCIES
- SYS.USER_ERRORS
- SYS.USER_IDENTIFIERS
- SYS.USER_OBJECTS
- SYS.USER_OBJECT_SIZE
- SYS.USER_PASSWORD_LIMITS
- SYS.USER_PLSQL_OBJECT_SETTINGS
- SYS.USER_PROCEDURES
- SYS.USER_SOURCE
- SYS.USER_STORED_SETTINGS
- SYS.USER_SYNONYMS
- SYS.USER_SYS_PRIVS
- SYS.USER_TABLES
- SYS.USER_TAB_PRIVS
- SYS.USER_TAB_SIZES
- SYS.USER_USERS
- SYS.USER_VIEWS
- SYS.V$BACKUP_STATUS
- SYS.V$BLOCK_INFO
- SYS.V$BOOKMARK
- SYS.V$CACHE_GROUP_INTERVAL_STATS
- SYS.V$CACHE_GROUP_STATS
- SYS.V$CKPT_CONFIG
- SYS.V$CKPT_HISTORY
- SYS.V$COMMIT_BUFFER_STATS
- SYS.V$CONFIGURATION
- SYS.V$CONTEXT
- SYS.V$DATASTORE_STATUS
- SYS.V$DB_COMPACT_CONFIG
- SYS.V$DB_CONFIG
- SYS.V$DB_WRTE_CONCURRENCY_MODE
- SYS.V$DEADLOCKCYCLES
- SYS.V$DEADLOCKS
- SYS.V$DEADLOCKVICTIMS
- SYS.V$DISTRIBUTION_CURRENT
- SYS.V$DISTRIBUTION_MAP
- SYS.V$DISTRIBUTION_STATE
- SYS.V$DISTRIBUTION_VERSION
- SYS.V$EPOCH_LATEST
- SYS.V$EPOCH_SESSION
- SYS.V$ERROR
- SYS.V$EXECUTION_TIME_HISTOGRAM
- SYS.V$GRIDSTATS
- SYS.V$HEAP_INFO
- SYS.V$HOST_NAME
- SYS.V$INDEX_ADVICE_OUTPUT
- SYS.V$LATCH_STATS
- SYS.V$LOG_HOLDS
- SYS.V$MONITOR
- SYS.V$OPT_COL_STATS
- SYS.V$OPT_FLAG
- SYS.V$OPT_JOIN_ORDER
- SYS.V$OPT_MAX_CMD_FREELIST_CNT
- SYS.V$OPT_ORDER
- SYS.V$OPT_STATS
- SYS.V$PLSQL_MEMORY_STATS
- SYS.V$REDUNDANT_INDEX
- SYS.V$REPSTATS
- SYS.V$SESSION
- SYS.V$SQL_CMD_CACHE
- SYS.V$SQL_CMD_CACHE_INFO
- SYS.V$SQL_CMD_QUERY_PLAN
- SYS.V$STATS_CONFIG
- SYS.V$SYSTEMSTATS
- SYS.V$TABLE_SIZES
- SYS.V$TTSTATS_AGGR_SCHEDULES
- SYS.V$TTSTATS_ALERTS
- SYS.V$TTSTATS_CKPTHIST_HIST
- SYS.V$TTSTATS_CPU_HIST
- SYS.V$TTSTATS_DISK_HIST
- SYS.V$TTSTATS_ELEMENT_AGGR
- SYS.V$TTSTATS_ELEMENT_METRICS
- SYS.V$TTSTATS_GENERIC_HIST
- SYS.V$TTSTATS_LOGHOLD_HIST
- SYS.V$TTSTATS_NETWORK_HIST
- SYS.V$TTSTATS_SNAPSHOT_ANNOTATION
- SYS.V$TTSTATS_SQL_COMMAND_HIST
- SYS.V$TTSTATS_TOP_SQL_CMD_TEXT
- SYS.V$TTSTATS_TXN_LOG_HIST
- SYS.V$TTSTATS_VMEM_HIST
- SYS.V$VERSION
- SYS.V$XACT_ID
- SYS.VIEWS
- SYS.XLASUBSCRIPTIONS
- 2 Replication Tables