Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database Reference?

• Oracle Database 11g Release 1 (11.1) New Features

Part I Initialization Parameters

1 Initialization Parameters

• Uses of Initialization Parameters
  • Types of Initialization Parameters
    • Derived Parameters
    • Operating System-Dependent Parameters
    • Variable Parameters
• Basic Initialization Parameters
• Parameter Files
  • Server Parameter Files
  • Initialization Parameter Files
    • Specifying Values in an Initialization Parameter File
• Changing Parameter Values in a Parameter File
  • Parameters by Functional Category
  • Modifiable Parameters
  • Displaying Current Parameter Values
  • Parameters You Should Not Specify in the Parameter File
  • When Parameters Are Set Incorrectly
• Reading the Parameter Descriptions
• Initialization Parameter Descriptions
• ACTIVE_INSTANCE_COUNT
• AQ_TM_PROCESSES
• ARCHIVE_LAG_TARGET
• ASM_DISKGROUPS
• ASM_DISKSTRING
• ASM_POWER_LIMIT
• ASM_PREFERRED_READ_FAILURE_GROUPS
• AUDIT_FILE_DEST
• AUDIT_SYS_OPERATIONS
• AUDIT_SYSLOG_LEVEL
• AUDIT_TRAIL
• BACKGROUND_CORE_DUMP
• BACKGROUND_DUMP_DEST
• BACKUP_TAPE_IO_SLAVES
• BITMAP_MERGE_AREA_SIZE
• BLANK_TRIMMING
• CIRCUITS
• CLIENT_RESULT_CACHE_LAG
• CLIENT_RESULT_CACHE_SIZE
• CLUSTER_DATABASE
• CLUSTER_DATABASE_INSTANCES
• CLUSTER_INTERCONNECTS
• COMMIT_LOGGING
• COMMIT_POINT_STRENGTH
• COMMIT_WAIT
• COMMIT_WRITE
• COMPATIBLE
• CONTROL_FILE_RECORD_KEEP_TIME
• CONTROL_FILES
• CONTROL_MANAGEMENT_PACK_ACCESS
• CORE_DUMP_DEST
• CPU_COUNT
• CREATE_BITMAP_AREA_SIZE
• CREATE_STORED_OUTLINES
• CURSOR_SHARING
• CURSOR_SPACE_FOR_TIME
• DB_nK_CACHE_SIZE
• DB_BLOCK_BUFFERS
• DB_BLOCK_CHECKING
• DB_BLOCK_CHECKSUM
• DB_BLOCK_SIZE
• DB_CACHE_ADVICE
• DB_CACHE_SIZE
• DB_CREATE_FILE_DEST
• DB_CREATE_ONLINE_LOG_DEST_n
• DB_DOMAIN
• DB_FILE_MULTIBLOCK_READ_COUNT
• DB_FILE_NAME_CONVERT
• DB_FILES
• DB_FLASHBACK_RETENTION_TARGET
• DB_KEEP_CACHE_SIZE
• DB_LOST_WRITE_PROTECT
• DB_NAME
• DB_RECOVERY_FILE_DEST
• DB_RECOVERY_FILE_DEST_SIZE
• DB_RECYCLE_CACHE_SIZE
• DB_SECUREFILE
• DB_ULTRA_SAFE
• DB_UNIQUE_NAME
• DB_WRITER_PROCESSES
• DBWR_IO_SLAVES
• DDL_LOCK_TIMEOUT
• DG_BROKER_CONFIG_FILEn
• DG_BROKER_START
• DIAGNOSTIC_DEST
• DISK_ASYNCH_IO
• DISPATCHERS
• DISTRIBUTED_LOCK_TIMEOUT
• DML_LOCKS
• EVENT
• FAL_CLIENT
• FAL_SERVER
• FAST_START_MTTR_TARGET
• FAST_START_PARALLEL_ROLLBACK
• FILE_MAPPING
• FILEIO_NETWORK_ADAPTERS
• FILESYSTEMIO_OPTIONS
• FIXED_DATE
• GC_FILES_TO_LOCKS
• GCS_SERVER_PROCESSES
• GLOBAL_CONTEXT_POOL_SIZE
• GLOBAL_NAMES
• GLOBAL_TXN_PROCESSES
• HASH_AREA_SIZE
• HI_SHARED_MEMORY_ADDRESS
• HS_AUTOREGISTER
• IFILE
• INSTANCE_GROUPS
• INSTANCE_NAME
• INSTANCE_NUMBER
• INSTANCE_TYPE
• JAVA_JIT_ENABLED
• JAVA_MAX_SESSIONSPACE_SIZE
• JAVA_POOL_SIZE
• JAVA_SOFT_SESSIONSPACE_LIMIT
• JOB_QUEUE_PROCESSES
• LARGE_POOL_SIZE
• LDAP_DIRECTORY_ACCESS
• LDAP_DIRECTORY_SYSAUTH
• LICENSE_MAX_SESSIONS
• LICENSE_MAX_USERS
• LICENSE_SESSIONS_WARNING
• LOCAL_LISTENER
• LOCK_NAME_SPACE
• LOCK_SGA
• LOG_ARCHIVE_CONFIG
• LOG_ARCHIVE_DEST
• LOG_ARCHIVE_DEST_n
• LOG_ARCHIVE_DEST_STATE_n
• LOG_ARCHIVE_DUPLEX_DEST
• LOG_ARCHIVE_FORMAT
• LOG_ARCHIVE_LOCAL_FIRST
• LOG_ARCHIVE_MAX_PROCESSES
• LOG_ARCHIVE_MIN_SUCCEED_DEST
• LOG_ARCHIVE_TRACE
• LOG_BUFFER
• LOG_CHECKPOINT_INTERVAL
• LOG_CHECKPOINT_TIMEOUT
• LOG_CHECKPOINTS_TO_ALERT
• LOG_FILE_NAME_CONVERT
• MAX_COMMIT_PROPAGATION_DELAY
• MAX_DISPATCHERS
• MAX_DUMP_FILE_SIZE
• MAX_ENABLED_ROLES
• MAX_SHARED_SERVERS
• MEMORY_MAX_TARGET
• MEMORY_TARGET
• NLS_CALENDAR
• NLS_COMP
• NLS_CURRENCY
• NLS_DATE_FORMAT
• NLS_DATE_LANGUAGE
• NLS_DUAL_CURRENCY
• NLS_ISO_CURRENCY
• NLS_LANGUAGE
• NLS_LENGTH_SEMANTICS
• NLS_NCHAR_CONV_EXCP
• NLS_NUMERIC_CHARACTERS
• NLS_SORT
• NLS_TERRITORY
• NLS_TIMESTAMP_FORMAT
• NLS_TIMESTAMP_TZ_FORMAT
• O7_DICTIONARY_ACCESSIBILITY
• OBJECT_CACHE_MAX_SIZE_PERCENT
• OBJECT_CACHE_OPTIMAL_SIZE
• OLAP_PAGE_POOL_SIZE
• OPEN_CURSORS
• OPEN_LINKS
• OPEN_LINKS_PER_INSTANCE
• OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
• OPTIMIZER_DYNAMIC_SAMPLING
• OPTIMIZER_FEATURES_ENABLE
• OPTIMIZER_INDEX_CACHING
• OPTIMIZER_INDEX_COST_ADJ
• OPTIMIZER_MODE
• OPTIMIZER_SECURE_VIEW_MERGING
• OPTIMIZER_USE_INVISIBLE_INDEXES
• OPTIMIZER_USE_PENDING_STATISTICS
• OPTIMIZER_USE_SQL_PLAN_BASELINES
• OS_AUTHENT_PREFIX
• OS_ROLES
• PARALLEL_ADAPTIVE_MULTI_USER
• PARALLEL_AUTOMATIC_TUNING
• PARALLEL_EXECUTION_MESSAGE_SIZE
• PARALLEL_INSTANCE_GROUP
• PARALLEL_IO_CAP_ENABLED
• PARALLEL_MAX_SERVERS
• PARALLEL_MIN_PERCENT
• PARALLEL_MIN_SERVERS
• PARALLEL_THREADS_PER_CPU
• PGA_AGGREGATE_TARGET
• PLSCOPE_SETTINGS
• PLSQL_CCFLAGS
• PLSQL_CODE_TYPE
• PLSQL_DEBUG
• PLSQL_NATIVE_LIBRARY_DIR
• PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT
• PLSQL_OPTIMIZE_LEVEL
• PLSQL_V2_COMPATIBILITY
• PLSQL_WARNINGS
• PRE_PAGE_SGA
• PROCESSES
• QUERY_REWRITE_ENABLED
• QUERY_REWRITE_INTEGRITY
• RDBMS_SERVER_DN
• READ_ONLY_OPEN_DELAYED
• RECOVERY_PARALLELISM
• RECYCLEBIN
• REDO_TRANSPORT_USER
• REMOTE_DEPENDENCIES_MODE
• REMOTE_LISTENER
• REMOTE_LOGIN_PASSWORDFILE
• REMOTE_OS_AUTHENT
• REMOTE_OS_ROLES
• REPLICATION_DEPENDENCY_TRACKING
• RESOURCE_LIMIT
• RESOURCE_MANAGER_CPU_ALLOCATION
• RESOURCE_MANAGER_PLAN
• RESULT_CACHE_MAX_RESULT
• RESULT_CACHE_MAX_SIZE
• RESULT_CACHE_MODE
• RESULT_CACHE_REMOTE_EXPIRATION
• RESUMABLE_TIMEOUT
• ROLLBACK_SEGMENTS
• SEC_CASE_SENSITIVE_LOGON
• SEC_MAX_FAILED_LOGIN_ATTEMPTS
• SEC_PROTOCOL_ERROR_FURTHER_ACTION
• SEC_PROTOCOL_ERROR_TRACE_ACTION
• SEC_RETURN_SERVER_RELEASE_BANNER
• SERIAL_REUSE
• SERVICE_NAMES
• SESSION_CACHED_CURSORS
• SESSION_MAX_OPEN_FILES
• SESSIONS
• SGA_MAX_SIZE
• SGA_TARGET
• SHADOW_CORE_DUMP
• SHARED_MEMORY_ADDRESS
• SHARED_POOL_RESERVED_SIZE
• SHARED_POOL_SIZE
• SHARED_SERVER_SESSIONS
• SHARED_SERVERS
• SKIP_UNUSABLE_INDEXES
• SMTP_OUT_SERVER
• SORT_AREA_RETAINED_SIZE
• SORT_AREA_SIZE
• SPFILE
• SQL_TRACE
• SQL92_SECURITY
• SQLTUNE_CATEGORY
• STANDBY_ARCHIVE_DEST
• STANDBY_FILE_MANAGEMENT
• STAR_TRANSFORMATION_ENABLED
• STATISTICS_LEVEL
• STREAMS_POOL_SIZE
• TAPE_ASYNCH_IO
• THREAD
• TIMED_OS_STATISTICS
• TIMED_STATISTICS
• TRACE_ENABLED
• TRACEFILE_IDENTIFIER
• TRANSACTIONS
• TRANSACTIONS_PER_ROLLBACK_SEGMENT
• UNDO_MANAGEMENT
• UNDO_RETENTION
• UNDO_TABLESPACE
• USE_INDIRECT_DATA_BUFFERS
• USER_DUMP_DEST
• UTL_FILE_DIR
• WORKAREA_SIZE_POLICY
• XML_DB_EVENTS

Part II Static Data Dictionary Views

2 Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES

• About Static Data Dictionary Views
  • Oracle Replication Views
  • Oracle Workspace Manager Views
  • Recovery Catalog Views
• Static Data Dictionary View Descriptions
• ALL_ALL_TABLES
• ALL_APPLY
• ALL_APPLY_CONFLICT_COLUMNS
• ALL_APPLY_DML_HANDLERS
• ALL_APPLY_ENQUEUE
• ALL_APPLY_ERROR
• ALL_APPLY_EXECUTE
• ALL_APPLY_KEY_COLUMNS
• ALL_APPLY_PARAMETERS
• ALL_APPLY_PROGRESS
• ALL_APPLY_TABLE_COLUMNS
• ALL_ARGUMENTS
• ALL_ASSEMBLIES
• ALL_ASSOCIATIONS
• ALL_AUDIT_POLICIES
• ALL_AUDIT_POLICY_COLUMNS
• ALL_AW_PS
• ALL_AWS
• ALL_BASE_TABLE_MVIEWS
• ALL_CAPTURE
• ALL_CAPTURE_EXTRA_ATTRIBUTES
• ALL_CAPTURE_PARAMETERS
• ALL_CAPTURE_PREPARED_DATABASE
• ALL_CAPTURE_PREPARED_SCHEMAS
• ALL_CAPTURE_PREPARED_TABLES
• ALL_CATALOG
• ALL_CHANGE_PROPAGATION_SETS
• ALL_CHANGE_PROPAGATIONS
• ALL_CHANGE_SETS
• ALL_CHANGE_SOURCES
• ALL_CHANGE_TABLES
• ALL_CLUSTER_HASH_EXPRESSIONS
• ALL_CLUSTERS
• ALL_COL_COMMENTS
• ALL_COL_PENDING_STATS
• ALL_COL_PRIVS
• ALL_COL_PRIVS_MADE
• ALL_COL_PRIVS_RECD
• ALL_COLL_TYPES
• ALL_CONS_COLUMNS
• ALL_CONS_OBJ_COLUMNS
• ALL_CONSTRAINTS
• ALL_CONTEXT
• ALL_CUBE_ATTR_VISIBILITY
• ALL_CUBE_ATTRIBUTES
• ALL_CUBE_BUILD_PROCESSES
• ALL_CUBE_CALCULATED_MEMBERS
• ALL_CUBE_DIM_LEVELS
• ALL_CUBE_DIM_MODELS
• ALL_CUBE_DIM_VIEW_COLUMNS
• ALL_CUBE_DIM_VIEWS
• ALL_CUBE_DIMENSIONALITY
• ALL_CUBE_DIMENSIONS
• ALL_CUBE_HIER_LEVELS
• ALL_CUBE_HIER_VIEW_COLUMNS
• ALL_CUBE_HIER_VIEWS
• ALL_CUBE_HIERARCHIES
• ALL_CUBE_MEASURES
• ALL_CUBE_VIEW_COLUMNS
• ALL_CUBE_VIEWS
• ALL_CUBES
• ALL_DB_LINKS
• ALL_DEF_AUDIT_OPTS
• ALL_DEPENDENCIES
• ALL_DEQUEUE_QUEUES
• ALL_DIM_ATTRIBUTES
• ALL_DIM_CHILD_OF
• ALL_DIM_HIERARCHIES
• ALL_DIM_JOIN_KEY
• ALL_DIM_LEVEL_KEY
• ALL_DIM_LEVELS
• ALL_DIMENSIONS
• ALL_DIRECTORIES
• ALL_ENCRYPTED_COLUMNS
• ALL_ERRORS
• ALL_EVALUATION_CONTEXT_TABLES
• ALL_EVALUATION_CONTEXT_VARS
• ALL_EVALUATION_CONTEXTS
• ALL_EXTERNAL_LOCATIONS
• ALL_EXTERNAL_TABLES
• ALL_FILE_GROUP_EXPORT_INFO
• ALL_FILE_GROUP_FILES
• ALL_FILE_GROUP_TABLES
• ALL_FILE_GROUP_TABLESPACES
• ALL_FILE_GROUP_VERSIONS
• ALL_FILE_GROUPS
• ALL_IDENTIFIERS
• ALL_IND_COLUMNS
• ALL_IND_EXPRESSIONS
• ALL_IND_PARTITIONS
• ALL_IND_PENDING_STATS
• ALL_IND_STATISTICS
• ALL_IND_SUBPARTITIONS
• ALL_INDEXES
• ALL_INDEXTYPE_ARRAYTYPES
• ALL_INDEXTYPE_COMMENTS
• ALL_INDEXTYPE_OPERATORS
• ALL_INDEXTYPES
• ALL_INTERNAL_TRIGGERS
• ALL_JAVA_ARGUMENTS
• ALL_JAVA_CLASSES
• ALL_JAVA_COMPILER_OPTIONS
• ALL_JAVA_DERIVATIONS
• ALL_JAVA_FIELDS
• ALL_JAVA_IMPLEMENTS
• ALL_JAVA_INNERS
• ALL_JAVA_LAYOUTS
• ALL_JAVA_METHODS
• ALL_JAVA_NCOMPS
• ALL_JAVA_RESOLVERS
• ALL_JAVA_THROWS
• ALL_JOBS
• ALL_JOIN_IND_COLUMNS
• ALL_LIBRARIES
• ALL_LOB_PARTITIONS
• ALL_LOB_SUBPARTITIONS
• ALL_LOB_TEMPLATES
• ALL_LOBS
• ALL_LOG_GROUP_COLUMNS
• ALL_LOG_GROUPS
• ALL_MEASURE_FOLDER_CONTENTS
• ALL_MEASURE_FOLDERS
• ALL_METHOD_PARAMS
• ALL_METHOD_RESULTS
• ALL_MINING_MODEL_ATTRIBUTES
• ALL_MINING_MODEL_SETTINGS
• ALL_MINING_MODELS
• ALL_MVIEW_AGGREGATES
• ALL_MVIEW_ANALYSIS
• ALL_MVIEW_COMMENTS
• ALL_MVIEW_DETAIL_PARTITION
• ALL_MVIEW_DETAIL_RELATIONS
• ALL_MVIEW_DETAIL_SUBPARTITION
• ALL_MVIEW_JOINS
• ALL_MVIEW_KEYS
• ALL_MVIEW_LOGS
• ALL_MVIEW_REFRESH_TIMES
• ALL_MVIEWS
• ALL_NESTED_TABLE_COLS
• ALL_NESTED_TABLES
• ALL_OBJ_COLATTRS
• ALL_OBJECT_TABLES
• ALL_OBJECTS
• ALL_OPANCILLARY
• ALL_OPARGUMENTS
• ALL_OPBINDINGS
• ALL_OPERATOR_COMMENTS
• ALL_OPERATORS
• ALL_OUTLINE_HINTS
• ALL_OUTLINES

3 Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES

• ALL_PART_COL_STATISTICS
• ALL_PART_HISTOGRAMS
• ALL_PART_INDEXES
• ALL_PART_KEY_COLUMNS
• ALL_PART_LOBS
• ALL_PART_TABLES
• ALL_PARTIAL_DROP_TABS
• ALL_PENDING_CONV_TABLES
• ALL_PLSQL_OBJECT_SETTINGS
• ALL_POLICIES
• ALL_POLICY_CONTEXTS
• ALL_POLICY_GROUPS
• ALL_PROCEDURES
• ALL_PROPAGATION
• ALL_PUBLISHED_COLUMNS
• ALL_QUEUE_SUBSCRIBERS
• ALL_QUEUE_TABLES
• ALL_QUEUES
• ALL_REFRESH
• ALL_REFRESH_CHILDREN
• ALL_REFRESH_DEPENDENCIES
• ALL_REFS
• ALL_REGISTERED_MVIEWS
• ALL_REGISTRY_BANNERS
• ALL_REWRITE_EQUIVALENCES
• ALL_RULE_SET_RULES
• ALL_RULE_SETS
• ALL_RULES
• ALL_SCHEDULER_CHAIN_RULES
• ALL_SCHEDULER_CHAIN_STEPS
• ALL_SCHEDULER_CHAINS
• ALL_SCHEDULER_CREDENTIALS
• ALL_SCHEDULER_GLOBAL_ATTRIBUTE
• ALL_SCHEDULER_JOB_ARGS
• ALL_SCHEDULER_JOB_CLASSES
• ALL_SCHEDULER_JOB_LOG
• ALL_SCHEDULER_JOB_RUN_DETAILS
• ALL_SCHEDULER_JOBS
• ALL_SCHEDULER_PROGRAM_ARGS
• ALL_SCHEDULER_PROGRAMS
• ALL_SCHEDULER_REMOTE_DATABASES
• ALL_SCHEDULER_REMOTE_JOBSTATE
• ALL_SCHEDULER_RUNNING_CHAINS
• ALL_SCHEDULER_RUNNING_JOBS
• ALL_SCHEDULER_SCHEDULES
• ALL_SCHEDULER_WINDOW_DETAILS
• ALL_SCHEDULER_WINDOW_GROUPS
• ALL_SCHEDULER_WINDOW_LOG
• ALL_SCHEDULER_WINDOWS
• ALL_SCHEDULER_WINGROUP_MEMBERS
• ALL_SEC_RELEVANT_COLS
• ALL_SECONDARY_OBJECTS
• ALL_SEQUENCES
• ALL_SERVICES
• ALL_SOURCE
• ALL_SOURCE_TABLES
• ALL_SQLJ_TYPE_ATTRS
• ALL_SQLJ_TYPE_METHODS
• ALL_SQLJ_TYPES
• ALL_SQLSET
• ALL_SQLSET_BINDS
• ALL_SQLSET_PLANS
• ALL_SQLSET_REFERENCES
• ALL_SQLSET_STATEMENTS
• ALL_STAT_EXTENSIONS
• ALL_STORED_SETTINGS
• ALL_STREAMS_COLUMNS
• ALL_STREAMS_GLOBAL_RULES
• ALL_STREAMS_MESSAGE_CONSUMERS
• ALL_STREAMS_MESSAGE_RULES
• ALL_STREAMS_NEWLY_SUPPORTED
• ALL_STREAMS_RULES
• ALL_STREAMS_SCHEMA_RULES
• ALL_STREAMS_TABLE_RULES
• ALL_STREAMS_TRANSFORM_FUNCTION
• ALL_STREAMS_UNSUPPORTED
• ALL_SUBPART_COL_STATISTICS
• ALL_SUBPART_HISTOGRAMS
• ALL_SUBPART_KEY_COLUMNS
• ALL_SUBPARTITION_TEMPLATES
• ALL_SUBSCRIBED_COLUMNS
• ALL_SUBSCRIBED_TABLES
• ALL_SUBSCRIPTIONS
• ALL_SUMDELTA
• ALL_SYNC_CAPTURE
• ALL_SYNC_CAPTURE_PREPARED_TABS
• ALL_SYNC_CAPTURE_TABLES
• ALL_SYNONYMS
• ALL_TAB_COL_STATISTICS
• ALL_TAB_COLS
• ALL_TAB_COLUMNS
• ALL_TAB_COMMENTS
• ALL_TAB_HISTGRM_PENDING_STATS
• ALL_TAB_HISTOGRAMS
• ALL_TAB_MODIFICATIONS
• ALL_TAB_PARTITIONS
• ALL_TAB_PENDING_STATS
• ALL_TAB_PRIVS
• ALL_TAB_PRIVS_MADE
• ALL_TAB_PRIVS_RECD
• ALL_TAB_STAT_PREFS
• ALL_TAB_STATISTICS
• ALL_TAB_STATS_HISTORY
• ALL_TAB_SUBPARTITIONS
• ALL_TABLES
• ALL_TRIGGER_COLS
• ALL_TRIGGER_ORDERING
• ALL_TRIGGERS
• ALL_TYPE_ATTRS
• ALL_TYPE_METHODS
• ALL_TYPE_VERSIONS
• ALL_TYPES
• ALL_UNUSED_COL_TABS
• ALL_UPDATABLE_COLUMNS
• ALL_USERS
• ALL_USTATS
• ALL_VARRAYS
• ALL_VIEWS
• ALL_WARNING_SETTINGS
• ALL_XML_INDEXES
• ALL_XML_SCHEMAS
• ALL_XML_TAB_COLS
• ALL_XML_TABLES
• ALL_XML_VIEW_COLS
• ALL_XML_VIEWS
• AUDIT_ACTIONS
• CAT
• CATALOG
• CHAINED_ROWS
• CHANGE_PROPAGATION_SETS
• CHANGE_PROPAGATIONS
• CHANGE_SETS
• CHANGE_SOURCES
• CHANGE_TABLES
• CLIENT_RESULT_CACHE_STATS$
• CLU
• COL
• COLS
• DATABASE_PROPERTIES

4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_MVIEWS

• DBA_2PC_NEIGHBORS
• DBA_2PC_PENDING
• DBA_ADDM_FDG_BREAKDOWN
• DBA_ADDM_FINDINGS
• DBA_ADDM_INSTANCES
• DBA_ADDM_TASKS
• DBA_ADVISOR_ACTIONS
• DBA_ADVISOR_COMMANDS
• DBA_ADVISOR_DEF_PARAMETERS
• DBA_ADVISOR_DEFINITIONS
• DBA_ADVISOR_DIR_DEFINITIONS
• DBA_ADVISOR_DIR_INSTANCES
• DBA_ADVISOR_DIR_TASK_INST
• DBA_ADVISOR_EXECUTIONS
• DBA_ADVISOR_EXECUTION_TYPES
• DBA_ADVISOR_EXEC_PARAMETERS
• DBA_ADVISOR_FDG_BREAKDOWN
• DBA_ADVISOR_FINDING_NAMES
• DBA_ADVISOR_FINDINGS
• DBA_ADVISOR_JOURNAL
• DBA_ADVISOR_LOG
• DBA_ADVISOR_OBJECT_TYPES
• DBA_ADVISOR_OBJECTS
• DBA_ADVISOR_PARAMETERS
• DBA_ADVISOR_PARAMETERS_PROJ
• DBA_ADVISOR_RATIONALE
• DBA_ADVISOR_RECOMMENDATIONS
• DBA_ADVISOR_SQLA_REC_SUM
• DBA_ADVISOR_SQLA_TABLES
• DBA_ADVISOR_SQLA_WK_MAP
• DBA_ADVISOR_SQLA_WK_STMTS
• DBA_ADVISOR_SQLPLANS
• DBA_ADVISOR_SQLSTATS
• DBA_ADVISOR_SQLW_JOURNAL
• DBA_ADVISOR_SQLW_PARAMETERS
• DBA_ADVISOR_SQLW_STMTS
• DBA_ADVISOR_SQLW_SUM
• DBA_ADVISOR_SQLW_TABLES
• DBA_ADVISOR_SQLW_TEMPLATES
• DBA_ADVISOR_TASKS
• DBA_ADVISOR_TEMPLATES
• DBA_ADVISOR_USAGE
• DBA_ALERT_HISTORY
• DBA_ALL_TABLES
• DBA_APPLICATION_ROLES
• DBA_APPLY
• DBA_APPLY_CONFLICT_COLUMNS
• DBA_APPLY_DML_HANDLERS
• DBA_APPLY_ENQUEUE
• DBA_APPLY_ERROR
• DBA_APPLY_EXECUTE
• DBA_APPLY_INSTANTIATED_GLOBAL
• DBA_APPLY_INSTANTIATED_OBJECTS
• DBA_APPLY_INSTANTIATED_SCHEMAS
• DBA_APPLY_KEY_COLUMNS
• DBA_APPLY_OBJECT_DEPENDENCIES
• DBA_APPLY_PARAMETERS
• DBA_APPLY_PROGRESS
• DBA_APPLY_SPILL_TXN
• DBA_APPLY_TABLE_COLUMNS
• DBA_APPLY_VALUE_DEPENDENCIES
• DBA_AQ_AGENT_PRIVS
• DBA_AQ_AGENTS
• DBA_ARGUMENTS
• DBA_ASSEMBLIES
• DBA_ASSOCIATIONS
• DBA_ATTRIBUTE_TRANSFORMATIONS
• DBA_AUDIT_EXISTS
• DBA_AUDIT_OBJECT
• DBA_AUDIT_POLICIES
• DBA_AUDIT_POLICY_COLUMNS
• DBA_AUDIT_SESSION
• DBA_AUDIT_STATEMENT
• DBA_AUDIT_TRAIL
• DBA_AUTO_SEGADV_CTL
• DBA_AUTO_SEGADV_SUMMARY
• DBA_AUTOTASK_CLIENT
• DBA_AUTOTASK_CLIENT_HISTORY
• DBA_AUTOTASK_CLIENT_JOB
• DBA_AUTOTASK_JOB_HISTORY
• DBA_AUTOTASK_OPERATION
• DBA_AUTOTASK_SCHEDULE
• DBA_AUTOTASK_TASK
• DBA_AUTOTASK_WINDOW_CLIENTS
• DBA_AUTOTASK_WINDOW_HISTORY
• DBA_AW_PS
• DBA_AWS
• DBA_BASE_TABLE_MVIEWS
• DBA_BLOCKERS
• DBA_CAPTURE
• DBA_CAPTURE_EXTRA_ATTRIBUTES
• DBA_CAPTURE_PARAMETERS
• DBA_CAPTURE_PREPARED_DATABASE
• DBA_CAPTURE_PREPARED_SCHEMAS
• DBA_CAPTURE_PREPARED_TABLES
• DBA_CATALOG
• DBA_CHANGE_NOTIFICATION_REGS
• DBA_CLU_COLUMNS
• DBA_CLUSTER_HASH_EXPRESSIONS
• DBA_CLUSTERS
• DBA_COL_COMMENTS
• DBA_COL_PENDING_STATS
• DBA_COL_PRIVS
• DBA_COLL_TYPES
• DBA_COMMON_AUDIT_TRAIL
• DBA_COMPARISON
• DBA_COMPARISON_COLUMNS
• DBA_COMPARISON_ROW_DIF
• DBA_COMPARISON_SCAN
• DBA_COMPARISON_SCAN_VALUES
• DBA_CONNECT_ROLE_GRANTEES
• DBA_CONS_OBJ_COLUMNS
• DBA_CONSTRAINTS
• DBA_CONTEXT
• DBA_CPOOL_INFO
• DBA_CPU_USAGE_STATISTICS
• DBA_CQ_NOTIFICATION_QUERIES
• DBA_CUBE_ATTR_VISIBILITY
• DBA_CUBE_ATTRIBUTES
• DBA_CUBE_BUILD_PROCESSES
• DBA_CUBE_CALCULATED_MEMBERS
• DBA_CUBE_DIM_LEVELS
• DBA_CUBE_DIM_MODELS
• DBA_CUBE_DIM_VIEW_COLUMNS
• DBA_CUBE_DIM_VIEWS
• DBA_CUBE_DIMENSIONALITY
• DBA_CUBE_DIMENSIONS
• DBA_CUBE_HIER_LEVELS
• DBA_CUBE_HIER_VIEW_COLUMNS
• DBA_CUBE_HIER_VIEWS
• DBA_CUBE_HIERARCHIES
• DBA_CUBE_MEASURES
• DBA_CUBE_VIEW_COLUMNS
• DBA_CUBE_VIEWS
• DBA_CUBES
• DBA_DATA_FILES
• DBA_DATAPUMP_JOBS
• DBA_DATAPUMP_SESSIONS
• DBA_DB_LINKS
• DBA_DDL_LOCKS
• DBA_DEPENDENCIES
• DBA_DIM_ATTRIBUTES
• DBA_DIM_CHILD_OF
• DBA_DIM_HIERARCHIES
• DBA_DIM_JOIN_KEY
• DBA_DIM_LEVEL_KEY
• DBA_DIM_LEVELS
• DBA_DIMENSIONS
• DBA_DIRECTORIES
• DBA_DML_LOCKS
• DBA_DMT_FREE_SPACE
• DBA_DMT_USED_EXTENTS
• DBA_ENABLED_AGGREGATIONS
• DBA_ENABLED_TRACES
• DBA_ENCRYPTED_COLUMNS
• DBA_EPG_DAD_AUTHORIZATION
• DBA_ERRORS
• DBA_EVALUATION_CONTEXT_TABLES
• DBA_EVALUATION_CONTEXT_VARS
• DBA_EVALUATION_CONTEXTS
• DBA_EXP_FILES
• DBA_EXP_OBJECTS
• DBA_EXP_VERSION
• DBA_EXTENTS
• DBA_EXTERNAL_LOCATIONS
• DBA_EXTERNAL_TABLES
• DBA_FEATURE_USAGE_STATISTICS
• DBA_FGA_AUDIT_TRAIL
• DBA_FILE_GROUP_EXPORT_INFO
• DBA_FILE_GROUP_FILES
• DBA_FILE_GROUP_TABLES
• DBA_FILE_GROUP_TABLESPACES
• DBA_FILE_GROUP_VERSIONS
• DBA_FILE_GROUPS
• DBA_FLASHBACK_ARCHIVE
• DBA_FLASHBACK_ARCHIVE_TABLES
• DBA_FLASHBACK_ARCHIVE_TS
• DBA_FLASHBACK_TXN_REPORT
• DBA_FLASHBACK_TXN_STATE
• DBA_FREE_SPACE
• DBA_FREE_SPACE_COALESCED
• DBA_HIGH_WATER_MARK_STATISTICS
• DBA_HIST_ACTIVE_SESS_HISTORY
• DBA_HIST_BASELINE
• DBA_HIST_BASELINE_DETAILS
• DBA_HIST_BASELINE_METADATA
• DBA_HIST_BASELINE_TEMPLATE
• DBA_HIST_BG_EVENT_SUMMARY
• DBA_HIST_BUFFER_POOL_STAT
• DBA_HIST_BUFFERED_QUEUES
• DBA_HIST_BUFFERED_SUBSCRIBERS
• DBA_HIST_CLUSTER_INTERCON
• DBA_HIST_COLORED_SQL
• DBA_HIST_COMP_IOSTAT
• DBA_HIST_CR_BLOCK_SERVER
• DBA_HIST_CURRENT_BLOCK_SERVER
• DBA_HIST_DATABASE_INSTANCE
• DBA_HIST_DATAFILE
• DBA_HIST_DB_CACHE_ADVICE
• DBA_HIST_DLM_MISC
• DBA_HIST_ENQUEUE_STAT
• DBA_HIST_EVENT_HISTOGRAM
• DBA_HIST_EVENT_NAME
• DBA_HIST_FILEMETRIC_HISTORY
• DBA_HIST_FILESTATXS
• DBA_HIST_IC_CLIENT_STATS
• DBA_HIST_IC_DEVICE_STATS
• DBA_HIST_INST_CACHE_TRANSFER
• DBA_HIST_INSTANCE_RECOVERY
• DBA_HIST_INTERCONNECT_PINGS
• DBA_HIST_IOSTAT_FILETYPE
• DBA_HIST_IOSTAT_FILETYPE_NAME
• DBA_HIST_IOSTAT_FUNCTION
• DBA_HIST_IOSTAT_FUNCTION_NAME
• DBA_HIST_JAVA_POOL_ADVICE
• DBA_HIST_LATCH
• DBA_HIST_LATCH_CHILDREN
• DBA_HIST_LATCH_MISSES_SUMMARY
• DBA_HIST_LATCH_NAME
• DBA_HIST_LATCH_PARENT
• DBA_HIST_LIBRARYCACHE
• DBA_HIST_LOG
• DBA_HIST_MEM_DYNAMIC_COMP
• DBA_HIST_MEMORY_RESIZE_OPS
• DBA_HIST_MEMORY_TARGET_ADVICE
• DBA_HIST_METRIC_NAME
• DBA_HIST_MTTR_TARGET_ADVICE
• DBA_HIST_MUTEX_SLEEP
• DBA_HIST_OPTIMIZER_ENV
• DBA_HIST_OSSTAT
• DBA_HIST_OSSTAT_NAME
• DBA_HIST_PARAMETER
• DBA_HIST_PARAMETER_NAME
• DBA_HIST_PERSISTENT_QUEUES
• DBA_HIST_PERSISTENT_SUBS
• DBA_HIST_PGA_TARGET_ADVICE
• DBA_HIST_PGASTAT
• DBA_HIST_PROCESS_MEM_SUMMARY
• DBA_HIST_RESOURCE_LIMIT
• DBA_HIST_ROWCACHE_SUMMARY
• DBA_HIST_RSRC_CONSUMER_GROUP
• DBA_HIST_RSRC_PLAN
• DBA_HIST_RULE_SET
• DBA_HIST_SEG_STAT
• DBA_HIST_SEG_STAT_OBJ
• DBA_HIST_SERVICE_NAME
• DBA_HIST_SERVICE_STAT
• DBA_HIST_SERVICE_WAIT_CLASS
• DBA_HIST_SESS_TIME_STATS
• DBA_HIST_SESSMETRIC_HISTORY
• DBA_HIST_SGA
• DBA_HIST_SGA_TARGET_ADVICE
• DBA_HIST_SGASTAT
• DBA_HIST_SHARED_POOL_ADVICE
• DBA_HIST_SNAP_ERROR
• DBA_HIST_SNAPSHOT
• DBA_HIST_SQL_BIND_METADATA
• DBA_HIST_SQL_PLAN
• DBA_HIST_SQL_SUMMARY
• DBA_HIST_SQL_WORKAREA_HSTGRM
• DBA_HIST_SQLBIND
• DBA_HIST_SQLSTAT
• DBA_HIST_SQLTEXT
• DBA_HIST_STAT_NAME
• DBA_HIST_STREAMS_APPLY_SUM
• DBA_HIST_STREAMS_CAPTURE
• DBA_HIST_STREAMS_POOL_ADVICE
• DBA_HIST_SYS_TIME_MODEL
• DBA_HIST_SYSMETRIC_HISTORY
• DBA_HIST_SYSMETRIC_SUMMARY
• DBA_HIST_SYSSTAT
• DBA_HIST_SYSTEM_EVENT
• DBA_HIST_TABLESPACE_STAT
• DBA_HIST_TBSPC_SPACE_USAGE
• DBA_HIST_TEMPFILE
• DBA_HIST_TEMPSTATXS
• DBA_HIST_THREAD
• DBA_HIST_UNDOSTAT
• DBA_HIST_WAITCLASSMET_HISTORY
• DBA_HIST_WAITSTAT
• DBA_HIST_WR_CONTROL
• DBA_IDENTIFIERS
• DBA_IND_COLUMNS
• DBA_IND_EXPRESSIONS
• DBA_IND_PARTITIONS
• DBA_IND_PENDING_STATS
• DBA_IND_STATISTICS
• DBA_IND_SUBPARTITIONS
• DBA_INDEXES
• DBA_INDEXTYPE_ARRAYTYPES
• DBA_INDEXTYPE_COMMENTS
• DBA_INDEXTYPE_OPERATORS
• DBA_INDEXTYPES
• DBA_INTERNAL_TRIGGERS
• DBA_JAVA_ARGUMENTS
• DBA_JAVA_CLASSES
• DBA_JAVA_COMPILER_OPTIONS
• DBA_JAVA_DERIVATIONS
• DBA_JAVA_FIELDS
• DBA_JAVA_IMPLEMENTS
• DBA_JAVA_INNERS
• DBA_JAVA_LAYOUTS
• DBA_JAVA_METHODS
• DBA_JAVA_NCOMPS
• DBA_JAVA_POLICY
• DBA_JAVA_RESOLVERS
• DBA_JAVA_THROWS
• DBA_JOBS
• DBA_JOBS_RUNNING
• DBA_JOIN_IND_COLUMNS
• DBA_KGLLOCK
• DBA_LIBRARIES
• DBA_LMT_FREE_SPACE
• DBA_LMT_USED_EXTENTS
• DBA_LOB_PARTITIONS
• DBA_LOB_SUBPARTITIONS
• DBA_LOB_TEMPLATES
• DBA_LOBS
• DBA_LOCK
• DBA_LOCK_INTERNAL
• DBA_LOCKS
• DBA_LOG_GROUP_COLUMNS
• DBA_LOG_GROUPS
• DBA_LOGMNR_LOG
• DBA_LOGMNR_PURGED_LOG
• DBA_LOGMNR_SESSION
• DBA_LOGSTDBY_EVENTS
• DBA_LOGSTDBY_HISTORY
• DBA_LOGSTDBY_LOG
• DBA_LOGSTDBY_NOT_UNIQUE
• DBA_LOGSTDBY_PARAMETERS
• DBA_LOGSTDBY_PROGRESS
• DBA_LOGSTDBY_SKIP
• DBA_LOGSTDBY_SKIP_TRANSACTION
• DBA_LOGSTDBY_UNSUPPORTED
• DBA_LOGSTDBY_UNSUPPORTED_TABLE
• DBA_MEASURE_FOLDER_CONTENTS
• DBA_MEASURE_FOLDERS
• DBA_METHOD_PARAMS
• DBA_METHOD_RESULTS
• DBA_MINING_MODEL_ATTRIBUTES
• DBA_MINING_MODEL_SETTINGS
• DBA_MINING_MODELS
• DBA_MVIEW_AGGREGATES
• DBA_MVIEW_ANALYSIS
• DBA_MVIEW_COMMENTS
• DBA_MVIEW_DETAIL_PARTITION
• DBA_MVIEW_DETAIL_RELATIONS
• DBA_MVIEW_DETAIL_SUBPARTITION
• DBA_MVIEW_JOINS
• DBA_MVIEW_KEYS
• DBA_MVIEW_LOG_FILTER_COLS
• DBA_MVIEW_LOGS
• DBA_MVIEW_REFRESH_TIMES
• DBA_MVIEWS

5 Static Data Dictionary Views: DBA_NESTED_TABLE_COLS to USER_XML_VIEWS

• DBA_NESTED_TABLE_COLS
• DBA_NESTED_TABLES
• DBA_NETWORK_ACL_PRIVILEGES
• DBA_NETWORK_ACLS
• DBA_OBJ_AUDIT_OPTS
• DBA_OBJ_COLATTRS
• DBA_OBJECT_SIZE
• DBA_OBJECT_TABLES
• DBA_OBJECTS
• DBA_OPANCILLARY
• DBA_OPARGUMENTS
• DBA_OPBINDINGS
• DBA_OPERATOR_COMMENTS
• DBA_OPERATORS
• DBA_OPTSTAT_OPERATIONS
• DBA_ORPHAN_KEY_TABLE
• DBA_OUTLINE_HINTS
• DBA_OUTLINES
• DBA_OUTSTANDING_ALERTS
• DBA_PART_COL_STATISTICS
• DBA_PART_HISTOGRAMS
• DBA_PART_INDEXES
• DBA_PART_KEY_COLUMNS
• DBA_PART_LOBS
• DBA_PART_TABLES
• DBA_PARTIAL_DROP_TABS
• DBA_PENDING_CONV_TABLES
• DBA_PENDING_TRANSACTIONS
• DBA_PLSQL_OBJECT_SETTINGS
• DBA_POLICIES
• DBA_POLICY_CONTEXTS
• DBA_POLICY_GROUPS
• DBA_PRIV_AUDIT_OPTS
• DBA_PROCEDURES
• DBA_PROFILES
• DBA_PROPAGATION
• DBA_PROXIES
• DBA_PUBLISHED_COLUMNS
• DBA_QUEUE_SCHEDULES
• DBA_QUEUE_SUBSCRIBERS
• DBA_QUEUE_TABLES
• DBA_QUEUES
• DBA_RCHILD
• DBA_RECOVERABLE_SCRIPT
• DBA_RECOVERABLE_SCRIPT_BLOCKS
• DBA_RECOVERABLE_SCRIPT_ERRORS
• DBA_RECOVERABLE_SCRIPT_PARAMS
• DBA_RECYCLEBIN
• DBA_REDEFINITION_ERRORS
• DBA_REDEFINITION_OBJECTS
• DBA_REFRESH
• DBA_REFRESH_CHILDREN
• DBA_REFS
• DBA_REGISTERED_ARCHIVED_LOG
• DBA_REGISTERED_MVIEW_GROUPS
• DBA_REGISTERED_MVIEWS
• DBA_REGISTRY
• DBA_REGISTRY_HIERARCHY
• DBA_REGISTRY_HISTORY
• DBA_REGISTRY_LOG
• DBA_REPAIR_TABLE
• DBA_RESOURCE_INCARNATIONS
• DBA_RESUMABLE
• DBA_REWRITE_EQUIVALENCES
• DBA_RGROUP
• DBA_ROLE_PRIVS
• DBA_ROLES
• DBA_ROLLBACK_SEGS
• DBA_RSRC_CATEGORIES
• DBA_RSRC_CONSUMER_GROUP_PRIVS
• DBA_RSRC_CONSUMER_GROUPS
• DBA_RSRC_GROUP_MAPPINGS
• DBA_RSRC_IO_CALIBRATE
• DBA_RSRC_MANAGER_SYSTEM_PRIVS
• DBA_RSRC_MAPPING_PRIORITY
• DBA_RSRC_PLAN_DIRECTIVES
• DBA_RSRC_PLANS
• DBA_RULE_SET_RULES
• DBA_RULE_SETS
• DBA_RULES
• DBA_SCHEDULER_CHAIN_RULES
• DBA_SCHEDULER_CHAIN_STEPS
• DBA_SCHEDULER_CHAINS
• DBA_SCHEDULER_CREDENTIALS
• DBA_SCHEDULER_GLOBAL_ATTRIBUTE
• DBA_SCHEDULER_JOB_ARGS
• DBA_SCHEDULER_JOB_CLASSES
• DBA_SCHEDULER_JOB_LOG
• DBA_SCHEDULER_JOB_ROLES
• DBA_SCHEDULER_JOB_RUN_DETAILS
• DBA_SCHEDULER_JOBS
• DBA_SCHEDULER_PROGRAM_ARGS
• DBA_SCHEDULER_PROGRAMS
• DBA_SCHEDULER_REMOTE_DATABASES
• DBA_SCHEDULER_REMOTE_JOBSTATE
• DBA_SCHEDULER_RUNNING_CHAINS
• DBA_SCHEDULER_RUNNING_JOBS
• DBA_SCHEDULER_SCHEDULES
• DBA_SCHEDULER_WINDOW_DETAILS
• DBA_SCHEDULER_WINDOW_GROUPS
• DBA_SCHEDULER_WINDOW_LOG
• DBA_SCHEDULER_WINDOWS
• DBA_SCHEDULER_WINGROUP_MEMBERS
• DBA_SEC_RELEVANT_COLS
• DBA_SECONDARY_OBJECTS
• DBA_SEGMENTS
• DBA_SEGMENTS_OLD
• DBA_SEQUENCES
• DBA_SERVER_REGISTRY
• DBA_SERVICES
• DBA_SOURCE
• DBA_SOURCE_TABLES
• DBA_SQL_MANAGEMENT_CONFIG
• DBA_SQL_PATCHES
• DBA_SQL_PLAN_BASELINES
• DBA_SQL_PROFILES
• DBA_SQLJ_TYPE_ATTRS
• DBA_SQLJ_TYPE_METHODS
• DBA_SQLJ_TYPES
• DBA_SQLSET
• DBA_SQLSET_BINDS
• DBA_SQLSET_PLANS
• DBA_SQLSET_REFERENCES
• DBA_SQLSET_STATEMENTS
• DBA_SQLTUNE_BINDS
• DBA_SQLTUNE_PLANS
• DBA_SQLTUNE_RATIONALE_PLAN
• DBA_SQLTUNE_STATISTICS
• DBA_SSCR_CAPTURE
• DBA_SSCR_RESTORE
• DBA_STAT_EXTENSIONS
• DBA_STMT_AUDIT_OPTS
• DBA_STORED_SETTINGS
• DBA_STREAMS_ADD_COLUMN
• DBA_STREAMS_ADMINISTRATOR
• DBA_STREAMS_COLUMNS
• DBA_STREAMS_DELETE_COLUMN
• DBA_STREAMS_GLOBAL_RULES
• DBA_STREAMS_MESSAGE_CONSUMERS
• DBA_STREAMS_MESSAGE_RULES
• DBA_STREAMS_NEWLY_SUPPORTED
• DBA_STREAMS_RENAME_COLUMN
• DBA_STREAMS_RENAME_SCHEMA
• DBA_STREAMS_RENAME_TABLE
• DBA_STREAMS_RULES
• DBA_STREAMS_SCHEMA_RULES
• DBA_STREAMS_TABLE_RULES
• DBA_STREAMS_TP_COMPONENT
• DBA_STREAMS_TP_COMPONENT_LINK
• DBA_STREAMS_TP_COMPONENT_STAT
• DBA_STREAMS_TP_DATABASE
• DBA_STREAMS_TP_PATH_BOTTLENECK
• DBA_STREAMS_TP_PATH_STAT
• DBA_STREAMS_TRANSFORM_FUNCTION
• DBA_STREAMS_TRANSFORMATIONS
• DBA_STREAMS_UNSUPPORTED
• DBA_SUBPART_COL_STATISTICS
• DBA_SUBPART_HISTOGRAMS
• DBA_SUBPART_KEY_COLUMNS
• DBA_SUBPARTITION_TEMPLATES
• DBA_SUBSCR_REGISTRATIONS
• DBA_SUBSCRIBED_COLUMNS
• DBA_SUBSCRIBED_TABLES
• DBA_SUBSCRIPTIONS
• DBA_SYNC_CAPTURE
• DBA_SYNC_CAPTURE_PREPARED_TABS
• DBA_SYNC_CAPTURE_TABLES
• DBA_SYNONYMS
• DBA_SYS_PRIVS
• DBA_TAB_COL_STATISTICS
• DBA_TAB_COLS
• DBA_TAB_COLUMNS
• DBA_TAB_COMMENTS
• DBA_TAB_HISTGRM_PENDING_STATS
• DBA_TAB_HISTOGRAMS
• DBA_TAB_MODIFICATIONS
• DBA_TAB_PARTITIONS
• DBA_TAB_PENDING_STATS
• DBA_TAB_PRIVS
• DBA_TAB_STATISTICS
• DBA_TAB_STAT_PREFS
• DBA_TAB_STATS_HISTORY
• DBA_TAB_SUBPARTITIONS
• DBA_TABLES
• DBA_TABLESPACE_GROUPS
• DBA_TABLESPACE_USAGE_METRICS
• DBA_TABLESPACES
• DBA_TEMP_FILES
• DBA_TEMP_FREE_SPACE
• DBA_THRESHOLDS
• DBA_TRANSFORMATIONS
• DBA_TRIGGER_COLS
• DBA_TRIGGER_ORDERING
• DBA_TRIGGERS
• DBA_TS_QUOTAS
• DBA_TSM_DESTINATION
• DBA_TSM_SOURCE
• DBA_TUNE_MVIEW
• DBA_TYPE_ATTRS
• DBA_TYPE_METHODS
• DBA_TYPE_VERSIONS
• DBA_TYPES
• DBA_UNDO_EXTENTS
• DBA_UNUSED_COL_TABS
• DBA_UPDATABLE_COLUMNS
• DBA_USERS
• DBA_USERS_WITH_DEFPWD
• DBA_USTATS
• DBA_VARRAYS
• DBA_VIEWS
• DBA_WAITERS
• DBA_WARNING_SETTINGS
• DBA_WORKLOAD_CAPTURES
• DBA_WORKLOAD_CONNECTION_MAP
• DBA_WORKLOAD_FILTERS
• DBA_WORKLOAD_REPLAY_DIVERGENCE
• DBA_WORKLOAD_REPLAYS
• DBA_XML_INDEXES
• DBA_XML_SCHEMAS
• DBA_XML_TAB_COLS
• DBA_XML_TABLES
• DBA_XML_VIEW_COLS
• DBA_XML_VIEWS
• DBMS_ALERT_INFO
• DBMS_LOCK_ALLOCATED
• DEPTREE
• DICT
• DICT_COLUMNS
• DICTIONARY
• DM_USER_MODELS
• DOCUMENT_LINKS
• ERROR_SIZE
• EXCEPTIONS
• FLASHBACK_TRANSACTION_QUERY
• GLOBAL_NAME
• HS_ALL_CAPS
• HS_ALL_DD
• HS_ALL_INITS
• HS_BASE_CAPS
• HS_BASE_DD
• HS_CLASS_CAPS
• HS_CLASS_DD
• HS_CLASS_INIT
• HS_EXTERNAL_OBJECT_PRIVILEGES
• HS_EXTERNAL_OBJECTS
• HS_EXTERNAL_USER_PRIVILEGES
• HS_FDS_CLASS
• HS_FDS_INST
• HS_INST_CAPS
• HS_INST_DD
• HS_INST_INIT
• IDEPTREE
• IND
• INDEX_HISTOGRAM
• INDEX_STATS
• LOGSTDBY_UNSUPPORTED_TABLES
• MAP_OBJECT
• NLS_DATABASE_PARAMETERS
• NLS_INSTANCE_PARAMETERS
• NLS_SESSION_PARAMETERS
• OBJ
• PATH_VIEW
• PLAN_TABLE
• PLUGGABLE_SET_CHECK
• PRODUCT_COMPONENT_VERSION
• PROXY_USERS
• PSTUBTBL
• PUBLIC_DEPENDENCY
• PUBLICSYN
• QUEUE_PRIVILEGES
• RECYCLEBIN
• REPORT_COMPONENTS
• REPORT_FILES
• REPORT_FORMATS
• RESOURCE_COST
• RESOURCE_MAP
• RESOURCE_VIEW
• ROLE_ROLE_PRIVS
• ROLE_SYS_PRIVS
• ROLE_TAB_PRIVS
• SCHEDULER_BATCH_ERRORS
• SEQ
• SESSION_CONTEXT
• SESSION_PRIVS
• SESSION_ROLES
• SOURCE_SIZE
• STMT_AUDIT_OPTION_MAP
• SYN
• SYNONYMS
• SYS_OBJECTS
• SYSCATALOG
• SYSFILES
• SYSSEGOBJ
• SYSTEM_PRIVILEGE_MAP
• TAB
• TABLE_PRIVILEGE_MAP
• TABQUOTAS
• TABS
• TRUSTED_SERVERS
• TS_PITR_CHECK
• TS_PITR_OBJECTS_TO_BE_DROPPED
• UNI_PLUGGABLE_SET_CHECK
• USER_ADDM_FDG_BREAKDOWN
• USER_ADDM_FINDINGS
• USER_ADDM_INSTANCES
• USER_ADDM_TASKS
• USER_ADVISOR_ACTIONS
• USER_ADVISOR_DIR_TASK_INST
• USER_ADVISOR_EXECUTIONS
• USER_ADVISOR_EXEC_PARAMETERS
• USER_ADVISOR_FDG_BREAKDOWN
• USER_ADVISOR_FINDINGS
• USER_ADVISOR_JOURNAL
• USER_ADVISOR_LOG
• USER_ADVISOR_OBJECTS
• USER_ADVISOR_PARAMETERS
• USER_ADVISOR_RATIONALE
• USER_ADVISOR_RECOMMENDATIONS
• USER_ADVISOR_SQLA_REC_SUM
• USER_ADVISOR_SQLA_TABLES
• USER_ADVISOR_SQLA_WK_MAP
• USER_ADVISOR_SQLA_WK_STMTS
• USER_ADVISOR_SQLPLANS
• USER_ADVISOR_SQLSTATS
• USER_ADVISOR_SQLW_JOURNAL
• USER_ADVISOR_SQLW_PARAMETERS
• USER_ADVISOR_SQLW_STMTS
• USER_ADVISOR_SQLW_SUM
• USER_ADVISOR_SQLW_TABLES
• USER_ADVISOR_SQLW_TEMPLATES
• USER_ADVISOR_TASKS
• USER_ADVISOR_TEMPLATES
• USER_ALL_TABLES
• USER_AQ_AGENT_PRIVS
• USER_ARGUMENTS
• USER_ASSEMBLIES
• USER_ASSOCIATIONS
• USER_ATTRIBUTE_TRANSFORMATIONS
• USER_AUDIT_OBJECT
• USER_AUDIT_POLICIES
• USER_AUDIT_POLICY_COLUMNS
• USER_AUDIT_SESSION
• USER_AUDIT_STATEMENT
• USER_AUDIT_TRAIL
• USER_AW_PS
• USER_AWS
• USER_BASE_TABLE_MVIEWS
• USER_CATALOG
• USER_CHANGE_NOTIFICATION_REGS
• USER_CLU_COLUMNS
• USER_CLUSTER_HASH_EXPRESSIONS
• USER_CLUSTERS
• USER_COL_COMMENTS
• USER_COL_PENDING_STATS
• USER_COL_PRIVS
• USER_COL_PRIVS_MADE
• USER_COL_PRIVS_RECD
• USER_COLL_TYPES
• USER_COMPARISON
• USER_COMPARISON_COLUMNS
• USER_COMPARISON_ROW_DIF
• USER_COMPARISON_SCAN
• USER_COMPARISON_SCAN_VALUES
• USER_CONS_COLUMNS
• USER_CONS_OBJ_COLUMNS
• USER_CONSTRAINTS
• USER_CQ_NOTIFICATION_QUERIES
• USER_CUBE_ATTR_VISIBILITY
• USER_CUBE_ATTRIBUTES
• USER_CUBE_BUILD_PROCESSES
• USER_CUBE_CALCULATED_MEMBERS
• USER_CUBE_DIM_LEVELS
• USER_CUBE_DIM_MODELS
• USER_CUBE_DIM_VIEW_COLUMNS
• USER_CUBE_DIM_VIEWS
• USER_CUBE_DIMENSIONALITY
• USER_CUBE_DIMENSIONS
• USER_CUBE_HIER_LEVELS
• USER_CUBE_HIER_VIEW_COLUMNS
• USER_CUBE_HIER_VIEWS
• USER_CUBE_HIERARCHIES
• USER_CUBE_MEASURES
• USER_CUBE_VIEW_COLUMNS
• USER_CUBE_VIEWS
• USER_CUBES
• USER_DATAPUMP_JOBS
• USER_DB_LINKS
• USER_DEPENDENCIES
• USER_DIM_ATTRIBUTES
• USER_DIM_CHILD_OF
• USER_DIM_HIERARCHIES
• USER_DIM_JOIN_KEY
• USER_DIM_LEVEL_KEY
• USER_DIM_LEVELS
• USER_DIMENSIONS
• USER_ENCRYPTED_COLUMNS
• USER_EPG_DAD_AUTHORIZATION
• USER_ERRORS
• USER_EVALUATION_CONTEXT_TABLES
• USER_EVALUATION_CONTEXT_VARS
• USER_EVALUATION_CONTEXTS
• USER_EXTENTS
• USER_EXTERNAL_LOCATIONS
• USER_EXTERNAL_TABLES
• USER_FILE_GROUP_EXPORT_INFO
• USER_FILE_GROUP_FILES
• USER_FILE_GROUP_TABLES
• USER_FILE_GROUP_TABLESPACES
• USER_FILE_GROUP_VERSIONS
• USER_FILE_GROUPS
• USER_FLASHBACK_ARCHIVE
• USER_FLASHBACK_ARCHIVE_TABLES
• USER_FLASHBACK_TXN_REPORT
• USER_FLASHBACK_TXN_STATE
• USER_FREE_SPACE
• USER_IDENTIFIERS
• USER_IND_COLUMNS
• USER_IND_EXPRESSIONS
• USER_IND_PARTITIONS
• USER_IND_PENDING_STATS
• USER_IND_STATISTICS
• USER_IND_SUBPARTITIONS
• USER_INDEXES
• USER_INDEXTYPE_ARRAYTYPES
• USER_INDEXTYPE_COMMENTS
• USER_INDEXTYPE_OPERATORS
• USER_INDEXTYPES
• USER_INTERNAL_TRIGGERS
• USER_JAVA_ARGUMENTS
• USER_JAVA_CLASSES
• USER_JAVA_COMPILER_OPTIONS
• USER_JAVA_DERIVATIONS
• USER_JAVA_FIELDS
• USER_JAVA_IMPLEMENTS
• USER_JAVA_INNERS
• USER_JAVA_LAYOUTS
• USER_JAVA_METHODS
• USER_JAVA_NCOMPS
• USER_JAVA_POLICY
• USER_JAVA_RESOLVERS
• USER_JAVA_THROWS
• USER_JOBS
• USER_JOIN_IND_COLUMNS
• USER_LIBRARIES
• USER_LOB_PARTITIONS
• USER_LOB_SUBPARTITIONS
• USER_LOB_TEMPLATES
• USER_LOBS
• USER_LOG_GROUP_COLUMNS
• USER_LOG_GROUPS
• USER_MEASURE_FOLDER_CONTENTS
• USER_MEASURE_FOLDERS
• USER_METHOD_PARAMS
• USER_METHOD_RESULTS
• USER_MINING_MODEL_ATTRIBUTES
• USER_MINING_MODEL_SETTINGS
• USER_MINING_MODELS
• USER_MVIEW_AGGREGATES
• USER_MVIEW_ANALYSIS
• USER_MVIEW_COMMENTS
• USER_MVIEW_DETAIL_PARTITION
• USER_MVIEW_DETAIL_RELATIONS
• USER_MVIEW_DETAIL_SUBPARTITION
• USER_MVIEW_JOINS
• USER_MVIEW_KEYS
• USER_MVIEW_LOGS
• USER_MVIEW_REFRESH_TIMES
• USER_MVIEWS
• USER_NESTED_TABLE_COLS
• USER_NESTED_TABLES
• USER_NETWORK_ACL_PRIVILEGES
• USER_OBJ_AUDIT_OPTS
• USER_OBJ_COLATTRS
• USER_OBJECT_SIZE
• USER_OBJECT_TABLES
• USER_OBJECTS
• USER_OPANCILLARY
• USER_OPARGUMENTS
• USER_OPBINDINGS
• USER_OPERATOR_COMMENTS
• USER_OPERATORS
• USER_OUTLINE_HINTS
• USER_OUTLINES
• USER_PART_COL_STATISTICS
• USER_PART_HISTOGRAMS
• USER_PART_INDEXES
• USER_PART_KEY_COLUMNS
• USER_PART_LOBS
• USER_PART_TABLES
• USER_PARTIAL_DROP_TABS
• USER_PASSWORD_LIMITS
• USER_PENDING_CONV_TABLES
• USER_PLSQL_OBJECT_SETTINGS
• USER_POLICIES
• USER_POLICY_CONTEXTS
• USER_POLICY_GROUPS
• USER_PROCEDURES
• USER_PROXIES
• USER_PUBLISHED_COLUMNS
• USER_QUEUE_SCHEDULES
• USER_QUEUE_SUBSCRIBERS
• USER_QUEUE_TABLES
• USER_QUEUES
• USER_RECYCLEBIN
• USER_REFRESH
• USER_REFRESH_CHILDREN
• USER_REFS
• USER_REGISTERED_MVIEWS
• USER_REGISTRY
• USER_RESOURCE_LIMITS
• USER_RESUMABLE
• USER_REWRITE_EQUIVALENCES
• USER_ROLE_PRIVS
• USER_RSRC_CONSUMER_GROUP_PRIVS
• USER_RSRC_MANAGER_SYSTEM_PRIVS
• USER_RULE_SET_RULES
• USER_RULE_SETS
• USER_RULES
• USER_SCHEDULER_CHAIN_RULES
• USER_SCHEDULER_CHAIN_STEPS
• USER_SCHEDULER_CHAINS
• USER_SCHEDULER_CREDENTIALS
• USER_SCHEDULER_JOB_ARGS
• USER_SCHEDULER_JOB_LOG
• USER_SCHEDULER_JOB_RUN_DETAILS
• USER_SCHEDULER_JOBS
• USER_SCHEDULER_PROGRAM_ARGS
• USER_SCHEDULER_PROGRAMS
• USER_SCHEDULER_REMOTE_JOBSTATE
• USER_SCHEDULER_RUNNING_CHAINS
• USER_SCHEDULER_RUNNING_JOBS
• USER_SCHEDULER_SCHEDULES
• USER_SEC_RELEVANT_COLS
• USER_SECONDARY_OBJECTS
• USER_SEGMENTS
• USER_SEQUENCES
• USER_SOURCE
• USER_SOURCE_TABLES
• USER_SQLJ_TYPE_ATTRS
• USER_SQLJ_TYPE_METHODS
• USER_SQLJ_TYPES
• USER_SQLSET
• USER_SQLSET_BINDS
• USER_SQLSET_PLANS
• USER_SQLSET_REFERENCES
• USER_SQLSET_STATEMENTS
• USER_SQLTUNE_BINDS
• USER_SQLTUNE_PLANS
• USER_SQLTUNE_RATIONALE_PLAN
• USER_SQLTUNE_STATISTICS
• USER_STAT_EXTENSIONS
• USER_STORED_SETTINGS
• USER_SUBPART_COL_STATISTICS
• USER_SUBPART_HISTOGRAMS
• USER_SUBPART_KEY_COLUMNS
• USER_SUBPARTITION_TEMPLATES
• USER_SUBSCR_REGISTRATIONS
• USER_SUBSCRIBED_COLUMNS
• USER_SUBSCRIBED_TABLES
• USER_SUBSCRIPTIONS
• USER_SYNONYMS
• USER_SYS_PRIVS
• USER_TAB_COL_STATISTICS
• USER_TAB_COLS
• USER_TAB_COLUMNS
• USER_TAB_COMMENTS
• USER_TAB_HISTGRM_PENDING_STATS
• USER_TAB_HISTOGRAMS
• USER_TAB_MODIFICATIONS
• USER_TAB_PARTITIONS
• USER_TAB_PENDING_STATS
• USER_TAB_PRIVS
• USER_TAB_PRIVS_MADE
• USER_TAB_PRIVS_RECD
• USER_TAB_STAT_PREFS
• USER_TAB_STATISTICS
• USER_TAB_STATS_HISTORY
• USER_TAB_SUBPARTITIONS
• USER_TABLES
• USER_TABLESPACES
• USER_TRANSFORMATIONS
• USER_TRIGGER_COLS
• USER_TRIGGER_ORDERING
• USER_TRIGGERS
• USER_TS_QUOTAS
• USER_TUNE_MVIEW
• USER_TYPE_ATTRS
• USER_TYPE_METHODS
• USER_TYPE_VERSIONS
• USER_TYPES
• USER_UNUSED_COL_TABS
• USER_UPDATABLE_COLUMNS
• USER_USERS
• USER_USTATS
• USER_VARRAYS
• USER_VIEWS
• USER_WARNING_SETTINGS
• USER_XML_INDEXES
• USER_XML_SCHEMAS
• USER_XML_TAB_COLS
• USER_XML_TABLES
• USER_XML_VIEW_COLS
• USER_XML_VIEWS
• XS_SESSION_ROLES

Part III Dynamic Performance Views

6 Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO

• About Dynamic Performance Views
  • V$ Views
  • GV$ Views
• Dynamic Performance View Descriptions
• V$ACCESS
• V$ACTIVE_INSTANCES
• V$ACTIVE_SERVICES
• V$ACTIVE_SESS_POOL_MTH
• V$ACTIVE_SESSION_HISTORY
• V$ADVISOR_PROGRESS
• V$ALERT_TYPES
• V$AQ
• V$ARCHIVE
• V$ARCHIVE_DEST
• V$ARCHIVE_DEST_STATUS
• V$ARCHIVE_GAP
• V$ARCHIVE_PROCESSES
• V$ARCHIVED_LOG
• V$ASM_ALIAS
• V$ASM_ATTRIBUTE
• V$ASM_CLIENT
• V$ASM_DISK
• V$ASM_DISK_IOSTAT
• V$ASM_DISK_STAT
• V$ASM_DISKGROUP
• V$ASM_DISKGROUP_STAT
• V$ASM_FILE
• V$ASM_OPERATION
• V$ASM_TEMPLATE
• V$AW_AGGREGATE_OP
• V$AW_ALLOCATE_OP
• V$AW_CALC
• V$AW_LONGOPS
• V$AW_OLAP
• V$AW_SESSION_INFO
• V$BACKUP
• V$BACKUP_ARCHIVELOG_DETAILS
• V$BACKUP_ARCHIVELOG_SUMMARY
• V$BACKUP_ASYNC_IO
• V$BACKUP_CONTROLFILE_DETAILS
• V$BACKUP_CONTROLFILE_SUMMARY
• V$BACKUP_COPY_DETAILS
• V$BACKUP_COPY_SUMMARY
• V$BACKUP_CORRUPTION
• V$BACKUP_DATAFILE
• V$BACKUP_DATAFILE_DETAILS
• V$BACKUP_DATAFILE_SUMMARY
• V$BACKUP_DEVICE
• V$BACKUP_FILES
• V$BACKUP_PIECE
• V$BACKUP_PIECE_DETAILS
• V$BACKUP_REDOLOG
• V$BACKUP_SET
• V$BACKUP_SET_DETAILS
• V$BACKUP_SET_SUMMARY
• V$BACKUP_SPFILE
• V$BACKUP_SPFILE_DETAILS
• V$BACKUP_SPFILE_SUMMARY
• V$BACKUP_SYNC_IO
• V$BGPROCESS
• V$BH
• V$BLOCK_CHANGE_TRACKING
• V$BLOCKING_QUIESCE
• V$BUFFER_POOL
• V$BUFFER_POOL_STATISTICS
• V$BUFFERED_PUBLISHERS
• V$BUFFERED_QUEUES
• V$BUFFERED_SUBSCRIBERS
• V$CACHE
• V$CACHE_LOCK
• V$CACHE_TRANSFER
• V$CALLTAG
• V$CIRCUIT
• V$CLASS_CACHE_TRANSFER
• V$CLIENT_RESULT_CACHE_STATS
• V$CLIENT_STATS
• V$CLUSTER_INTERCONNECTS
• V$CONFIGURED_INTERCONNECTS
• V$CONTEXT
• V$CONTROLFILE
• V$CONTROLFILE_RECORD_SECTION
• V$COPY_CORRUPTION
• V$CORRUPT_XID_LIST
• V$CPOOL_CC_INFO
• V$CPOOL_CC_STATS
• V$CPOOL_STATS
• V$CR_BLOCK_SERVER
• V$CURRENT_BLOCK_SERVER
• V$DATABASE
• V$DATABASE_BLOCK_CORRUPTION
• V$DATABASE_INCARNATION
• V$DATAFILE
• V$DATAFILE_COPY
• V$DATAFILE_HEADER
• V$DATAGUARD_CONFIG
• V$DATAGUARD_STATS
• V$DATAGUARD_STATUS
• V$DB_CACHE_ADVICE
• V$DB_OBJECT_CACHE
• V$DB_PIPES
• V$DB_TRANSPORTABLE_PLATFORM
• V$DBFILE
• V$DBLINK
• V$DELETED_OBJECT
• V$DISPATCHER
• V$DISPATCHER_CONFIG
• V$DISPATCHER_RATE
• V$DNFS_CHANNELS
• V$DNFS_FILES
• V$DNFS_SERVERS
• V$DNFS_STATS
• V$DYNAMIC_REMASTER_STATS
• V$ENABLEDPRIVS
• V$ENCRYPTED_TABLESPACES
• V$ENCRYPTION_WALLET
• V$ENQUEUE_LOCK
• V$ENQUEUE_STAT
• V$ENQUEUE_STATISTICS
• V$EVENT_HISTOGRAM
• V$EVENT_NAME
• V$EVENTMETRIC
• V$EXECUTION
• V$FALSE_PING
• V$FAST_START_SERVERS
• V$FAST_START_TRANSACTIONS
• V$FILE_CACHE_TRANSFER
• V$FILE_HISTOGRAM
• V$FILEMETRIC
• V$FILEMETRIC_HISTORY
• V$FILESPACE_USAGE
• V$FILESTAT
• V$FIXED_TABLE
• V$FIXED_VIEW_DEFINITION
• V$FLASH_RECOVERY_AREA_USAGE
• V$FLASHBACK_DATABASE_LOG
• V$FLASHBACK_DATABASE_LOGFILE
• V$FLASHBACK_DATABASE_STAT
• V$FLASHBACK_TXN_GRAPH
• V$FLASHBACK_TXN_MODS
• V$FOREIGN_ARCHIVED_LOG
• V$FS_FAILOVER_STATS
• V$GC_ELEMENT
• V$GC_ELEMENTS_WITH_COLLISIONS
• V$GCSHVMASTER_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$GLOBAL_BLOCKED_LOCKS
• V$GLOBAL_TRANSACTION
• V$HM_CHECK
• V$HM_CHECK_PARAM
• V$HM_FINDING
• V$HM_INFO
• V$HM_RECOMMENDATION
• V$HM_RUN
• V$HS_AGENT
• V$HS_PARAMETER
• V$HS_SESSION
• V$HVMASTER_INFO

7 Dynamic Performance (V$) Views: V$INCMETER_CONFIG to V$RULE_SET_AGGREGATE_STATS

• V$INDEXED_FIXED_COLUMN
• V$INSTANCE
• V$INSTANCE_CACHE_TRANSFER
• V$INSTANCE_RECOVERY
• V$IO_CALIBRATION_STATUS
• V$IOFUNCMETRIC
• V$IOFUNCMETRIC_HISTORY
• V$IOSTAT_CONSUMER_GROUP
• V$IOSTAT_FILE
• V$IOSTAT_FUNCTION
• V$IOSTAT_NETWORK
• V$JAVA_LIBRARY_CACHE_MEMORY
• V$JAVA_POOL_ADVICE
• V$LATCH
• V$LATCH_CHILDREN
• V$LATCH_MISSES
• V$LATCH_PARENT
• V$LATCHHOLDER
• V$LATCHNAME
• V$LIBRARY_CACHE_MEMORY
• V$LIBRARYCACHE
• V$LICENSE
• V$LOADISTAT
• V$LOADPSTAT
• V$LOCK
• V$LOCK_ACTIVITY
• V$LOCK_TYPE
• V$LOCKED_OBJECT
• V$LOG
• V$LOG_HISTORY
• V$LOGFILE
• V$LOGHIST
• V$LOGMNR_CONTENTS
• V$LOGMNR_DICTIONARY
• V$LOGMNR_DICTIONARY_LOAD
• V$LOGMNR_LATCH
• V$LOGMNR_LOGS
• V$LOGMNR_PARAMETERS
• V$LOGMNR_PROCESS
• V$LOGMNR_SESSION
• V$LOGMNR_STATS
• V$LOGSTDBY
• V$LOGSTDBY_PROCESS
• V$LOGSTDBY_PROGRESS
• V$LOGSTDBY_STATE
• V$LOGSTDBY_STATS
• V$LOGSTDBY_TRANSACTION
• V$MANAGED_STANDBY
• 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
• V$MAP_SUBELEMENT
• V$MEMORY_CURRENT_RESIZE_OPS
• V$MEMORY_DYNAMIC_COMPONENTS
• V$MEMORY_RESIZE_OPS
• V$MEMORY_TARGET_ADVICE
• V$METRIC
• V$METRICGROUP
• V$METRIC_HISTORY
• V$METRICNAME
• V$MTTR_TARGET_ADVICE
• V$MUTEX_SLEEP
• V$MUTEX_SLEEP_HISTORY
• V$MVREFRESH
• V$MYSTAT
• V$NFS_CLIENTS
• V$NFS_LOCKS
• V$NFS_OPEN_FILES
• V$NLS_PARAMETERS
• V$NLS_VALID_VALUES
• V$OBJECT_DEPENDENCY
• V$OBJECT_PRIVILEGE
• V$OBJECT_USAGE
• V$OBSOLETE_BACKUP_FILES
• V$OBSOLETE_PARAMETER
• V$OFFLINE_RANGE
• V$OPEN_CURSOR
• V$OPTION
• V$OSSTAT
• V$PARALLEL_DEGREE_LIMIT_MTH
• V$PARAMETER
• V$PARAMETER_VALID_VALUES
• V$PARAMETER2
• V$PERSISTENT_PUBLISHERS
• V$PERSISTENT_QUEUES
• V$PERSISTENT_SUBSCRIBERS
• V$PGA_TARGET_ADVICE
• V$PGA_TARGET_ADVICE_HISTOGRAM
• V$PGASTAT
• V$PQ_SESSTAT
• V$PQ_SLAVE
• V$PQ_SYSSTAT
• V$PQ_TQSTAT
• V$PROCESS
• V$PROCESS_MEMORY
• V$PROPAGATION_RECEIVER
• V$PROPAGATION_SENDER
• V$PROXY_ARCHIVEDLOG
• V$PROXY_ARCHIVELOG_DETAILS
• V$PROXY_ARCHIVELOG_SUMMARY
• V$PROXY_COPY_DETAILS
• V$PROXY_COPY_SUMMARY
• V$PROXY_DATAFILE
• V$PWFILE_USERS
• V$PX_INSTANCE_GROUP
• V$PX_PROCESS
• V$PX_PROCESS_SYSSTAT
• V$PX_SESSION
• V$PX_SESSTAT
• V$QUEUE
• V$QUEUEING_MTH
• V$RECOVER_FILE
• V$RECOVERY_FILE_DEST
• V$RECOVERY_FILE_STATUS
• V$RECOVERY_LOG
• V$RECOVERY_PROGRESS
• V$RECOVERY_STATUS
• V$REDO_DEST_RESP_HISTOGRAM
• V$REPLPROP
• V$REPLQUEUE
• V$REQDIST
• V$RESERVED_WORDS
• V$RESOURCE
• V$RESOURCE_LIMIT
• V$RESTORE_POINT
• V$RESULT_CACHE_DEPENDENCY
• V$RESULT_CACHE_MEMORY
• V$RESULT_CACHE_OBJECTS
• V$RESULT_CACHE_STATISTICS
• V$RMAN_BACKUP_JOB_DETAILS
• V$RMAN_BACKUP_SUBJOB_DETAILS
• V$RMAN_BACKUP_TYPE
• V$RMAN_COMPRESSION_ALGORITHM
• V$RMAN_CONFIGURATION
• V$RMAN_ENCRYPTION_ALGORITHMS
• V$RMAN_OUTPUT
• V$RMAN_STATUS
• V$ROLLNAME
• V$ROLLSTAT
• V$ROWCACHE
• V$ROWCACHE_PARENT
• V$ROWCACHE_SUBORDINATE
• V$RSRC_CONS_GROUP_HISTORY
• V$RSRC_CONSUMER_GROUP
• V$RSRC_CONSUMER_GROUP_CPU_MTH
• V$RSRC_PLAN
• V$RSRC_PLAN_CPU_MTH
• V$RSRC_PLAN_HISTORY
• V$RSRC_SESSION_INFO
• V$RSRCMGRMETRIC
• V$RSRCMGRMETRIC_HISTORY
• V$RULE
• V$RULE_SET
• V$RULE_SET_AGGREGATE_STATS

8 Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$XS_SESSION_ROLE

• V$SCHEDULER_RUNNING_JOBS
• V$SECUREFILE_TIMER
• V$SEGMENT_STATISTICS
• V$SEGSTAT
• V$SEGSTAT_NAME
• V$SERV_MOD_ACT_STATS
• V$SERVICE_EVENT
• V$SERVICE_STATS
• V$SERVICE_WAIT_CLASS
• V$SERVICEMETRIC
• V$SERVICEMETRIC_HISTORY
• V$SERVICES
• V$SES_OPTIMIZER_ENV
• V$SESS_IO
• V$SESS_TIME_MODEL
• V$SESSION
• V$SESSION_CONNECT_INFO
• V$SESSION_CURSOR_CACHE
• V$SESSION_EVENT
• V$SESSION_FIX_CONTROL
• V$SESSION_LONGOPS
• V$SESSION_OBJECT_CACHE
• V$SESSION_WAIT
• V$SESSION_WAIT_CLASS
• V$SESSION_WAIT_HISTORY
• V$SESSMETRIC
• V$SESSTAT
• V$SGA
• V$SGA_CURRENT_RESIZE_OPS
• V$SGA_DYNAMIC_COMPONENTS
• V$SGA_DYNAMIC_FREE_MEMORY
• V$SGA_RESIZE_OPS
• V$SGA_TARGET_ADVICE
• V$SGAINFO
• V$SGASTAT
• V$SHARED_POOL_ADVICE
• V$SHARED_POOL_RESERVED
• V$SHARED_SERVER
• V$SHARED_SERVER_MONITOR
• V$SORT_SEGMENT
• V$SPPARAMETER
• V$SQL
• V$SQL_BIND_CAPTURE
• V$SQL_BIND_DATA
• V$SQL_BIND_METADATA
• V$SQL_CURSOR
• V$SQL_JOIN_FILTER
• V$SQL_MONITOR
• V$SQL_OPTIMIZER_ENV
• V$SQL_PLAN
• V$SQL_PLAN_MONITOR
• V$SQL_PLAN_STATISTICS
• V$SQL_PLAN_STATISTICS_ALL
• V$SQL_REDIRECTION
• V$SQL_SHARED_CURSOR
• V$SQL_SHARED_MEMORY
• V$SQL_WORKAREA
• V$SQL_WORKAREA_ACTIVE
• V$SQL_WORKAREA_HISTOGRAM
• V$SQLAREA
• V$SQLAREA_PLAN_HASH
• V$SQLFN_ARG_METADATA
• V$SQLFN_METADATA
• V$SQLSTATS
• V$SQLTEXT
• V$SQLTEXT_WITH_NEWLINES
• V$SSCR_SESSIONS
• V$STANDBY_LOG
• V$STATISTICS_LEVEL
• V$STATNAME
• V$STREAMS_APPLY_COORDINATOR
• V$STREAMS_APPLY_READER
• V$STREAMS_APPLY_SERVER
• V$STREAMS_CAPTURE
• V$STREAMS_MESSAGE_TRACKING
• V$STREAMS_POOL_ADVICE
• V$STREAMS_TRANSACTION
• V$SUBCACHE
• V$SUBSCR_REGISTRATION_STATS
• V$SYS_OPTIMIZER_ENV
• V$SYS_TIME_MODEL
• V$SYSAUX_OCCUPANTS
• V$SYSMETRIC
• V$SYSMETRIC_HISTORY
• V$SYSMETRIC_SUMMARY
• V$SYSSTAT
• V$SYSTEM_CURSOR_CACHE
• V$SYSTEM_EVENT
• V$SYSTEM_FIX_CONTROL
• V$SYSTEM_PARAMETER
• V$SYSTEM_PARAMETER2
• V$SYSTEM_WAIT_CLASS
• V$TABLESPACE
• V$TEMP_CACHE_TRANSFER
• V$TEMP_EXTENT_MAP
• V$TEMP_EXTENT_POOL
• V$TEMP_SPACE_HEADER
• V$TEMPFILE
• V$TEMPORARY_LOBS
• V$TEMPSEG_USAGE
• V$TEMPSTAT
• V$THREAD
• V$THRESHOLD_TYPES
• V$TIMER
• V$TIMEZONE_NAMES
• V$TRANSACTION
• V$TRANSACTION_ENQUEUE
• V$TRANSPORTABLE_PLATFORM
• V$TYPE_SIZE
• V$UNDOSTAT
• V$UNUSABLE_BACKUPFILE_DETAILS
• V$VERSION
• V$VPD_POLICY
• V$WAIT_CHAINS
• V$WAITCLASSMETRIC
• V$WAITCLASSMETRIC_HISTORY
• V$WAITSTAT
• V$WALLET
• V$WORKLOAD_REPLAY_THREAD
• V$XML_AUDIT_TRAIL
• V$XS_SESSION
• V$XS_SESSION_ATTRIBUTE
• V$XS_SESSION_ROLE

A Database Limits

• Datatype Limits
• Physical Database Limits
• Logical Database Limits
• Process and Runtime Limits

B SQL Scripts

• Creating the Data Dictionary
• Creating Additional Data Dictionary Structures
• The "NO" Scripts
• Upgrade and Downgrade Scripts
• Java Scripts

C Oracle Wait Events

• Classes of Wait Events
• Descriptions of Common Wait Event Parameters
• Descriptions of Wait Events
  • alter system set dispatcher
  • batched allocate scn lock request
  • BFILE check if exists
  • BFILE check if open
  • BFILE closure
  • BFILE get length
  • BFILE get name object
  • BFILE get path object
  • BFILE internal seek
  • BFILE open
  • BFILE read
  • broadcast mesg queue transition
  • broadcast mesg recovery queue transition
  • buffer busy waits
  • buffer deadlock
  • buffer latch
  • buffer read retry
  • checkpoint completed
  • cleanup of aborted processes
  • control file parallel write
  • control file sequential read
  • control file single write
  • cursor: mutex S
  • cursor: mutex X
  • cursor: pin S
  • cursor: pin S wait on X
  • cursor: pin X
  • Data Guard: process clean up
  • Data Guard: process exit
  • Data Guard Broker: single instance
  • db file parallel read
  • db file parallel write
  • db file scattered read
  • db file sequential read
  • db file single write
  • DFS db file lock
  • DFS lock handle
  • direct path read
  • direct path write
  • dispatcher shutdown
  • dispatcher timer
  • duplicate cluster key
  • enq: OW - initialization
  • enq: OW - termination
  • enqueue
  • flashback buf free by RVWR
  • free buffer waits
  • free global transaction table entry
  • free process state object
  • GCS lock open S
  • GCS lock open X
  • gcs remastering wait for drop pkey
  • global cache busy
  • global cache lock cleanup
  • global cache freelist
  • inactive session
  • inactive transaction branch
  • index block split
  • instance state change
  • io done
  • kcl bg acks
  • ksxr wait for mount shared
  • ktm: instance recovery
  • latch activity
  • latch free
  • library cache load lock
  • library cache lock
  • library cache pin
  • library cache shutdown
  • LMON global data update
  • lock manager wait for remote message
  • log buffer space
  • log file parallel write
  • log file sequential read
  • log file single write
  • log file switch (archiving needed)
  • log file switch (checkpoint incomplete)
  • log file switch (clearing log file)
  • log file switch (private strand flush incomplete)
  • log file switch completion
  • log file sync
  • log switch/archive
  • optimizer stats update retry
  • parallel recovery change buffer free
  • parallel recovery control message reply
  • parallel recovery coord send blocked
  • parallel recovery coord wait for reply
  • parallel recovery coordinator waits for slave cleanup
  • parallel recovery read buffer free
  • parallel recovery slave next change
  • pending global transaction(s)
  • pipe get
  • pipe put
  • PL/SQL lock timer
  • pmon timer
  • prewarm transfer retry
  • prior process spawner to be cleaned up
  • process startup
  • PX Deque wait
  • PX qref latch
  • PX server shutdown
  • PX signal server
  • Streams AQ: waiting for messages in the queue
  • rdbms ipc message
  • rdbms ipc message block
  • rdbms ipc reply
  • read by other session
  • recovery read
  • resmgr: become active
  • resmgr: cpu quantum
  • rolling migration: cluster quisce
  • row cache lock
  • sbtbufinfo
  • sbtgetbuf
  • sbtmapbuf
  • sbtrelbuf
  • scginq AST call
  • SGA: allocation forcing component growth
  • SGA: MMAN sleep for component shrink
  • SGA: sga_target resize
  • Shared IO Pool Memory
  • single-task message
  • smon timer
  • SQL*Net break/reset to client
  • SQL*Net break/reset to dblink
  • SQL*Net message from client
  • SQL*Net message from dblink
  • SQL*Net message to client
  • SQL*Net message to dblink
  • SQL*Net more data from client
  • SQL*Net more data from dblink
  • SQL*Net more data to client
  • SQL*Net more data to dblink
  • switch logfile command
  • timer in sksawat
  • transaction
  • unbound tx
  • undo_retention publish retry
  • undo segment extension
  • undo segment recovery
  • undo segment tx slot
  • virtual circuit status
  • WMON goes to sleep
  • write complete waits
  • writes stopped by instance recovery or database suspension

D Oracle Enqueue Names

E Statistics Descriptions

• Displaying Statistics
• Statistics Descriptions

Index