1/2823

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Database Reference

• Changes in Oracle Database 12c Release 2 (12.2.0.1)
  • New Features
  • Deprecated Features
  • Desupported Features
• Changes in Oracle Database 12c Release 1 (12.1.0.2)
  • New Features
  • Deprecated Features
• Changes in Oracle Database 12c Release 1 (12.1.0.1)
  • New Features
  • Deprecated Features

Part I Initialization Parameters

1 Initialization Parameters

• 1.1 Uses of Initialization Parameters
  • 1.1.1 Types of Initialization Parameters
    • 1.1.1.1 Derived Parameters
    • 1.1.1.2 Operating System-Dependent Parameters
    • 1.1.1.3 Variable Parameters
• 1.2 Basic Initialization Parameters
• 1.3 Parameter Files
  • 1.3.1 Server Parameter Files
  • 1.3.2 Initialization Parameter Files
    • 1.3.2.1 About the Character Set of Parameter Values
    • 1.3.2.2 Specifying Values in an Initialization Parameter File
      • 1.3.2.2.1 Rules Governing Initialization Parameter Files
      • 1.3.2.2.2 Using Special Characters in Parameter Values
      • 1.3.2.2.3 Using the Escape Character
      • 1.3.2.2.4 Using Quotation Marks
• 1.4 Changing Parameter Values in a Parameter File
  • 1.4.1 Parameters by Functional Category
  • 1.4.2 Modifiable Parameters
  • 1.4.3 Displaying Current Parameter Values
  • 1.4.4 Parameters You Should Not Specify in the Parameter File
  • 1.4.5 When Parameters Are Set Incorrectly
• 1.5 Reading the Parameter Descriptions
• 1.6 Initialization Parameter Descriptions
• 1.7 ACTIVE_INSTANCE_COUNT
• 1.8 ALLOW_GLOBAL_DBLINKS
• 1.9 ALLOW_GROUP_ACCESS_TO_SGA
• 1.10 APPROX_FOR_AGGREGATION
• 1.11 APPROX_FOR_COUNT_DISTINCT
• 1.12 APPROX_FOR_PERCENTILE
• 1.13 AQ_TM_PROCESSES
• 1.14 ARCHIVE_LAG_TARGET
• 1.15 ASM_DISKGROUPS
• 1.16 ASM_DISKSTRING
• 1.17 ASM_IO_PROCESSES
• 1.18 ASM_POWER_LIMIT
• 1.19 ASM_PREFERRED_READ_FAILURE_GROUPS
• 1.20 AUDIT_FILE_DEST
• 1.21 AUDIT_SYS_OPERATIONS
• 1.22 AUDIT_SYSLOG_LEVEL
• 1.23 AUDIT_TRAIL
• 1.24 AUTOTASK_MAX_ACTIVE_PDBS
• 1.25 AWR_PDB_AUTOFLUSH_ENABLED
• 1.26 AWR_SNAPSHOT_TIME_OFFSET
• 1.27 BACKGROUND_CORE_DUMP
• 1.28 BACKGROUND_DUMP_DEST
• 1.29 BACKUP_TAPE_IO_SLAVES
• 1.30 BITMAP_MERGE_AREA_SIZE
• 1.31 BLANK_TRIMMING
• 1.32 CIRCUITS
• 1.33 CLIENT_RESULT_CACHE_LAG
• 1.34 CLIENT_RESULT_CACHE_SIZE
• 1.35 CLONEDB
• 1.36 CLONEDB_DIR
• 1.37 CLUSTER_DATABASE
• 1.38 CLUSTER_DATABASE_INSTANCES
• 1.39 CLUSTER_INTERCONNECTS
• 1.40 COMMIT_LOGGING
• 1.41 COMMIT_POINT_STRENGTH
• 1.42 COMMIT_WAIT
• 1.43 COMMIT_WRITE
• 1.44 COMMON_USER_PREFIX
• 1.45 COMPATIBLE
• 1.46 CONNECTION_BROKERS
• 1.47 CONTAINERS_PARALLEL_DEGREE
• 1.48 CONTROL_FILE_RECORD_KEEP_TIME
• 1.49 CONTROL_FILES
• 1.50 CONTROL_MANAGEMENT_PACK_ACCESS
• 1.51 CORE_DUMP_DEST
• 1.52 CPU_COUNT
• 1.53 CREATE_BITMAP_AREA_SIZE
• 1.54 CREATE_STORED_OUTLINES
• 1.55 CURSOR_BIND_CAPTURE_DESTINATION
• 1.56 CURSOR_INVALIDATION
• 1.57 CURSOR_SHARING
• 1.58 CURSOR_SPACE_FOR_TIME
• 1.59 DATA_GUARD_SYNC_LATENCY
• 1.60 DATA_TRANSFER_CACHE_SIZE
• 1.61 DB_nK_CACHE_SIZE
• 1.62 DB_BIG_TABLE_CACHE_PERCENT_TARGET
• 1.63 DB_BLOCK_BUFFERS
• 1.64 DB_BLOCK_CHECKING
• 1.65 DB_BLOCK_CHECKSUM
• 1.66 DB_BLOCK_SIZE
• 1.67 DB_CACHE_ADVICE
• 1.68 DB_CACHE_SIZE
• 1.69 DB_CREATE_FILE_DEST
• 1.70 DB_CREATE_ONLINE_LOG_DEST_n
• 1.71 DB_DOMAIN
• 1.72 DB_FILE_MULTIBLOCK_READ_COUNT
• 1.73 DB_FILE_NAME_CONVERT
• 1.74 DB_FILES
• 1.75 DB_FLASH_CACHE_FILE
• 1.76 DB_FLASH_CACHE_SIZE
• 1.77 DB_FLASHBACK_RETENTION_TARGET
• 1.78 DB_INDEX_COMPRESSION_INHERITANCE
• 1.79 DB_KEEP_CACHE_SIZE
• 1.80 DB_LOST_WRITE_PROTECT
• 1.81 DB_NAME
• 1.82 DB_PERFORMANCE_PROFILE
• 1.83 DB_RECOVERY_FILE_DEST
• 1.84 DB_RECOVERY_FILE_DEST_SIZE
• 1.85 DB_RECYCLE_CACHE_SIZE
• 1.86 DB_SECUREFILE
• 1.87 DB_ULTRA_SAFE
• 1.88 DB_UNIQUE_NAME
• 1.89 DB_UNRECOVERABLE_SCN_TRACKING
• 1.90 DB_WRITER_PROCESSES
• 1.91 DBFIPS_140
• 1.92 DBWR_IO_SLAVES
• 1.93 DDL_LOCK_TIMEOUT
• 1.94 DEFAULT_SHARING
• 1.95 DEFERRED_SEGMENT_CREATION
• 1.96 DG_BROKER_CONFIG_FILEn
• 1.97 DG_BROKER_START
• 1.98 DIAGNOSTIC_DEST
• 1.99 DISK_ASYNCH_IO
• 1.100 DISPATCHERS
• 1.101 DISTRIBUTED_LOCK_TIMEOUT
• 1.102 DML_LOCKS
• 1.103 DNFS_BATCH_SIZE
• 1.104 DST_UPGRADE_INSERT_CONV
• 1.105 ENABLE_AUTOMATIC_MAINTENANCE_PDB
• 1.106 ENABLE_DDL_LOGGING
• 1.107 ENABLE_DNFS_DISPATCHER
• 1.108 ENABLE_GOLDENGATE_REPLICATION
• 1.109 ENABLE_PLUGGABLE_DATABASE
• 1.110 ENABLED_PDBS_ON_STANDBY
• 1.111 ENCRYPT_NEW_TABLESPACES
• 1.112 EVENT
• 1.113 EXAFUSION_ENABLED
• 1.114 EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION
• 1.115 FAL_CLIENT
• 1.116 FAL_SERVER
• 1.117 FAST_START_MTTR_TARGET
• 1.118 FAST_START_PARALLEL_ROLLBACK
• 1.119 FILE_MAPPING
• 1.120 FILEIO_NETWORK_ADAPTERS
• 1.121 FILESYSTEMIO_OPTIONS
• 1.122 FIXED_DATE
• 1.123 GCS_SERVER_PROCESSES
• 1.124 GLOBAL_NAMES
• 1.125 GLOBAL_TXN_PROCESSES
• 1.126 HASH_AREA_SIZE
• 1.127 HEAT_MAP
• 1.128 HI_SHARED_MEMORY_ADDRESS
• 1.129 HS_AUTOREGISTER
• 1.130 IFILE
• 1.131 INMEMORY_ADG_ENABLED
• 1.132 INMEMORY_CLAUSE_DEFAULT
• 1.133 INMEMORY_EXPRESSIONS_USAGE
• 1.134 INMEMORY_FORCE
• 1.135 INMEMORY_MAX_POPULATE_SERVERS
• 1.136 INMEMORY_QUERY
• 1.137 INMEMORY_SIZE
• 1.138 INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
• 1.139 INMEMORY_VIRTUAL_COLUMNS
• 1.140 INSTANCE_ABORT_DELAY_TIME
• 1.141 INSTANCE_GROUPS
• 1.142 INSTANCE_MODE
• 1.143 INSTANCE_NAME
• 1.144 INSTANCE_NUMBER
• 1.145 INSTANCE_TYPE
• 1.146 JAVA_JIT_ENABLED
• 1.147 JAVA_MAX_SESSIONSPACE_SIZE
• 1.148 JAVA_POOL_SIZE
• 1.149 JAVA_SOFT_SESSIONSPACE_LIMIT
• 1.150 JOB_QUEUE_PROCESSES
• 1.151 LARGE_POOL_SIZE
• 1.152 LDAP_DIRECTORY_ACCESS
• 1.153 LDAP_DIRECTORY_SYSAUTH
• 1.154 LICENSE_MAX_SESSIONS
• 1.155 LICENSE_MAX_USERS
• 1.156 LICENSE_SESSIONS_WARNING
• 1.157 LISTENER_NETWORKS
• 1.158 LOCAL_LISTENER
• 1.159 LOCK_NAME_SPACE
• 1.160 LOCK_SGA
• 1.161 LOG_ARCHIVE_CONFIG
• 1.162 LOG_ARCHIVE_DEST
• 1.163 LOG_ARCHIVE_DEST_n
• 1.164 LOG_ARCHIVE_DEST_STATE_n
• 1.165 LOG_ARCHIVE_DUPLEX_DEST
• 1.166 LOG_ARCHIVE_FORMAT
• 1.167 LOG_ARCHIVE_MAX_PROCESSES
• 1.168 LOG_ARCHIVE_MIN_SUCCEED_DEST
• 1.169 LOG_ARCHIVE_TRACE
• 1.170 LOG_BUFFER
• 1.171 LOG_CHECKPOINT_INTERVAL
• 1.172 LOG_CHECKPOINT_TIMEOUT
• 1.173 LOG_CHECKPOINTS_TO_ALERT
• 1.174 LOG_FILE_NAME_CONVERT
• 1.175 LONG_MODULE_ACTION
• 1.176 MAX_DATAPUMP_JOBS_PER_PDB
• 1.177 MAX_DISPATCHERS
• 1.178 MAX_DUMP_FILE_SIZE
• 1.179 MAX_IDLE_TIME
• 1.180 MAX_IOPS
• 1.181 MAX_MBPS
• 1.182 MAX_PDBS
• 1.183 MAX_SHARED_SERVERS
• 1.184 MAX_STRING_SIZE
• 1.185 MEMORY_MAX_TARGET
• 1.186 MEMORY_TARGET
• 1.187 NLS_CALENDAR
• 1.188 NLS_COMP
• 1.189 NLS_CURRENCY
• 1.190 NLS_DATE_FORMAT
• 1.191 NLS_DATE_LANGUAGE
• 1.192 NLS_DUAL_CURRENCY
• 1.193 NLS_ISO_CURRENCY
• 1.194 NLS_LANGUAGE
• 1.195 NLS_LENGTH_SEMANTICS
• 1.196 NLS_NCHAR_CONV_EXCP
• 1.197 NLS_NUMERIC_CHARACTERS
• 1.198 NLS_SORT
• 1.199 NLS_TERRITORY
• 1.200 NLS_TIMESTAMP_FORMAT
• 1.201 NLS_TIMESTAMP_TZ_FORMAT
• 1.202 NONCDB_COMPATIBLE
• 1.203 O7_DICTIONARY_ACCESSIBILITY
• 1.204 OBJECT_CACHE_MAX_SIZE_PERCENT
• 1.205 OBJECT_CACHE_OPTIMAL_SIZE
• 1.206 OFS_THREADS
• 1.207 OLAP_PAGE_POOL_SIZE
• 1.208 ONE_STEP_PLUGIN_FOR_PDB_WITH_TDE
• 1.209 OPEN_CURSORS
• 1.210 OPEN_LINKS
• 1.211 OPEN_LINKS_PER_INSTANCE
• 1.212 OPTIMIZER_ADAPTIVE_PLANS
• 1.213 OPTIMIZER_ADAPTIVE_REPORTING_ONLY
• 1.214 OPTIMIZER_ADAPTIVE_STATISTICS
• 1.215 OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
• 1.216 OPTIMIZER_DYNAMIC_SAMPLING
• 1.217 OPTIMIZER_FEATURES_ENABLE
• 1.218 OPTIMIZER_INDEX_CACHING
• 1.219 OPTIMIZER_INDEX_COST_ADJ
• 1.220 OPTIMIZER_INMEMORY_AWARE
• 1.221 OPTIMIZER_MODE
• 1.222 OPTIMIZER_SECURE_VIEW_MERGING
• 1.223 OPTIMIZER_USE_INVISIBLE_INDEXES
• 1.224 OPTIMIZER_USE_PENDING_STATISTICS
• 1.225 OPTIMIZER_USE_SQL_PLAN_BASELINES
• 1.226 OS_AUTHENT_PREFIX
• 1.227 OS_ROLES
• 1.228 OUTBOUND_DBLINK_PROTOCOLS
• 1.229 PARALLEL_ADAPTIVE_MULTI_USER
• 1.230 PARALLEL_DEGREE_LIMIT
• 1.231 PARALLEL_DEGREE_POLICY
• 1.232 PARALLEL_EXECUTION_MESSAGE_SIZE
• 1.233 PARALLEL_FORCE_LOCAL
• 1.234 PARALLEL_INSTANCE_GROUP
• 1.235 PARALLEL_MAX_SERVERS
• 1.236 PARALLEL_MIN_PERCENT
• 1.237 PARALLEL_MIN_SERVERS
• 1.238 PARALLEL_MIN_TIME_THRESHOLD
• 1.239 PARALLEL_SERVERS_TARGET
• 1.240 PARALLEL_THREADS_PER_CPU
• 1.241 PDB_FILE_NAME_CONVERT
• 1.242 PDB_LOCKDOWN
• 1.243 PDB_OS_CREDENTIAL
• 1.244 PERMIT_92_WRAP_FORMAT
• 1.245 PGA_AGGREGATE_LIMIT
• 1.246 PGA_AGGREGATE_TARGET
• 1.247 PLSCOPE_SETTINGS
• 1.248 PLSQL_CCFLAGS
• 1.249 PLSQL_CODE_TYPE
• 1.250 PLSQL_DEBUG
• 1.251 PLSQL_OPTIMIZE_LEVEL
• 1.252 PLSQL_V2_COMPATIBILITY
• 1.253 PLSQL_WARNINGS
• 1.254 PRE_PAGE_SGA
• 1.255 PROCESSES
• 1.256 PROCESSOR_GROUP_NAME
• 1.257 QUERY_REWRITE_ENABLED
• 1.258 QUERY_REWRITE_INTEGRITY
• 1.259 RDBMS_SERVER_DN
• 1.260 READ_ONLY_OPEN_DELAYED
• 1.261 RECOVERY_PARALLELISM
• 1.262 RECYCLEBIN
• 1.263 REDO_TRANSPORT_USER
• 1.264 REMOTE_DEPENDENCIES_MODE
• 1.265 REMOTE_LISTENER
• 1.266 REMOTE_LOGIN_PASSWORDFILE
• 1.267 REMOTE_OS_AUTHENT
• 1.268 REMOTE_OS_ROLES
• 1.269 REMOTE_RECOVERY_FILE_DEST
• 1.270 REPLICATION_DEPENDENCY_TRACKING
• 1.271 RESOURCE_LIMIT
• 1.272 RESOURCE_MANAGER_CPU_ALLOCATION
• 1.273 RESOURCE_MANAGER_PLAN
• 1.274 RESOURCE_MANAGE_GOLDENGATE
• 1.275 RESULT_CACHE_MAX_RESULT
• 1.276 RESULT_CACHE_MAX_SIZE
• 1.277 RESULT_CACHE_MODE
• 1.278 RESULT_CACHE_REMOTE_EXPIRATION
• 1.279 RESUMABLE_TIMEOUT
• 1.280 ROLLBACK_SEGMENTS
• 1.281 SEC_CASE_SENSITIVE_LOGON
• 1.282 SEC_MAX_FAILED_LOGIN_ATTEMPTS
• 1.283 SEC_PROTOCOL_ERROR_FURTHER_ACTION
• 1.284 SEC_PROTOCOL_ERROR_TRACE_ACTION
• 1.285 SEC_RETURN_SERVER_RELEASE_BANNER
• 1.286 SERIAL_REUSE
• 1.287 SERVICE_NAMES
• 1.288 SESSION_CACHED_CURSORS
• 1.289 SESSION_MAX_OPEN_FILES
• 1.290 SESSIONS
• 1.291 SGA_MAX_SIZE
• 1.292 SGA_MIN_SIZE
• 1.293 SGA_TARGET
• 1.294 SHADOW_CORE_DUMP
• 1.295 SHARED_MEMORY_ADDRESS
• 1.296 SHARED_POOL_RESERVED_SIZE
• 1.297 SHARED_POOL_SIZE
• 1.298 SHARED_SERVER_SESSIONS
• 1.299 SHARED_SERVERS
• 1.300 SHRD_DUPL_TABLE_REFRESH_RATE
• 1.301 SKIP_UNUSABLE_INDEXES
• 1.302 SMTP_OUT_SERVER
• 1.303 SORT_AREA_RETAINED_SIZE
• 1.304 SORT_AREA_SIZE
• 1.305 SPATIAL_VECTOR_ACCELERATION
• 1.306 SPFILE
• 1.307 SQL_TRACE
• 1.308 SQL92_SECURITY
• 1.309 SQLTUNE_CATEGORY
• 1.310 STANDBY_ARCHIVE_DEST
• 1.311 STANDBY_DB_PRESERVE_STATES
• 1.312 STANDBY_FILE_MANAGEMENT
• 1.313 STAR_TRANSFORMATION_ENABLED
• 1.314 STATISTICS_LEVEL
• 1.315 STREAMS_POOL_SIZE
• 1.316 TAPE_ASYNCH_IO
• 1.317 TEMP_UNDO_ENABLED
• 1.318 THREAD
• 1.319 THREADED_EXECUTION
• 1.320 TIMED_OS_STATISTICS
• 1.321 TIMED_STATISTICS
• 1.322 TRACE_ENABLED
• 1.323 TRACEFILE_IDENTIFIER
• 1.324 TRANSACTIONS
• 1.325 TRANSACTIONS_PER_ROLLBACK_SEGMENT
• 1.326 UNDO_MANAGEMENT
• 1.327 UNDO_RETENTION
• 1.328 UNDO_TABLESPACE
• 1.329 UNIFIED_AUDIT_SGA_QUEUE_SIZE
• 1.330 UNIFORM_LOG_TIMESTAMP_FORMAT
• 1.331 USE_DEDICATED_BROKER
• 1.332 USE_LARGE_PAGES
• 1.333 USER_DUMP_DEST
• 1.334 UTL_FILE_DIR
• 1.335 WORKAREA_SIZE_POLICY
• 1.336 XML_DB_EVENTS

Part II Static Data Dictionary Views

2 Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES

• 2.1 About Static Data Dictionary Views
• 2.2 CDB_* Views
• 2.3 AWR_PDB_* Views
• 2.4 AWR_ROOT_* Views
• 2.5 Oracle Database Real Application Security Views
• 2.6 Oracle Label Security Views
• 2.7 Oracle Database Vault Views
• 2.8 Oracle Workspace Manager Views
• 2.9 Recovery Catalog Views
• 2.10 Static Data Dictionary View Descriptions
• 2.11 ALL_ALL_TABLES
• 2.12 ALL_ANALYTIC_VIEW_ATTR_CLASS
• 2.13 ALL_ANALYTIC_VIEW_BASE_MEAS
• 2.14 ALL_ANALYTIC_VIEW_CALC_MEAS
• 2.15 ALL_ANALYTIC_VIEW_CLASS
• 2.16 ALL_ANALYTIC_VIEW_COLUMNS
• 2.17 ALL_ANALYTIC_VIEW_DIM_CLASS
• 2.18 ALL_ANALYTIC_VIEW_DIMENSIONS
• 2.19 ALL_ANALYTIC_VIEW_HIER_CLASS
• 2.20 ALL_ANALYTIC_VIEW_HIERS
• 2.21 ALL_ANALYTIC_VIEW_KEYS
• 2.22 ALL_ANALYTIC_VIEW_LEVEL_CLASS
• 2.23 ALL_ANALYTIC_VIEW_LEVELS
• 2.24 ALL_ANALYTIC_VIEW_LVLGRPS
• 2.25 ALL_ANALYTIC_VIEW_MEAS_CLASS
• 2.26 ALL_ANALYTIC_VIEWS
• 2.27 ALL_APPLY
• 2.28 ALL_APPLY_CHANGE_HANDLERS
• 2.29 ALL_APPLY_CONFLICT_COLUMNS
• 2.30 ALL_APPLY_DML_CONF_HANDLERS
• 2.31 ALL_APPLY_DML_HANDLERS
• 2.32 ALL_APPLY_ENQUEUE
• 2.33 ALL_APPLY_ERROR
• 2.34 ALL_APPLY_ERROR_MESSAGES
• 2.35 ALL_APPLY_EXECUTE
• 2.36 ALL_APPLY_HANDLE_COLLISIONS
• 2.37 ALL_APPLY_INSTANTIATED_GLOBAL
• 2.38 ALL_APPLY_INSTANTIATED_OBJECTS
• 2.39 ALL_APPLY_INSTANTIATED_SCHEMAS
• 2.40 ALL_APPLY_KEY_COLUMNS
• 2.41 ALL_APPLY_PARAMETERS
• 2.42 ALL_APPLY_PROGRESS
• 2.43 ALL_APPLY_REPERROR_HANDLERS
• 2.44 ALL_APPLY_TABLE_COLUMNS
• 2.45 ALL_ARGUMENTS
• 2.46 ALL_ASSEMBLIES
• 2.47 ALL_ASSOCIATIONS
• 2.48 ALL_ATTRIBUTE_DIM_ATTR_CLASS
• 2.49 ALL_ATTRIBUTE_DIM_ATTRS
• 2.50 ALL_ATTRIBUTE_DIM_CLASS
• 2.51 ALL_ATTRIBUTE_DIM_JOIN_PATHS
• 2.52 ALL_ATTRIBUTE_DIM_KEYS
• 2.53 ALL_ATTRIBUTE_DIM_LEVEL_ATTRS
• 2.54 ALL_ATTRIBUTE_DIM_LEVELS
• 2.55 ALL_ATTRIBUTE_DIM_LVL_CLASS
• 2.56 ALL_ATTRIBUTE_DIM_ORDER_ATTRS
• 2.57 ALL_ATTRIBUTE_DIM_TABLES
• 2.58 ALL_ATTRIBUTE_DIMENSIONS
• 2.59 ALL_ATTRIBUTE_TRANSFORMATIONS
• 2.60 ALL_AUDIT_POLICIES
• 2.61 ALL_AUDIT_POLICY_COLUMNS
• 2.62 ALL_AW_PS
• 2.63 ALL_AWS
• 2.64 ALL_BASE_TABLE_MVIEWS
• 2.65 ALL_CAPTURE
• 2.66 ALL_CAPTURE_EXTRA_ATTRIBUTES
• 2.67 ALL_CAPTURE_PARAMETERS
• 2.68 ALL_CAPTURE_PREPARED_DATABASE
• 2.69 ALL_CAPTURE_PREPARED_SCHEMAS
• 2.70 ALL_CAPTURE_PREPARED_TABLES
• 2.71 ALL_CATALOG
• 2.72 ALL_CLUSTER_HASH_EXPRESSIONS
• 2.73 ALL_CLUSTERING_DIMENSIONS
• 2.74 ALL_CLUSTERING_JOINS
• 2.75 ALL_CLUSTERING_KEYS
• 2.76 ALL_CLUSTERING_TABLES
• 2.77 ALL_CLUSTERS
• 2.78 ALL_CODE_ROLE_PRIVS
• 2.79 ALL_COL_COMMENTS
• 2.80 ALL_COL_PENDING_STATS
• 2.81 ALL_COL_PRIVS
• 2.82 ALL_COL_PRIVS_MADE
• 2.83 ALL_COL_PRIVS_RECD
• 2.84 ALL_COLL_TYPES
• 2.85 ALL_CONS_COLUMNS
• 2.86 ALL_CONS_OBJ_COLUMNS
• 2.87 ALL_CONSTRAINTS
• 2.88 ALL_CONTEXT
• 2.89 ALL_CREDENTIALS
• 2.90 ALL_CUBE_ATTR_VISIBILITY
• 2.91 ALL_CUBE_ATTRIBUTES
• 2.92 ALL_CUBE_BUILD_PROCESSES
• 2.93 ALL_CUBE_CALCULATED_MEMBERS
• 2.94 ALL_CUBE_DIM_LEVELS
• 2.95 ALL_CUBE_DIM_MODELS
• 2.96 ALL_CUBE_DIM_VIEW_COLUMNS
• 2.97 ALL_CUBE_DIM_VIEWS
• 2.98 ALL_CUBE_DIMENSIONALITY
• 2.99 ALL_CUBE_DIMENSIONS
• 2.100 ALL_CUBE_HIER_LEVELS
• 2.101 ALL_CUBE_HIER_VIEW_COLUMNS
• 2.102 ALL_CUBE_HIER_VIEWS
• 2.103 ALL_CUBE_HIERARCHIES
• 2.104 ALL_CUBE_MEASURES
• 2.105 ALL_CUBE_NAMED_BUILD_SPECS
• 2.106 ALL_CUBE_SUB_PARTITION_LEVELS
• 2.107 ALL_CUBE_VIEW_COLUMNS
• 2.108 ALL_CUBE_VIEWS
• 2.109 ALL_CUBES
• 2.110 ALL_DB_LINKS
• 2.111 ALL_DEF_AUDIT_OPTS
• 2.112 ALL_DEPENDENCIES
• 2.113 ALL_DEQUEUE_QUEUES
• 2.114 ALL_DIM_ATTRIBUTES
• 2.115 ALL_DIM_CHILD_OF
• 2.116 ALL_DIM_HIERARCHIES
• 2.117 ALL_DIM_JOIN_KEY
• 2.118 ALL_DIM_LEVEL_KEY
• 2.119 ALL_DIM_LEVELS
• 2.120 ALL_DIMENSIONS
• 2.121 ALL_DIRECTORIES
• 2.122 ALL_EDITION_COMMENTS
• 2.123 ALL_EDITIONING_VIEW_COLS
• 2.124 ALL_EDITIONING_VIEW_COLS_AE
• 2.125 ALL_EDITIONING_VIEWS
• 2.126 ALL_EDITIONING_VIEWS_AE
• 2.127 ALL_EDITIONS
• 2.128 ALL_ENCRYPTED_COLUMNS
• 2.129 ALL_ERROR_TRANSLATIONS
• 2.130 ALL_ERRORS
• 2.131 ALL_ERRORS_AE
• 2.132 ALL_EVALUATION_CONTEXT_TABLES
• 2.133 ALL_EVALUATION_CONTEXT_VARS
• 2.134 ALL_EVALUATION_CONTEXTS
• 2.135 ALL_EXPRESSION_STATISTICS
• 2.136 ALL_EXTERNAL_LOCATIONS
• 2.137 ALL_EXTERNAL_TABLES
• 2.138 ALL_FILE_GROUP_EXPORT_INFO
• 2.139 ALL_FILE_GROUP_FILES
• 2.140 ALL_FILE_GROUP_TABLES
• 2.141 ALL_FILE_GROUP_TABLESPACES
• 2.142 ALL_FILE_GROUP_VERSIONS
• 2.143 ALL_FILE_GROUPS
• 2.144 ALL_GG_INBOUND_PROGRESS
• 2.145 ALL_GOLDENGATE_INBOUND
• 2.146 ALL_GOLDENGATE_PRIVILEGES
• 2.147 ALL_GOLDENGATE_RULES
• 2.148 ALL_HEAT_MAP_SEG_HISTOGRAM
• 2.149 ALL_HEAT_MAP_SEGMENT
• 2.150 ALL_HIER_CLASS
• 2.151 ALL_HIER_COLUMNS
• 2.152 ALL_HIER_HIER_ATTR_CLASS
• 2.153 ALL_HIER_HIER_ATTRIBUTES
• 2.154 ALL_HIER_JOIN_PATHS
• 2.155 ALL_HIER_LEVEL_ID_ATTRS
• 2.156 ALL_HIER_LEVELS
• 2.157 ALL_HIERARCHIES
• 2.158 ALL_HISTOGRAMS
• 2.159 ALL_HIVE_COLUMNS
• 2.160 ALL_HIVE_DATABASES
• 2.161 ALL_HIVE_PART_KEY_COLUMNS
• 2.162 ALL_HIVE_TAB_PARTITIONS
• 2.163 ALL_HIVE_TABLES
• 2.164 ALL_IDENTIFIERS
• 2.165 ALL_IND_COLUMNS
• 2.166 ALL_IND_EXPRESSIONS
• 2.167 ALL_IND_PARTITIONS
• 2.168 ALL_IND_PENDING_STATS
• 2.169 ALL_IND_STATISTICS
• 2.170 ALL_IND_SUBPARTITIONS
• 2.171 ALL_INDEXES
• 2.172 ALL_INDEXTYPE_ARRAYTYPES
• 2.173 ALL_INDEXTYPE_COMMENTS
• 2.174 ALL_INDEXTYPE_OPERATORS
• 2.175 ALL_INDEXTYPES
• 2.176 ALL_INTERNAL_TRIGGERS
• 2.177 ALL_JAVA_ARGUMENTS
• 2.178 ALL_JAVA_CLASSES
• 2.179 ALL_JAVA_COMPILER_OPTIONS
• 2.180 ALL_JAVA_DERIVATIONS
• 2.181 ALL_JAVA_FIELDS
• 2.182 ALL_JAVA_IMPLEMENTS
• 2.183 ALL_JAVA_INNERS
• 2.184 ALL_JAVA_LAYOUTS
• 2.185 ALL_JAVA_METHODS
• 2.186 ALL_JAVA_NCOMPS
• 2.187 ALL_JAVA_RESOLVERS
• 2.188 ALL_JAVA_THROWS
• 2.189 ALL_JOBS
• 2.190 ALL_JOIN_IND_COLUMNS
• 2.191 ALL_JSON_COLUMNS
• 2.192 ALL_JSON_DATAGUIDES
• 2.193 ALL_LIBRARIES
• 2.194 ALL_LOB_PARTITIONS
• 2.195 ALL_LOB_SUBPARTITIONS
• 2.196 ALL_LOB_TEMPLATES
• 2.197 ALL_LOBS
• 2.198 ALL_LOG_GROUP_COLUMNS
• 2.199 ALL_LOG_GROUPS
• 2.200 ALL_MEASURE_FOLDER_CONTENTS
• 2.201 ALL_MEASURE_FOLDER_SUBFOLDERS
• 2.202 ALL_MEASURE_FOLDERS
• 2.203 ALL_METADATA_PROPERTIES
• 2.204 ALL_METHOD_PARAMS
• 2.205 ALL_METHOD_RESULTS
• 2.206 ALL_MINING_MODEL_ATTRIBUTES
• 2.207 ALL_MINING_MODEL_PARTITIONS
• 2.208 ALL_MINING_MODEL_SETTINGS
• 2.209 ALL_MINING_MODEL_VIEWS
• 2.210 ALL_MINING_MODEL_XFORMS
• 2.211 ALL_MINING_MODELS
• 2.212 ALL_MVIEW_AGGREGATES
• 2.213 ALL_MVIEW_ANALYSIS
• 2.214 ALL_MVIEW_COMMENTS
• 2.215 ALL_MVIEW_DETAIL_PARTITION
• 2.216 ALL_MVIEW_DETAIL_RELATIONS
• 2.217 ALL_MVIEW_DETAIL_SUBPARTITION
• 2.218 ALL_MVIEW_JOINS
• 2.219 ALL_MVIEW_KEYS
• 2.220 ALL_MVIEW_LOGS
• 2.221 ALL_MVIEW_REFRESH_TIMES
• 2.222 ALL_MVIEWS
• 2.223 ALL_NESTED_TABLE_COLS
• 2.224 ALL_NESTED_TABLES
• 2.225 ALL_OBJ_COLATTRS
• 2.226 ALL_OBJECT_TABLES
• 2.227 ALL_OBJECTS
• 2.228 ALL_OBJECTS_AE
• 2.229 ALL_OPANCILLARY
• 2.230 ALL_OPARGUMENTS
• 2.231 ALL_OPBINDINGS
• 2.232 ALL_OPERATOR_COMMENTS
• 2.233 ALL_OPERATORS
• 2.234 ALL_OUTLINE_HINTS
• 2.235 ALL_OUTLINES

3 Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES

• 3.1 ALL_PART_COL_STATISTICS
• 3.2 ALL_PART_HISTOGRAMS
• 3.3 ALL_PART_INDEXES
• 3.4 ALL_PART_KEY_COLUMNS
• 3.5 ALL_PART_LOBS
• 3.6 ALL_PART_TABLES
• 3.7 ALL_PARTIAL_DROP_TABS
• 3.8 ALL_PENDING_CONV_TABLES
• 3.9 ALL_PLSQL_COLL_TYPES
• 3.10 ALL_PLSQL_OBJECT_SETTINGS
• 3.11 ALL_PLSQL_TYPE_ATTRS
• 3.12 ALL_PLSQL_TYPES
• 3.13 ALL_POLICIES
• 3.14 ALL_POLICY_ATTRIBUTES
• 3.15 ALL_POLICY_CONTEXTS
• 3.16 ALL_POLICY_GROUPS
• 3.17 ALL_PROCEDURES
• 3.18 ALL_PROPAGATION
• 3.19 ALL_QUEUE_SCHEDULES
• 3.20 ALL_QUEUE_SUBSCRIBERS
• 3.21 ALL_QUEUE_TABLES
• 3.22 ALL_QUEUES
• 3.23 ALL_REFRESH
• 3.24 ALL_REFRESH_CHILDREN
• 3.25 ALL_REFRESH_DEPENDENCIES
• 3.26 ALL_REFS
• 3.27 ALL_REGISTERED_MVIEWS
• 3.28 ALL_REGISTRY_BANNERS
• 3.29 ALL_REPL_DBNAME_MAPPING
• 3.30 ALL_REPLICATION_PROCESS_EVENTS
• 3.31 ALL_REWRITE_EQUIVALENCES
• 3.32 ALL_RULE_SET_RULES
• 3.33 ALL_RULE_SETS
• 3.34 ALL_RULES
• 3.35 ALL_SCHEDULER_CHAIN_RULES
• 3.36 ALL_SCHEDULER_CHAIN_STEPS
• 3.37 ALL_SCHEDULER_CHAINS
• 3.38 ALL_SCHEDULER_CREDENTIALS
• 3.39 ALL_SCHEDULER_DB_DESTS
• 3.40 ALL_SCHEDULER_DESTS
• 3.41 ALL_SCHEDULER_EXTERNAL_DESTS
• 3.42 ALL_SCHEDULER_FILE_WATCHERS
• 3.43 ALL_SCHEDULER_GLOBAL_ATTRIBUTE
• 3.44 ALL_SCHEDULER_GROUP_MEMBERS
• 3.45 ALL_SCHEDULER_GROUPS
• 3.46 ALL_SCHEDULER_INCOMPAT_MEMBER
• 3.47 ALL_SCHEDULER_INCOMPATS
• 3.48 ALL_SCHEDULER_JOB_ARGS
• 3.49 ALL_SCHEDULER_JOB_CLASSES
• 3.50 ALL_SCHEDULER_JOB_DESTS
• 3.51 ALL_SCHEDULER_JOB_LOG
• 3.52 ALL_SCHEDULER_JOB_RUN_DETAILS
• 3.53 ALL_SCHEDULER_JOBS
• 3.54 ALL_SCHEDULER_NOTIFICATIONS
• 3.55 ALL_SCHEDULER_PROGRAM_ARGS
• 3.56 ALL_SCHEDULER_PROGRAMS
• 3.57 ALL_SCHEDULER_REMOTE_DATABASES
• 3.58 ALL_SCHEDULER_REMOTE_JOBSTATE
• 3.59 ALL_SCHEDULER_RESOURCES
• 3.60 ALL_SCHEDULER_RSC_CONSTRAINTS
• 3.61 ALL_SCHEDULER_RUNNING_CHAINS
• 3.62 ALL_SCHEDULER_RUNNING_JOBS
• 3.63 ALL_SCHEDULER_SCHEDULES
• 3.64 ALL_SCHEDULER_WINDOW_DETAILS
• 3.65 ALL_SCHEDULER_WINDOW_GROUPS
• 3.66 ALL_SCHEDULER_WINDOW_LOG
• 3.67 ALL_SCHEDULER_WINDOWS
• 3.68 ALL_SCHEDULER_WINGROUP_MEMBERS
• 3.69 ALL_SEC_RELEVANT_COLS
• 3.70 ALL_SECONDARY_OBJECTS
• 3.71 ALL_SEQUENCES
• 3.72 ALL_SERVICES
• 3.73 ALL_SOURCE
• 3.74 ALL_SOURCE_AE
• 3.75 ALL_SQL_TRANSLATION_PROFILES
• 3.76 ALL_SQL_TRANSLATIONS
• 3.77 ALL_SQLJ_TYPE_ATTRS
• 3.78 ALL_SQLJ_TYPE_METHODS
• 3.79 ALL_SQLJ_TYPES
• 3.80 ALL_SQLSET
• 3.81 ALL_SQLSET_BINDS
• 3.82 ALL_SQLSET_PLANS
• 3.83 ALL_SQLSET_REFERENCES
• 3.84 ALL_SQLSET_STATEMENTS
• 3.85 ALL_STAT_EXTENSIONS
• 3.86 ALL_STATEMENTS
• 3.87 ALL_STORED_SETTINGS
• 3.88 ALL_STREAMS_COLUMNS
• 3.89 ALL_STREAMS_GLOBAL_RULES
• 3.90 ALL_STREAMS_MESSAGE_CONSUMERS
• 3.91 ALL_STREAMS_MESSAGE_RULES
• 3.92 ALL_STREAMS_NEWLY_SUPPORTED
• 3.93 ALL_STREAMS_RULES
• 3.94 ALL_STREAMS_SCHEMA_RULES
• 3.95 ALL_STREAMS_TABLE_RULES
• 3.96 ALL_STREAMS_TRANSFORM_FUNCTION
• 3.97 ALL_STREAMS_UNSUPPORTED
• 3.98 ALL_SUBPART_COL_STATISTICS
• 3.99 ALL_SUBPART_HISTOGRAMS
• 3.100 ALL_SUBPART_KEY_COLUMNS
• 3.101 ALL_SUBPARTITION_TEMPLATES
• 3.102 ALL_SUMDELTA
• 3.103 ALL_SYNC_CAPTURE
• 3.104 ALL_SYNC_CAPTURE_PREPARED_TABS
• 3.105 ALL_SYNC_CAPTURE_TABLES
• 3.106 ALL_SYNONYMS
• 3.107 ALL_TAB_COL_STATISTICS
• 3.108 ALL_TAB_COLS
• 3.109 ALL_TAB_COLUMNS
• 3.110 ALL_TAB_COMMENTS
• 3.111 ALL_TAB_HISTGRM_PENDING_STATS
• 3.112 ALL_TAB_HISTOGRAMS
• 3.113 ALL_TAB_IDENTITY_COLS
• 3.114 ALL_TAB_MODIFICATIONS
• 3.115 ALL_TAB_PARTITIONS
• 3.116 ALL_TAB_PENDING_STATS
• 3.117 ALL_TAB_PRIVS
• 3.118 ALL_TAB_PRIVS_MADE
• 3.119 ALL_TAB_PRIVS_RECD
• 3.120 ALL_TAB_STAT_PREFS
• 3.121 ALL_TAB_STATISTICS
• 3.122 ALL_TAB_STATS_HISTORY
• 3.123 ALL_TAB_SUBPARTITIONS
• 3.124 ALL_TABLES
• 3.125 ALL_TRANSFORMATIONS
• 3.126 ALL_TRIGGER_COLS
• 3.127 ALL_TRIGGER_ORDERING
• 3.128 ALL_TRIGGERS
• 3.129 ALL_TSTZ_TAB_COLS
• 3.130 ALL_TSTZ_TABLES
• 3.131 ALL_TYPE_ATTRS
• 3.132 ALL_TYPE_METHODS
• 3.133 ALL_TYPE_VERSIONS
• 3.134 ALL_TYPES
• 3.135 ALL_UNUSED_COL_TABS
• 3.136 ALL_UPDATABLE_COLUMNS
• 3.137 ALL_USERS
• 3.138 ALL_USTATS
• 3.139 ALL_VARRAYS
• 3.140 ALL_VIEWS
• 3.141 ALL_VIEWS_AE
• 3.142 ALL_WARNING_SETTINGS
• 3.143 ALL_XML_INDEXES
• 3.144 ALL_XML_NESTED_TABLES
• 3.145 ALL_XML_OUT_OF_LINE_TABLES
• 3.146 ALL_XML_SCHEMA_ATTRIBUTES
• 3.147 ALL_XML_SCHEMA_COMPLEX_TYPES
• 3.148 ALL_XML_SCHEMA_ELEMENTS
• 3.149 ALL_XML_SCHEMA_NAMESPACES
• 3.150 ALL_XML_SCHEMA_SIMPLE_TYPES
• 3.151 ALL_XML_SCHEMA_SUBSTGRP_HEAD
• 3.152 ALL_XML_SCHEMA_SUBSTGRP_MBRS
• 3.153 ALL_XML_SCHEMAS
• 3.154 ALL_XML_TAB_COLS
• 3.155 ALL_XML_TABLES
• 3.156 ALL_XML_VIEW_COLS
• 3.157 ALL_XML_VIEWS
• 3.158 ALL_XSTREAM_ADMINISTRATOR
• 3.159 ALL_XSTREAM_INBOUND
• 3.160 ALL_XSTREAM_INBOUND_PROGRESS
• 3.161 ALL_XSTREAM_OUT_SUPPORT_MODE
• 3.162 ALL_XSTREAM_OUTBOUND
• 3.163 ALL_XSTREAM_OUTBOUND_PROGRESS
• 3.164 ALL_XSTREAM_RULES
• 3.165 ALL_XSTREAM_TRANSFORMATIONS
• 3.166 ALL_XTERNAL_LOC_PARTITIONS
• 3.167 ALL_XTERNAL_LOC_SUBPARTITIONS
• 3.168 ALL_XTERNAL_PART_TABLES
• 3.169 ALL_XTERNAL_TAB_PARTITIONS
• 3.170 ALL_XTERNAL_TAB_SUBPARTITIONS
• 3.171 ALL_ZONEMAP_MEASURES
• 3.172 ALL_ZONEMAPS
• 3.173 AUDIT_ACTIONS
• 3.174 AUDIT_UNIFIED_CONTEXTS
• 3.175 AUDIT_UNIFIED_ENABLED_POLICIES
• 3.176 AUDIT_UNIFIED_POLICIES
• 3.177 AUDIT_UNIFIED_POLICY_COMMENTS
• 3.178 AUDITABLE_SYSTEM_ACTIONS
• 3.179 CAT
• 3.180 CATALOG
• 3.181 CHAINED_ROWS
• 3.182 CLIENT_RESULT_CACHE_STATS$
• 3.183 CLU
• 3.184 COL
• 3.185 COLS
• 3.186 DATABASE_EXPORT_OBJECTS
• 3.187 DATABASE_PROPERTIES

4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE

• 4.1 DBA_2PC_NEIGHBORS
• 4.2 DBA_2PC_PENDING
• 4.3 DBA_ACL_NAME_MAP
• 4.4 DBA_ADDM_FDG_BREAKDOWN
• 4.5 DBA_ADDM_FINDINGS
• 4.6 DBA_ADDM_INSTANCES
• 4.7 DBA_ADDM_SYSTEM_DIRECTIVES
• 4.8 DBA_ADDM_TASK_DIRECTIVES
• 4.9 DBA_ADDM_TASKS
• 4.10 DBA_ADVISOR_ACTIONS
• 4.11 DBA_ADVISOR_COMMANDS
• 4.12 DBA_ADVISOR_DEF_PARAMETERS
• 4.13 DBA_ADVISOR_DEFINITIONS
• 4.14 DBA_ADVISOR_DIR_DEFINITIONS
• 4.15 DBA_ADVISOR_DIR_INSTANCES
• 4.16 DBA_ADVISOR_DIR_TASK_INST
• 4.17 DBA_ADVISOR_EXEC_PARAMETERS
• 4.18 DBA_ADVISOR_EXECUTION_TYPES
• 4.19 DBA_ADVISOR_EXECUTIONS
• 4.20 DBA_ADVISOR_FDG_BREAKDOWN
• 4.21 DBA_ADVISOR_FINDING_NAMES
• 4.22 DBA_ADVISOR_FINDINGS
• 4.23 DBA_ADVISOR_JOURNAL
• 4.24 DBA_ADVISOR_LOG
• 4.25 DBA_ADVISOR_OBJECT_TYPES
• 4.26 DBA_ADVISOR_OBJECTS
• 4.27 DBA_ADVISOR_PARAMETERS
• 4.28 DBA_ADVISOR_RATIONALE
• 4.29 DBA_ADVISOR_RECOMMENDATIONS
• 4.30 DBA_ADVISOR_SQLA_REC_SUM
• 4.31 DBA_ADVISOR_SQLA_TABLES
• 4.32 DBA_ADVISOR_SQLA_WK_MAP
• 4.33 DBA_ADVISOR_SQLA_WK_STMTS
• 4.34 DBA_ADVISOR_SQLPLANS
• 4.35 DBA_ADVISOR_SQLSTATS
• 4.36 DBA_ADVISOR_SQLW_JOURNAL
• 4.37 DBA_ADVISOR_SQLW_PARAMETERS
• 4.38 DBA_ADVISOR_SQLW_STMTS
• 4.39 DBA_ADVISOR_SQLW_SUM
• 4.40 DBA_ADVISOR_SQLW_TABLES
• 4.41 DBA_ADVISOR_SQLW_TEMPLATES
• 4.42 DBA_ADVISOR_TASKS
• 4.43 DBA_ADVISOR_TEMPLATES
• 4.44 DBA_ADVISOR_USAGE
• 4.45 DBA_ALERT_HISTORY
• 4.46 DBA_ALERT_HISTORY_DETAIL
• 4.47 DBA_ALL_TABLES
• 4.48 DBA_ANALYTIC_VIEW_ATTR_CLASS
• 4.49 DBA_ANALYTIC_VIEW_BASE_MEAS
• 4.50 DBA_ANALYTIC_VIEW_CALC_MEAS
• 4.51 DBA_ANALYTIC_VIEW_CLASS
• 4.52 DBA_ANALYTIC_VIEW_COLUMNS
• 4.53 DBA_ANALYTIC_VIEW_DIM_CLASS
• 4.54 DBA_ANALYTIC_VIEW_DIMENSIONS
• 4.55 DBA_ANALYTIC_VIEW_HIER_CLASS
• 4.56 DBA_ANALYTIC_VIEW_HIERS
• 4.57 DBA_ANALYTIC_VIEW_KEYS
• 4.58 DBA_ANALYTIC_VIEW_LEVEL_CLASS
• 4.59 DBA_ANALYTIC_VIEW_LEVELS
• 4.60 DBA_ANALYTIC_VIEW_LVLGRPS
• 4.61 DBA_ANALYTIC_VIEW_MEAS_CLASS
• 4.62 DBA_ANALYTIC_VIEWS
• 4.63 DBA_APP_ERRORS
• 4.64 DBA_APP_PATCHES
• 4.65 DBA_APP_PDB_STATUS
• 4.66 DBA_APP_STATEMENTS
• 4.67 DBA_APP_VERSIONS
• 4.68 DBA_APPLICATION_ROLES
• 4.69 DBA_APPLICATIONS
• 4.70 DBA_APPLY
• 4.71 DBA_APPLY_CHANGE_HANDLERS
• 4.72 DBA_APPLY_CONFLICT_COLUMNS
• 4.73 DBA_APPLY_DML_CONF_HANDLERS
• 4.74 DBA_APPLY_DML_HANDLERS
• 4.75 DBA_APPLY_ENQUEUE
• 4.76 DBA_APPLY_ERROR
• 4.77 DBA_APPLY_ERROR_MESSAGES
• 4.78 DBA_APPLY_EXECUTE
• 4.79 DBA_APPLY_HANDLE_COLLISIONS
• 4.80 DBA_APPLY_INSTANTIATED_GLOBAL
• 4.81 DBA_APPLY_INSTANTIATED_OBJECTS
• 4.82 DBA_APPLY_INSTANTIATED_SCHEMAS
• 4.83 DBA_APPLY_KEY_COLUMNS
• 4.84 DBA_APPLY_OBJECT_DEPENDENCIES
• 4.85 DBA_APPLY_PARAMETERS
• 4.86 DBA_APPLY_PROGRESS
• 4.87 DBA_APPLY_REPERROR_HANDLERS
• 4.88 DBA_APPLY_SPILL_TXN
• 4.89 DBA_APPLY_TABLE_COLUMNS
• 4.90 DBA_APPLY_VALUE_DEPENDENCIES
• 4.91 DBA_AQ_AGENT_PRIVS
• 4.92 DBA_AQ_AGENTS
• 4.93 DBA_ARGUMENTS
• 4.94 DBA_ASSEMBLIES
• 4.95 DBA_ASSOCIATIONS
• 4.96 DBA_ATTRIBUTE_DIM_ATTR_CLASS
• 4.97 DBA_ATTRIBUTE_DIM_ATTRS
• 4.98 DBA_ATTRIBUTE_DIM_CLASS
• 4.99 DBA_ATTRIBUTE_DIM_JOIN_PATHS
• 4.100 DBA_ATTRIBUTE_DIM_KEYS
• 4.101 DBA_ATTRIBUTE_DIM_LEVEL_ATTRS
• 4.102 DBA_ATTRIBUTE_DIM_LEVELS
• 4.103 DBA_ATTRIBUTE_DIM_LVL_CLASS
• 4.104 DBA_ATTRIBUTE_DIM_ORDER_ATTRS
• 4.105 DBA_ATTRIBUTE_DIM_TABLES
• 4.106 DBA_ATTRIBUTE_DIMENSIONS
• 4.107 DBA_ATTRIBUTE_TRANSFORMATIONS
• 4.108 DBA_AUDIT_EXISTS
• 4.109 DBA_AUDIT_MGMT_CLEAN_EVENTS
• 4.110 DBA_AUDIT_MGMT_CLEANUP_JOBS
• 4.111 DBA_AUDIT_MGMT_CONFIG_PARAMS
• 4.112 DBA_AUDIT_MGMT_LAST_ARCH_TS
• 4.113 DBA_AUDIT_OBJECT
• 4.114 DBA_AUDIT_POLICIES
• 4.115 DBA_AUDIT_POLICY_COLUMNS
• 4.116 DBA_AUDIT_SESSION
• 4.117 DBA_AUDIT_STATEMENT
• 4.118 DBA_AUDIT_TRAIL
• 4.119 DBA_AUTO_SEGADV_CTL
• 4.120 DBA_AUTO_SEGADV_SUMMARY
• 4.121 DBA_AUTOTASK_CLIENT
• 4.122 DBA_AUTOTASK_CLIENT_HISTORY
• 4.123 DBA_AUTOTASK_CLIENT_JOB
• 4.124 DBA_AUTOTASK_JOB_HISTORY
• 4.125 DBA_AUTOTASK_OPERATION
• 4.126 DBA_AUTOTASK_SCHEDULE
• 4.127 DBA_AUTOTASK_STATUS
• 4.128 DBA_AUTOTASK_TASK
• 4.129 DBA_AUTOTASK_WINDOW_CLIENTS
• 4.130 DBA_AUTOTASK_WINDOW_HISTORY
• 4.131 DBA_AW_PS
• 4.132 DBA_AWS
• 4.133 DBA_BASE_TABLE_MVIEWS
• 4.134 DBA_BLOCKERS
• 4.135 DBA_CAPTURE
• 4.136 DBA_CAPTURE_EXTRA_ATTRIBUTES
• 4.137 DBA_CAPTURE_PARAMETERS
• 4.138 DBA_CAPTURE_PREPARED_DATABASE
• 4.139 DBA_CAPTURE_PREPARED_SCHEMAS
• 4.140 DBA_CAPTURE_PREPARED_TABLES
• 4.141 DBA_CATALOG
• 4.142 DBA_CDB_RSRC_PLAN_DIRECTIVES
• 4.143 DBA_CDB_RSRC_PLANS
• 4.144 DBA_CHANGE_NOTIFICATION_REGS
• 4.145 DBA_CHECKED_ROLES
• 4.146 DBA_CHECKED_ROLES_PATH
• 4.147 DBA_CLU_COLUMNS
• 4.148 DBA_CLUSTER_HASH_EXPRESSIONS
• 4.149 DBA_CLUSTERING_DIMENSIONS
• 4.150 DBA_CLUSTERING_JOINS
• 4.151 DBA_CLUSTERING_KEYS
• 4.152 DBA_CLUSTERING_TABLES
• 4.153 DBA_CLUSTERS
• 4.154 DBA_CODE_ROLE_PRIVS
• 4.155 DBA_COL_COMMENTS
• 4.156 DBA_COL_PENDING_STATS
• 4.157 DBA_COL_PRIVS
• 4.158 DBA_COLL_TYPES
• 4.159 DBA_COMMON_AUDIT_TRAIL
• 4.160 DBA_COMPARISON
• 4.161 DBA_COMPARISON_COLUMNS
• 4.162 DBA_COMPARISON_ROW_DIF
• 4.163 DBA_COMPARISON_SCAN
• 4.164 DBA_COMPARISON_SCAN_VALUES
• 4.165 DBA_CONNECT_ROLE_GRANTEES
• 4.166 DBA_CONS_COLUMNS
• 4.167 DBA_CONS_OBJ_COLUMNS
• 4.168 DBA_CONSTRAINTS
• 4.169 DBA_CONTAINER_DATA
• 4.170 DBA_CONTEXT
• 4.171 DBA_CPOOL_INFO
• 4.172 DBA_CPU_USAGE_STATISTICS
• 4.173 DBA_CQ_NOTIFICATION_QUERIES
• 4.174 DBA_CREDENTIALS
• 4.175 DBA_CUBE_ATTR_VISIBILITY
• 4.176 DBA_CUBE_ATTRIBUTES
• 4.177 DBA_CUBE_BUILD_PROCESSES
• 4.178 DBA_CUBE_CALCULATED_MEMBERS
• 4.179 DBA_CUBE_DIM_LEVELS
• 4.180 DBA_CUBE_DIM_MODELS
• 4.181 DBA_CUBE_DIM_VIEW_COLUMNS
• 4.182 DBA_CUBE_DIM_VIEWS
• 4.183 DBA_CUBE_DIMENSIONALITY
• 4.184 DBA_CUBE_DIMENSIONS
• 4.185 DBA_CUBE_HIER_LEVELS
• 4.186 DBA_CUBE_HIER_VIEW_COLUMNS
• 4.187 DBA_CUBE_HIER_VIEWS
• 4.188 DBA_CUBE_HIERARCHIES
• 4.189 DBA_CUBE_MEASURES
• 4.190 DBA_CUBE_NAMED_BUILD_SPECS
• 4.191 DBA_CUBE_SUB_PARTITION_LEVELS
• 4.192 DBA_CUBE_VIEW_COLUMNS
• 4.193 DBA_CUBE_VIEWS
• 4.194 DBA_CUBES
• 4.195 DBA_DATA_FILES
• 4.196 DBA_DATAPUMP_JOBS
• 4.197 DBA_DATAPUMP_SESSIONS
• 4.198 DBA_DB_LINK_SOURCES
• 4.199 DBA_DB_LINKS
• 4.200 DBA_DBFS_HS
• 4.201 DBA_DBFS_HS_COMMANDS
• 4.202 DBA_DBFS_HS_FIXED_PROPERTIES
• 4.203 DBA_DBFS_HS_PROPERTIES
• 4.204 DBA_DDL_LOCKS
• 4.205 DBA_DEPENDENCIES
• 4.206 DBA_DIGEST_VERIFIERS
• 4.207 DBA_DIM_ATTRIBUTES
• 4.208 DBA_DIM_CHILD_OF
• 4.209 DBA_DIM_HIERARCHIES
• 4.210 DBA_DIM_JOIN_KEY
• 4.211 DBA_DIM_LEVEL_KEY
• 4.212 DBA_DIM_LEVELS
• 4.213 DBA_DIMENSIONS
• 4.214 DBA_DIRECTORIES
• 4.215 DBA_DISCOVERY_SOURCE
• 4.216 DBA_DML_LOCKS
• 4.217 DBA_DMT_FREE_SPACE
• 4.218 DBA_DMT_USED_EXTENTS
• 4.219 DBA_EDITION_COMMENTS
• 4.220 DBA_EDITIONED_TYPES
• 4.221 DBA_EDITIONING_VIEW_COLS
• 4.222 DBA_EDITIONING_VIEW_COLS_AE
• 4.223 DBA_EDITIONING_VIEWS
• 4.224 DBA_EDITIONING_VIEWS_AE
• 4.225 DBA_EDITIONS
• 4.226 DBA_ENABLED_AGGREGATIONS
• 4.227 DBA_ENABLED_TRACES
• 4.228 DBA_ENCRYPTED_COLUMNS
• 4.229 DBA_EPG_DAD_AUTHORIZATION
• 4.230 DBA_ERROR_TRANSLATIONS
• 4.231 DBA_ERRORS
• 4.232 DBA_ERRORS_AE
• 4.233 DBA_EVALUATION_CONTEXT_TABLES
• 4.234 DBA_EVALUATION_CONTEXT_VARS
• 4.235 DBA_EVALUATION_CONTEXTS
• 4.236 DBA_EXP_FILES
• 4.237 DBA_EXP_OBJECTS
• 4.238 DBA_EXP_VERSION
• 4.239 DBA_EXPRESSION_STATISTICS
• 4.240 DBA_EXTENTS
• 4.241 DBA_EXTERNAL_LOCATIONS
• 4.242 DBA_EXTERNAL_SCN_ACTIVITY
• 4.243 DBA_EXTERNAL_TABLES
• 4.244 DBA_FEATURE_USAGE_STATISTICS
• 4.245 DBA_FGA_AUDIT_TRAIL
• 4.246 DBA_FILE_GROUP_EXPORT_INFO
• 4.247 DBA_FILE_GROUP_FILES
• 4.248 DBA_FILE_GROUP_TABLES
• 4.249 DBA_FILE_GROUP_TABLESPACES
• 4.250 DBA_FILE_GROUP_VERSIONS
• 4.251 DBA_FILE_GROUPS
• 4.252 DBA_FLASHBACK_ARCHIVE
• 4.253 DBA_FLASHBACK_ARCHIVE_TABLES
• 4.254 DBA_FLASHBACK_ARCHIVE_TS
• 4.255 DBA_FLASHBACK_TXN_REPORT
• 4.256 DBA_FLASHBACK_TXN_STATE
• 4.257 DBA_FREE_SPACE
• 4.258 DBA_FREE_SPACE_COALESCED
• 4.259 DBA_GG_INBOUND_PROGRESS
• 4.260 DBA_GG_PROC_OBJECT_EXCLUSION
• 4.261 DBA_GG_PROCEDURE_ANNOTATION
• 4.262 DBA_GG_SUPPORTED_PACKAGES
• 4.263 DBA_GG_SUPPORTED_PROCEDURES
• 4.264 DBA_GLOBAL_CONTEXT
• 4.265 DBA_GOLDENGATE_INBOUND
• 4.266 DBA_GOLDENGATE_NOT_UNIQUE
• 4.267 DBA_GOLDENGATE_PRIVILEGES
• 4.268 DBA_GOLDENGATE_RULES
• 4.269 DBA_GOLDENGATE_SUPPORT_MODE
• 4.270 DBA_HANG_MANAGER_PARAMETERS
• 4.271 DBA_HEAT_MAP_SEG_HISTOGRAM
• 4.272 DBA_HEAT_MAP_SEGMENT
• 4.273 DBA_HEATMAP_TOP_OBJECTS
• 4.274 DBA_HEATMAP_TOP_TABLESPACES
• 4.275 DBA_HIER_CLASS
• 4.276 DBA_HIER_COLUMNS
• 4.277 DBA_HIER_HIER_ATTR_CLASS
• 4.278 DBA_HIER_HIER_ATTRIBUTES
• 4.279 DBA_HIER_JOIN_PATHS
• 4.280 DBA_HIER_LEVEL_ID_ATTRS
• 4.281 DBA_HIER_LEVELS
• 4.282 DBA_HIERARCHIES
• 4.283 DBA_HIGH_WATER_MARK_STATISTICS
• 4.284 DBA_HIST_ACTIVE_SESS_HISTORY
• 4.285 DBA_HIST_APPLY_SUMMARY
• 4.286 DBA_HIST_ASH_SNAPSHOT
• 4.287 DBA_HIST_BASELINE
• 4.288 DBA_HIST_BASELINE_DETAILS
• 4.289 DBA_HIST_BASELINE_METADATA
• 4.290 DBA_HIST_BASELINE_TEMPLATE
• 4.291 DBA_HIST_BG_EVENT_SUMMARY
• 4.292 DBA_HIST_BUFFER_POOL_STAT
• 4.293 DBA_HIST_BUFFERED_QUEUES
• 4.294 DBA_HIST_BUFFERED_SUBSCRIBERS
• 4.295 DBA_HIST_CAPTURE
• 4.296 DBA_HIST_CHANNEL_WAITS
• 4.297 DBA_HIST_CLUSTER_INTERCON
• 4.298 DBA_HIST_COLORED_SQL
• 4.299 DBA_HIST_COMP_IOSTAT
• 4.300 DBA_HIST_CON_SYS_TIME_MODEL
• 4.301 DBA_HIST_CON_SYSMETRIC_HIST
• 4.302 DBA_HIST_CON_SYSMETRIC_SUMM
• 4.303 DBA_HIST_CON_SYSSTAT
• 4.304 DBA_HIST_CON_SYSTEM_EVENT
• 4.305 DBA_HIST_CR_BLOCK_SERVER
• 4.306 DBA_HIST_CURRENT_BLOCK_SERVER
• 4.307 DBA_HIST_DATABASE_INSTANCE
• 4.308 DBA_HIST_DATAFILE
• 4.309 DBA_HIST_DB_CACHE_ADVICE
• 4.310 DBA_HIST_DISPATCHER
• 4.311 DBA_HIST_DLM_MISC
• 4.312 DBA_HIST_DYN_REMASTER_STATS
• 4.313 DBA_HIST_ENQUEUE_STAT
• 4.314 DBA_HIST_EVENT_HISTOGRAM
• 4.315 DBA_HIST_EVENT_NAME
• 4.316 DBA_HIST_FILEMETRIC_HISTORY
• 4.317 DBA_HIST_FILESTATXS
• 4.318 DBA_HIST_IC_CLIENT_STATS
• 4.319 DBA_HIST_IC_DEVICE_STATS
• 4.320 DBA_HIST_IM_SEG_STAT
• 4.321 DBA_HIST_IM_SEG_STAT_OBJ
• 4.322 DBA_HIST_INST_CACHE_TRANSFER
• 4.323 DBA_HIST_INSTANCE_RECOVERY
• 4.324 DBA_HIST_INTERCONNECT_PINGS
• 4.325 DBA_HIST_IOSTAT_DETAIL
• 4.326 DBA_HIST_IOSTAT_FILETYPE
• 4.327 DBA_HIST_IOSTAT_FILETYPE_NAME
• 4.328 DBA_HIST_IOSTAT_FUNCTION
• 4.329 DBA_HIST_IOSTAT_FUNCTION_NAME
• 4.330 DBA_HIST_JAVA_POOL_ADVICE

5 Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS

• 5.1 DBA_HIST_LATCH
• 5.2 DBA_HIST_LATCH_CHILDREN
• 5.3 DBA_HIST_LATCH_MISSES_SUMMARY
• 5.4 DBA_HIST_LATCH_NAME
• 5.5 DBA_HIST_LATCH_PARENT
• 5.6 DBA_HIST_LIBRARYCACHE
• 5.7 DBA_HIST_LOG
• 5.8 DBA_HIST_MEM_DYNAMIC_COMP
• 5.9 DBA_HIST_MEMORY_RESIZE_OPS
• 5.10 DBA_HIST_MEMORY_TARGET_ADVICE
• 5.11 DBA_HIST_METRIC_NAME
• 5.12 DBA_HIST_MTTR_TARGET_ADVICE
• 5.13 DBA_HIST_MUTEX_SLEEP
• 5.14 DBA_HIST_OPTIMIZER_ENV
• 5.15 DBA_HIST_OSSTAT
• 5.16 DBA_HIST_OSSTAT_NAME
• 5.17 DBA_HIST_PARAMETER
• 5.18 DBA_HIST_PARAMETER_NAME
• 5.19 DBA_HIST_PDB_IN_SNAP
• 5.20 DBA_HIST_PDB_INSTANCE
• 5.21 DBA_HIST_PERSISTENT_QMN_CACHE
• 5.22 DBA_HIST_PERSISTENT_QUEUES
• 5.23 DBA_HIST_PERSISTENT_SUBS
• 5.24 DBA_HIST_PGA_TARGET_ADVICE
• 5.25 DBA_HIST_PGASTAT
• 5.26 DBA_HIST_PLAN_OPERATION_NAME
• 5.27 DBA_HIST_PLAN_OPTION_NAME
• 5.28 DBA_HIST_PROCESS_MEM_SUMMARY
• 5.29 DBA_HIST_RECOVERY_PROGRESS
• 5.30 DBA_HIST_REPLICATION_TBL_STATS
• 5.31 DBA_HIST_REPLICATION_TXN_STATS
• 5.32 DBA_HIST_REPORTS
• 5.33 DBA_HIST_REPORTS_CONTROL
• 5.34 DBA_HIST_REPORTS_DETAILS
• 5.35 DBA_HIST_REPORTS_TIMEBANDS
• 5.36 DBA_HIST_RESOURCE_LIMIT
• 5.37 DBA_HIST_ROWCACHE_SUMMARY
• 5.38 DBA_HIST_RSRC_CONSUMER_GROUP
• 5.39 DBA_HIST_RSRC_METRIC
• 5.40 DBA_HIST_RSRC_PDB_METRIC
• 5.41 DBA_HIST_RSRC_PLAN
• 5.42 DBA_HIST_RULE_SET
• 5.43 DBA_HIST_SEG_STAT
• 5.44 DBA_HIST_SEG_STAT_OBJ
• 5.45 DBA_HIST_SERVICE_NAME
• 5.46 DBA_HIST_SERVICE_STAT
• 5.47 DBA_HIST_SERVICE_WAIT_CLASS
• 5.48 DBA_HIST_SESS_SGA_STATS
• 5.49 DBA_HIST_SESS_TIME_STATS
• 5.50 DBA_HIST_SESSMETRIC_HISTORY
• 5.51 DBA_HIST_SGA
• 5.52 DBA_HIST_SGA_TARGET_ADVICE
• 5.53 DBA_HIST_SGASTAT
• 5.54 DBA_HIST_SHARED_POOL_ADVICE
• 5.55 DBA_HIST_SHARED_SERVER_SUMMARY
• 5.56 DBA_HIST_SNAP_ERROR
• 5.57 DBA_HIST_SNAPSHOT
• 5.58 DBA_HIST_SQL_BIND_METADATA
• 5.59 DBA_HIST_SQL_PLAN
• 5.60 DBA_HIST_SQL_SUMMARY
• 5.61 DBA_HIST_SQL_WORKAREA_HSTGRM
• 5.62 DBA_HIST_SQLBIND
• 5.63 DBA_HIST_SQLCOMMAND_NAME
• 5.64 DBA_HIST_SQLSTAT
• 5.65 DBA_HIST_SQLTEXT
• 5.66 DBA_HIST_STAT_NAME
• 5.67 DBA_HIST_STREAMS_APPLY_SUM
• 5.68 DBA_HIST_STREAMS_CAPTURE
• 5.69 DBA_HIST_STREAMS_POOL_ADVICE
• 5.70 DBA_HIST_SYS_TIME_MODEL
• 5.71 DBA_HIST_SYSMETRIC_HISTORY
• 5.72 DBA_HIST_SYSMETRIC_SUMMARY
• 5.73 DBA_HIST_SYSSTAT
• 5.74 DBA_HIST_SYSTEM_EVENT
• 5.75 DBA_HIST_TABLESPACE
• 5.76 DBA_HIST_TABLESPACE_STAT
• 5.77 DBA_HIST_TBSPC_SPACE_USAGE
• 5.78 DBA_HIST_TEMPFILE
• 5.79 DBA_HIST_TEMPSTATXS
• 5.80 DBA_HIST_THREAD
• 5.81 DBA_HIST_TOPLEVELCALL_NAME
• 5.82 DBA_HIST_UNDOSTAT
• 5.83 DBA_HIST_WAITCLASSMET_HISTORY
• 5.84 DBA_HIST_WAITSTAT
• 5.85 DBA_HIST_WR_CONTROL
• 5.86 DBA_HIST_WR_SETTINGS
• 5.87 DBA_HISTOGRAMS
• 5.88 DBA_HIVE_COLUMNS
• 5.89 DBA_HIVE_DATABASES
• 5.90 DBA_HIVE_PART_KEY_COLUMNS
• 5.91 DBA_HIVE_TAB_PARTITIONS
• 5.92 DBA_HIVE_TABLES
• 5.93 DBA_HOST_ACES
• 5.94 DBA_HOST_ACLS
• 5.95 DBA_IDENTIFIERS
• 5.96 DBA_ILMDATAMOVEMENTPOLICIES
• 5.97 DBA_ILMEVALUATIONDETAILS
• 5.98 DBA_ILMOBJECTS
• 5.99 DBA_ILMPARAMETERS
• 5.100 DBA_ILMPOLICIES
• 5.101 DBA_ILMRESULTS
• 5.102 DBA_ILMTASKS
• 5.103 DBA_IM_EXPRESSIONS
• 5.104 DBA_IND_COLUMNS
• 5.105 DBA_IND_EXPRESSIONS
• 5.106 DBA_IND_PARTITIONS
• 5.107 DBA_IND_PENDING_STATS
• 5.108 DBA_IND_STATISTICS
• 5.109 DBA_IND_SUBPARTITIONS
• 5.110 DBA_INDEX_USAGE
• 5.111 DBA_INDEXES
• 5.112 DBA_INDEXTYPE_ARRAYTYPES
• 5.113 DBA_INDEXTYPE_COMMENTS
• 5.114 DBA_INDEXTYPE_OPERATORS
• 5.115 DBA_INDEXTYPES
• 5.116 DBA_INTERNAL_TRIGGERS
• 5.117 DBA_INVALID_OBJECTS
• 5.118 DBA_JAVA_ARGUMENTS
• 5.119 DBA_JAVA_CLASSES
• 5.120 DBA_JAVA_COMPILER_OPTIONS
• 5.121 DBA_JAVA_DERIVATIONS
• 5.122 DBA_JAVA_FIELDS
• 5.123 DBA_JAVA_IMPLEMENTS
• 5.124 DBA_JAVA_INNERS
• 5.125 DBA_JAVA_LAYOUTS
• 5.126 DBA_JAVA_METHODS
• 5.127 DBA_JAVA_NCOMPS
• 5.128 DBA_JAVA_POLICY
• 5.129 DBA_JAVA_RESOLVERS
• 5.130 DBA_JAVA_THROWS
• 5.131 DBA_JOBS
• 5.132 DBA_JOBS_RUNNING
• 5.133 DBA_JOIN_IND_COLUMNS
• 5.134 DBA_JOINGROUPS
• 5.135 DBA_JSON_COLUMNS
• 5.136 DBA_JSON_DATAGUIDES
• 5.137 DBA_KGLLOCK
• 5.138 DBA_LIBRARIES
• 5.139 DBA_LMT_FREE_SPACE
• 5.140 DBA_LMT_USED_EXTENTS
• 5.141 DBA_LOB_PARTITIONS
• 5.142 DBA_LOB_SUBPARTITIONS
• 5.143 DBA_LOB_TEMPLATES
• 5.144 DBA_LOBS
• 5.145 DBA_LOCK
• 5.146 DBA_LOCK_INTERNAL
• 5.147 DBA_LOCKDOWN_PROFILES
• 5.148 DBA_LOCKS
• 5.149 DBA_LOG_GROUP_COLUMNS
• 5.150 DBA_LOG_GROUPS
• 5.151 DBA_LOGMNR_LOG
• 5.152 DBA_LOGMNR_PURGED_LOG
• 5.153 DBA_LOGMNR_SESSION
• 5.154 DBA_LOGSTDBY_EDS_SUPPORTED
• 5.155 DBA_LOGSTDBY_EDS_TABLES
• 5.156 DBA_LOGSTDBY_EVENTS
• 5.157 DBA_LOGSTDBY_HISTORY
• 5.158 DBA_LOGSTDBY_LOG
• 5.159 DBA_LOGSTDBY_NOT_UNIQUE
• 5.160 DBA_LOGSTDBY_PARAMETERS
• 5.161 DBA_LOGSTDBY_PLSQL_MAP
• 5.162 DBA_LOGSTDBY_PLSQL_SUPPORT
• 5.163 DBA_LOGSTDBY_PROGRESS
• 5.164 DBA_LOGSTDBY_SKIP
• 5.165 DBA_LOGSTDBY_SKIP_TRANSACTION
• 5.166 DBA_LOGSTDBY_UNSUPPORTED
• 5.167 DBA_LOGSTDBY_UNSUPPORTED_TABLE
• 5.168 DBA_MEASURE_FOLDER_CONTENTS
• 5.169 DBA_MEASURE_FOLDER_SUBFOLDERS
• 5.170 DBA_MEASURE_FOLDERS
• 5.171 DBA_METADATA_PROPERTIES
• 5.172 DBA_METHOD_PARAMS
• 5.173 DBA_METHOD_RESULTS
• 5.174 DBA_MINING_MODEL_ATTRIBUTES
• 5.175 DBA_MINING_MODEL_PARTITIONS
• 5.176 DBA_MINING_MODEL_SETTINGS
• 5.177 DBA_MINING_MODEL_TABLES
• 5.178 DBA_MINING_MODEL_VIEWS
• 5.179 DBA_MINING_MODEL_XFORMS
• 5.180 DBA_MINING_MODELS
• 5.181 DBA_MVIEW_AGGREGATES
• 5.182 DBA_MVIEW_ANALYSIS
• 5.183 DBA_MVIEW_COMMENTS
• 5.184 DBA_MVIEW_DETAIL_PARTITION
• 5.185 DBA_MVIEW_DETAIL_RELATIONS
• 5.186 DBA_MVIEW_DETAIL_SUBPARTITION
• 5.187 DBA_MVIEW_JOINS
• 5.188 DBA_MVIEW_KEYS
• 5.189 DBA_MVIEW_LOG_FILTER_COLS
• 5.190 DBA_MVIEW_LOGS
• 5.191 DBA_MVIEW_REFRESH_TIMES
• 5.192 DBA_MVIEWS
• 5.193 DBA_MVREF_CHANGE_STATS
• 5.194 DBA_MVREF_RUN_STATS
• 5.195 DBA_MVREF_STATS
• 5.196 DBA_MVREF_STATS_PARAMS
• 5.197 DBA_MVREF_STATS_SYS_DEFAULTS
• 5.198 DBA_MVREF_STMT_STATS
• 5.199 DBA_NESTED_TABLE_COLS
• 5.200 DBA_NESTED_TABLES
• 5.201 DBA_NETWORK_ACL_PRIVILEGES
• 5.202 DBA_NETWORK_ACLS
• 5.203 DBA_OBJ_AUDIT_OPTS
• 5.204 DBA_OBJ_COLATTRS
• 5.205 DBA_OBJECT_SIZE
• 5.206 DBA_OBJECT_TABLES
• 5.207 DBA_OBJECT_USAGE
• 5.208 DBA_OBJECTS
• 5.209 DBA_OBJECTS_AE
• 5.210 DBA_OPANCILLARY
• 5.211 DBA_OPARGUMENTS
• 5.212 DBA_OPBINDINGS
• 5.213 DBA_OPERATOR_COMMENTS
• 5.214 DBA_OPERATORS
• 5.215 DBA_OPTSTAT_OPERATION_TASKS
• 5.216 DBA_OPTSTAT_OPERATIONS
• 5.217 DBA_ORPHAN_KEY_TABLE
• 5.218 DBA_OUTLINE_HINTS
• 5.219 DBA_OUTLINES
• 5.220 DBA_OUTSTANDING_ALERTS
• 5.221 DBA_PARALLEL_EXECUTE_CHUNKS
• 5.222 DBA_PARALLEL_EXECUTE_TASKS
• 5.223 DBA_PART_COL_STATISTICS
• 5.224 DBA_PART_HISTOGRAMS
• 5.225 DBA_PART_INDEXES
• 5.226 DBA_PART_KEY_COLUMNS
• 5.227 DBA_PART_LOBS
• 5.228 DBA_PART_TABLES
• 5.229 DBA_PARTIAL_DROP_TABS
• 5.230 DBA_PDB_HISTORY
• 5.231 DBA_PDB_SAVED_STATES
• 5.232 DBA_PDBS
• 5.233 DBA_PENDING_CONV_TABLES
• 5.234 DBA_PENDING_TRANSACTIONS
• 5.235 DBA_PLSQL_COLL_TYPES
• 5.236 DBA_PLSQL_OBJECT_SETTINGS
• 5.237 DBA_PLSQL_TYPE_ATTRS
• 5.238 DBA_PLSQL_TYPES
• 5.239 DBA_POLICIES
• 5.240 DBA_POLICY_ATTRIBUTES
• 5.241 DBA_POLICY_CONTEXTS
• 5.242 DBA_POLICY_GROUPS
• 5.243 DBA_PRIV_AUDIT_OPTS
• 5.244 DBA_PRIV_CAPTURES
• 5.245 DBA_PROCEDURES
• 5.246 DBA_PROFILES
• 5.247 DBA_PROPAGATION
• 5.248 DBA_PROXIES
• 5.249 DBA_QUEUE_SCHEDULES
• 5.250 DBA_QUEUE_SUBSCRIBERS
• 5.251 DBA_QUEUE_TABLES
• 5.252 DBA_QUEUES
• 5.253 DBA_RCHILD
• 5.254 DBA_RECOVERABLE_SCRIPT
• 5.255 DBA_RECOVERABLE_SCRIPT_BLOCKS
• 5.256 DBA_RECOVERABLE_SCRIPT_ERRORS
• 5.257 DBA_RECOVERABLE_SCRIPT_HIST
• 5.258 DBA_RECOVERABLE_SCRIPT_PARAMS
• 5.259 DBA_RECYCLEBIN
• 5.260 DBA_REDEFINITION_ERRORS
• 5.261 DBA_REDEFINITION_OBJECTS
• 5.262 DBA_REDEFINITION_STATUS
• 5.263 DBA_REFRESH
• 5.264 DBA_REFRESH_CHILDREN
• 5.265 DBA_REFS
• 5.266 DBA_REGISTERED_ARCHIVED_LOG
• 5.267 DBA_REGISTERED_MVIEWS
• 5.268 DBA_REGISTRY
• 5.269 DBA_REGISTRY_HIERARCHY
• 5.270 DBA_REGISTRY_HISTORY
• 5.271 DBA_REGISTRY_LOG
• 5.272 DBA_REGISTRY_SCHEMAS
• 5.273 DBA_REGISTRY_SQLPATCH
• 5.274 DBA_REPAIR_TABLE
• 5.275 DBA_REPL_DBNAME_MAPPING
• 5.276 DBA_REPLICATION_PROCESS_EVENTS
• 5.277 DBA_RESOURCE_INCARNATIONS
• 5.278 DBA_RESUMABLE
• 5.279 DBA_REWRITE_EQUIVALENCES
• 5.280 DBA_RGROUP
• 5.281 DBA_ROLE_PRIVS
• 5.282 DBA_ROLES
• 5.283 DBA_ROLLBACK_SEGS
• 5.284 DBA_ROLLING_DATABASES
• 5.285 DBA_ROLLING_EVENTS
• 5.286 DBA_ROLLING_PARAMETERS
• 5.287 DBA_ROLLING_PLAN
• 5.288 DBA_ROLLING_STATISTICS
• 5.289 DBA_ROLLING_STATUS
• 5.290 DBA_ROLLING_UNSUPPORTED
• 5.291 DBA_RSRC_CATEGORIES
• 5.292 DBA_RSRC_CONSUMER_GROUP_PRIVS
• 5.293 DBA_RSRC_CONSUMER_GROUPS
• 5.294 DBA_RSRC_GROUP_MAPPINGS
• 5.295 DBA_RSRC_IO_CALIBRATE
• 5.296 DBA_RSRC_MANAGER_SYSTEM_PRIVS
• 5.297 DBA_RSRC_MAPPING_PRIORITY
• 5.298 DBA_RSRC_PLAN_DIRECTIVES
• 5.299 DBA_RSRC_PLANS
• 5.300 DBA_RULE_SET_RULES
• 5.301 DBA_RULE_SETS
• 5.302 DBA_RULES
• 5.303 DBA_SCHEDULER_CHAIN_RULES
• 5.304 DBA_SCHEDULER_CHAIN_STEPS
• 5.305 DBA_SCHEDULER_CHAINS
• 5.306 DBA_SCHEDULER_CREDENTIALS
• 5.307 DBA_SCHEDULER_DB_DESTS
• 5.308 DBA_SCHEDULER_DESTS
• 5.309 DBA_SCHEDULER_EXTERNAL_DESTS
• 5.310 DBA_SCHEDULER_FILE_WATCHERS
• 5.311 DBA_SCHEDULER_GLOBAL_ATTRIBUTE
• 5.312 DBA_SCHEDULER_GROUP_MEMBERS
• 5.313 DBA_SCHEDULER_GROUPS
• 5.314 DBA_SCHEDULER_INCOMPAT_MEMBER
• 5.315 DBA_SCHEDULER_INCOMPATS
• 5.316 DBA_SCHEDULER_JOB_ARGS
• 5.317 DBA_SCHEDULER_JOB_CLASSES
• 5.318 DBA_SCHEDULER_JOB_DESTS
• 5.319 DBA_SCHEDULER_JOB_LOG
• 5.320 DBA_SCHEDULER_JOB_ROLES
• 5.321 DBA_SCHEDULER_JOB_RUN_DETAILS
• 5.322 DBA_SCHEDULER_JOBS
• 5.323 DBA_SCHEDULER_NOTIFICATIONS
• 5.324 DBA_SCHEDULER_PROGRAM_ARGS
• 5.325 DBA_SCHEDULER_PROGRAMS
• 5.326 DBA_SCHEDULER_REMOTE_DATABASES
• 5.327 DBA_SCHEDULER_REMOTE_JOBSTATE
• 5.328 DBA_SCHEDULER_RESOURCES
• 5.329 DBA_SCHEDULER_RSC_CONSTRAINTS
• 5.330 DBA_SCHEDULER_RUNNING_CHAINS
• 5.331 DBA_SCHEDULER_RUNNING_JOBS
• 5.332 DBA_SCHEDULER_SCHEDULES
• 5.333 DBA_SCHEDULER_WINDOW_DETAILS
• 5.334 DBA_SCHEDULER_WINDOW_GROUPS
• 5.335 DBA_SCHEDULER_WINDOW_LOG
• 5.336 DBA_SCHEDULER_WINDOWS
• 5.337 DBA_SCHEDULER_WINGROUP_MEMBERS
• 5.338 DBA_SEC_RELEVANT_COLS
• 5.339 DBA_SECONDARY_OBJECTS
• 5.340 DBA_SEGMENTS
• 5.341 DBA_SEGMENTS_OLD
• 5.342 DBA_SENSITIVE_COLUMN_TYPES
• 5.343 DBA_SENSITIVE_DATA
• 5.344 DBA_SEQUENCES
• 5.345 DBA_SERVER_REGISTRY
• 5.346 DBA_SERVICES
• 5.347 DBA_SOURCE
• 5.348 DBA_SOURCE_AE
• 5.349 DBA_SQL_MANAGEMENT_CONFIG
• 5.350 DBA_SQL_PATCHES
• 5.351 DBA_SQL_PLAN_BASELINES
• 5.352 DBA_SQL_PLAN_DIR_OBJECTS
• 5.353 DBA_SQL_PLAN_DIRECTIVES
• 5.354 DBA_SQL_PROFILES
• 5.355 DBA_SQL_TRANSLATION_PROFILES
• 5.356 DBA_SQL_TRANSLATIONS
• 5.357 DBA_SQLJ_TYPE_ATTRS
• 5.358 DBA_SQLJ_TYPE_METHODS
• 5.359 DBA_SQLJ_TYPES
• 5.360 DBA_SQLSET
• 5.361 DBA_SQLSET_BINDS
• 5.362 DBA_SQLSET_PLANS
• 5.363 DBA_SQLSET_REFERENCES
• 5.364 DBA_SQLSET_STATEMENTS
• 5.365 DBA_SQLTUNE_BINDS
• 5.366 DBA_SQLTUNE_PLANS
• 5.367 DBA_SQLTUNE_RATIONALE_PLAN
• 5.368 DBA_SQLTUNE_STATISTICS
• 5.369 DBA_SR_GRP_STATUS
• 5.370 DBA_SR_GRP_STATUS_ALL
• 5.371 DBA_SR_OBJ
• 5.372 DBA_SR_OBJ_ALL
• 5.373 DBA_SR_OBJ_STATUS
• 5.374 DBA_SR_OBJ_STATUS_ALL
• 5.375 DBA_SR_PARTN_OPS
• 5.376 DBA_SR_STLOG_EXCEPTIONS
• 5.377 DBA_SR_STLOG_STATS
• 5.378 DBA_SSCR_CAPTURE
• 5.379 DBA_SSCR_RESTORE
• 5.380 DBA_STAT_EXTENSIONS
• 5.381 DBA_STATEMENTS
• 5.382 DBA_STMT_AUDIT_OPTS
• 5.383 DBA_STORED_SETTINGS

6 Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS

• 6.1 DBA_STREAMS_ADD_COLUMN
• 6.2 DBA_STREAMS_ADMINISTRATOR
• 6.3 DBA_STREAMS_COLUMNS
• 6.4 DBA_STREAMS_DELETE_COLUMN
• 6.5 DBA_STREAMS_GLOBAL_RULES
• 6.6 DBA_STREAMS_KEEP_COLUMNS
• 6.7 DBA_STREAMS_MESSAGE_CONSUMERS
• 6.8 DBA_STREAMS_MESSAGE_RULES
• 6.9 DBA_STREAMS_NEWLY_SUPPORTED
• 6.10 DBA_STREAMS_RENAME_COLUMN
• 6.11 DBA_STREAMS_RENAME_SCHEMA
• 6.12 DBA_STREAMS_RENAME_TABLE
• 6.13 DBA_STREAMS_RULES
• 6.14 DBA_STREAMS_SCHEMA_RULES
• 6.15 DBA_STREAMS_SPLIT_MERGE
• 6.16 DBA_STREAMS_SPLIT_MERGE_HIST
• 6.17 DBA_STREAMS_STMT_HANDLERS
• 6.18 DBA_STREAMS_STMTS
• 6.19 DBA_STREAMS_TABLE_RULES
• 6.20 DBA_STREAMS_TP_COMPONENT
• 6.21 DBA_STREAMS_TP_COMPONENT_LINK
• 6.22 DBA_STREAMS_TP_COMPONENT_STAT
• 6.23 DBA_STREAMS_TP_DATABASE
• 6.24 DBA_STREAMS_TP_PATH_BOTTLENECK
• 6.25 DBA_STREAMS_TP_PATH_STAT
• 6.26 DBA_STREAMS_TRANSFORM_FUNCTION
• 6.27 DBA_STREAMS_TRANSFORMATIONS
• 6.28 DBA_STREAMS_UNSUPPORTED
• 6.29 DBA_SUBPART_COL_STATISTICS
• 6.30 DBA_SUBPART_HISTOGRAMS
• 6.31 DBA_SUBPART_KEY_COLUMNS
• 6.32 DBA_SUBPARTITION_TEMPLATES
• 6.33 DBA_SUBSCR_REGISTRATIONS
• 6.34 DBA_SUPPLEMENTAL_LOGGING
• 6.35 DBA_SYNC_CAPTURE
• 6.36 DBA_SYNC_CAPTURE_PREPARED_TABS
• 6.37 DBA_SYNC_CAPTURE_TABLES
• 6.38 DBA_SYNONYMS
• 6.39 DBA_SYS_PRIVS
• 6.40 DBA_TAB_COL_STATISTICS
• 6.41 DBA_TAB_COLS
• 6.42 DBA_TAB_COLUMNS
• 6.43 DBA_TAB_COMMENTS
• 6.44 DBA_TAB_HISTGRM_PENDING_STATS
• 6.45 DBA_TAB_HISTOGRAMS
• 6.46 DBA_TAB_IDENTITY_COLS
• 6.47 DBA_TAB_MODIFICATIONS
• 6.48 DBA_TAB_PARTITIONS
• 6.49 DBA_TAB_PENDING_STATS
• 6.50 DBA_TAB_PRIVS
• 6.51 DBA_TAB_STATISTICS
• 6.52 DBA_TAB_STAT_PREFS
• 6.53 DBA_TAB_STATS_HISTORY
• 6.54 DBA_TAB_SUBPARTITIONS
• 6.55 DBA_TABLES
• 6.56 DBA_TABLESPACE_GROUPS
• 6.57 DBA_TABLESPACE_THRESHOLDS
• 6.58 DBA_TABLESPACE_USAGE_METRICS
• 6.59 DBA_TABLESPACES
• 6.60 DBA_TEMP_FILES
• 6.61 DBA_TEMP_FREE_SPACE
• 6.62 DBA_THRESHOLDS
• 6.63 DBA_TRANSFORMATIONS
• 6.64 DBA_TRIGGER_COLS
• 6.65 DBA_TRIGGER_ORDERING
• 6.66 DBA_TRIGGERS
• 6.67 DBA_TS_QUOTAS
• 6.68 DBA_TSDP_IMPORT_ERRORS
• 6.69 DBA_TSDP_POLICY_CONDITION
• 6.70 DBA_TSDP_POLICY_FEATURE
• 6.71 DBA_TSDP_POLICY_PARAMETER
• 6.72 DBA_TSDP_POLICY_PROTECTION
• 6.73 DBA_TSDP_POLICY_TYPE
• 6.74 DBA_TSM_DESTINATION
• 6.75 DBA_TSM_SOURCE
• 6.76 DBA_TSTZ_TAB_COLS
• 6.77 DBA_TSTZ_TABLES
• 6.78 DBA_TUNE_MVIEW
• 6.79 DBA_TYPE_ATTRS
• 6.80 DBA_TYPE_METHODS
• 6.81 DBA_TYPE_VERSIONS
• 6.82 DBA_TYPES
• 6.83 DBA_UMF_LINK
• 6.84 DBA_UMF_REGISTRATION
• 6.85 DBA_UMF_SERVICE
• 6.86 DBA_UMF_TOPOLOGY
• 6.87 DBA_UNDO_EXTENTS
• 6.88 DBA_UNUSED_COL_TABS
• 6.89 DBA_UNUSED_GRANTS
• 6.90 DBA_UNUSED_OBJPRIVS
• 6.91 DBA_UNUSED_OBJPRIVS_PATH
• 6.92 DBA_UNUSED_PRIVS
• 6.93 DBA_UNUSED_SYSPRIVS
• 6.94 DBA_UNUSED_SYSPRIVS_PATH
• 6.95 DBA_UNUSED_USERPRIVS
• 6.96 DBA_UNUSED_USERPRIVS_PATH
• 6.97 DBA_UPDATABLE_COLUMNS
• 6.98 DBA_USED_OBJPRIVS
• 6.99 DBA_USED_OBJPRIVS_PATH
• 6.100 DBA_USED_PRIVS
• 6.101 DBA_USED_PUBPRIVS
• 6.102 DBA_USED_SYSPRIVS
• 6.103 DBA_USED_SYSPRIVS_PATH
• 6.104 DBA_USED_USERPRIVS
• 6.105 DBA_USED_USERPRIVS_PATH
• 6.106 DBA_USERS
• 6.107 DBA_USERS_WITH_DEFPWD
• 6.108 DBA_USTATS
• 6.109 DBA_VARRAYS
• 6.110 DBA_VIEWS
• 6.111 DBA_VIEWS_AE
• 6.112 DBA_WAITERS
• 6.113 DBA_WALLET_ACES
• 6.114 DBA_WALLET_ACLS
• 6.115 DBA_WARNING_SETTINGS
• 6.116 DBA_WI_CAPTURE_FILES
• 6.117 DBA_WI_JOBS
• 6.118 DBA_WI_OBJECTS
• 6.119 DBA_WI_PATTERN_ITEMS
• 6.120 DBA_WI_PATTERNS
• 6.121 DBA_WI_STATEMENTS
• 6.122 DBA_WI_TEMPLATE_EXECUTIONS
• 6.123 DBA_WI_TEMPLATES
• 6.124 DBA_WORKLOAD_ACTIVE_USER_MAP
• 6.125 DBA_WORKLOAD_CAPTURES
• 6.126 DBA_WORKLOAD_CONNECTION_MAP
• 6.127 DBA_WORKLOAD_FILTERS
• 6.128 DBA_WORKLOAD_GROUP_ASSIGNMENTS
• 6.129 DBA_WORKLOAD_REPLAY_CLIENTS
• 6.130 DBA_WORKLOAD_REPLAY_DIVERGENCE
• 6.131 DBA_WORKLOAD_REPLAY_SCHEDULES
• 6.132 DBA_WORKLOAD_REPLAYS
• 6.133 DBA_WORKLOAD_SCHEDULE_CAPTURES
• 6.134 DBA_WORKLOAD_SCHEDULE_ORDERING
• 6.135 DBA_WORKLOAD_SQL_MAP
• 6.136 DBA_WORKLOAD_TRACKED_COMMITS
• 6.137 DBA_WORKLOAD_USER_MAP
• 6.138 DBA_XML_INDEXES
• 6.139 DBA_XML_NESTED_TABLES
• 6.140 DBA_XML_OUT_OF_LINE_TABLES
• 6.141 DBA_XML_SCHEMA_ATTRIBUTES
• 6.142 DBA_XML_SCHEMA_COMPLEX_TYPES
• 6.143 DBA_XML_SCHEMA_ELEMENTS
• 6.144 DBA_XML_SCHEMA_NAMESPACES
• 6.145 DBA_XML_SCHEMA_SIMPLE_TYPES
• 6.146 DBA_XML_SCHEMA_SUBSTGRP_HEAD
• 6.147 DBA_XML_SCHEMA_SUBSTGRP_MBRS
• 6.148 DBA_XML_SCHEMAS
• 6.149 DBA_XML_TAB_COLS
• 6.150 DBA_XML_TABLES
• 6.151 DBA_XML_VIEW_COLS
• 6.152 DBA_XML_VIEWS
• 6.153 DBA_XS_AUDIT_POLICY_OPTIONS
• 6.154 DBA_XS_AUDIT_TRAIL
• 6.155 DBA_XS_ENABLED_AUDIT_POLICIES
• 6.156 DBA_XS_ENB_AUDIT_POLICIES
• 6.157 DBA_XSTREAM_ADMINISTRATOR
• 6.158 DBA_XSTREAM_INBOUND
• 6.159 DBA_XSTREAM_INBOUND_PROGRESS
• 6.160 DBA_XSTREAM_OUT_SUPPORT_MODE
• 6.161 DBA_XSTREAM_OUTBOUND
• 6.162 DBA_XSTREAM_OUTBOUND_PROGRESS
• 6.163 DBA_XSTREAM_RULES
• 6.164 DBA_XSTREAM_SPLIT_MERGE
• 6.165 DBA_XSTREAM_SPLIT_MERGE_HIST
• 6.166 DBA_XSTREAM_STMT_HANDLERS
• 6.167 DBA_XSTREAM_STMTS
• 6.168 DBA_XSTREAM_TRANSFORMATIONS
• 6.169 DBA_XTERNAL_LOC_PARTITIONS
• 6.170 DBA_XTERNAL_LOC_SUBPARTITIONS
• 6.171 DBA_XTERNAL_PART_TABLES
• 6.172 DBA_XTERNAL_TAB_PARTITIONS
• 6.173 DBA_XTERNAL_TAB_SUBPARTITIONS
• 6.174 DBA_ZONEMAP_MEASURES
• 6.175 DBA_ZONEMAPS
• 6.176 DBFS_CONTENT
• 6.177 DBFS_CONTENT_PROPERTIES
• 6.178 DBMS_ALERT_INFO
• 6.179 DBMS_LOCK_ALLOCATED
• 6.180 DBMS_METADATA_PARSE_ITEMS
• 6.181 DBMS_METADATA_TRANSFORM_PARAMS
• 6.182 DBMS_METADATA_TRANSFORMS
• 6.183 DEPTREE
• 6.184 DICT
• 6.185 DICT_COLUMNS
• 6.186 DICTIONARY
• 6.187 DM_USER_MODELS
• 6.188 DOCUMENT_LINKS
• 6.189 ERROR_SIZE
• 6.190 EXCEPTIONS
• 6.191 FLASHBACK_TRANSACTION_QUERY
• 6.192 GLOBAL_CONTEXT
• 6.193 GLOBAL_NAME
• 6.194 HS_ALL_CAPS
• 6.195 HS_ALL_DD
• 6.196 HS_ALL_INITS
• 6.197 HS_BASE_CAPS
• 6.198 HS_BASE_DD
• 6.199 HS_CLASS_CAPS
• 6.200 HS_CLASS_DD
• 6.201 HS_CLASS_INIT
• 6.202 HS_FDS_CLASS
• 6.203 HS_FDS_INST
• 6.204 HS_INST_CAPS
• 6.205 HS_INST_DD
• 6.206 HS_INST_INIT
• 6.207 IDEPTREE
• 6.208 IND
• 6.209 INDEX_HISTOGRAM
• 6.210 INDEX_STATS
• 6.211 LOGSTDBY_UNSUPPORTED_TABLES
• 6.212 MAP_OBJECT
• 6.213 NLS_DATABASE_PARAMETERS
• 6.214 NLS_INSTANCE_PARAMETERS
• 6.215 NLS_SESSION_PARAMETERS
• 6.216 OBJ
• 6.217 PATH_VIEW
• 6.218 PDB_ALERTS
• 6.219 PDB_PLUG_IN_VIOLATIONS
• 6.220 PLAN_TABLE
• 6.221 PLUGGABLE_SET_CHECK
• 6.222 PRODUCT_COMPONENT_VERSION
• 6.223 PROXY_USERS
• 6.224 PSTUBTBL
• 6.225 PUBLIC_DEPENDENCY
• 6.226 PUBLICSYN
• 6.227 QUEUE_PRIVILEGES
• 6.228 RECYCLEBIN
• 6.229 REDACTION_COLUMNS
• 6.230 REDACTION_EXPRESSIONS
• 6.231 REDACTION_POLICIES
• 6.232 REDACTION_VALUES_FOR_TYPE_FULL
• 6.233 REPORT_COMPONENTS
• 6.234 REPORT_FILES
• 6.235 REPORT_FORMATS
• 6.236 RESOURCE_COST
• 6.237 RESOURCE_MAP
• 6.238 RESOURCE_VIEW
• 6.239 ROLE_ROLE_PRIVS
• 6.240 ROLE_SYS_PRIVS
• 6.241 ROLE_TAB_PRIVS
• 6.242 SCHEDULER_BATCH_ERRORS
• 6.243 SCHEMA_EXPORT_OBJECTS
• 6.244 SEQ
• 6.245 SESSION_CONTEXT
• 6.246 SESSION_PRIVS
• 6.247 SESSION_ROLES
• 6.248 SOURCE_SIZE
• 6.249 STMT_AUDIT_OPTION_MAP
• 6.250 SYN
• 6.251 SYNONYMS
• 6.252 SYS_OBJECTS
• 6.253 SYSCATALOG
• 6.254 SYSFILES
• 6.255 SYSSEGOBJ
• 6.256 SYSTEM_PRIVILEGE_MAP
• 6.257 TAB
• 6.258 TABLE_EXPORT_OBJECTS
• 6.259 TABLE_PRIVILEGE_MAP
• 6.260 TABQUOTAS
• 6.261 TABS
• 6.262 TRUSTED_SERVERS
• 6.263 TS_PITR_CHECK
• 6.264 TS_PITR_OBJECTS_TO_BE_DROPPED
• 6.265 UNI_PLUGGABLE_SET_CHECK
• 6.266 UNIFIED_AUDIT_TRAIL
• 6.267 USABLE_EDITIONS
• 6.268 USER_ADDM_FDG_BREAKDOWN
• 6.269 USER_ADDM_FINDINGS
• 6.270 USER_ADDM_INSTANCES
• 6.271 USER_ADDM_TASK_DIRECTIVES
• 6.272 USER_ADDM_TASKS
• 6.273 USER_ADVISOR_ACTIONS
• 6.274 USER_ADVISOR_DIR_TASK_INST
• 6.275 USER_ADVISOR_EXEC_PARAMETERS
• 6.276 USER_ADVISOR_EXECUTIONS
• 6.277 USER_ADVISOR_FDG_BREAKDOWN
• 6.278 USER_ADVISOR_FINDINGS
• 6.279 USER_ADVISOR_JOURNAL
• 6.280 USER_ADVISOR_LOG
• 6.281 USER_ADVISOR_OBJECTS
• 6.282 USER_ADVISOR_PARAMETERS
• 6.283 USER_ADVISOR_RATIONALE
• 6.284 USER_ADVISOR_RECOMMENDATIONS
• 6.285 USER_ADVISOR_SQLA_REC_SUM
• 6.286 USER_ADVISOR_SQLA_TABLES
• 6.287 USER_ADVISOR_SQLA_WK_MAP
• 6.288 USER_ADVISOR_SQLA_WK_STMTS
• 6.289 USER_ADVISOR_SQLPLANS
• 6.290 USER_ADVISOR_SQLSTATS
• 6.291 USER_ADVISOR_SQLW_JOURNAL
• 6.292 USER_ADVISOR_SQLW_PARAMETERS
• 6.293 USER_ADVISOR_SQLW_STMTS
• 6.294 USER_ADVISOR_SQLW_SUM
• 6.295 USER_ADVISOR_SQLW_TABLES
• 6.296 USER_ADVISOR_SQLW_TEMPLATES
• 6.297 USER_ADVISOR_TASKS
• 6.298 USER_ADVISOR_TEMPLATES
• 6.299 USER_ALL_TABLES
• 6.300 USER_ANALYTIC_VIEW_ATTR_CLASS
• 6.301 USER_ANALYTIC_VIEW_BASE_MEAS
• 6.302 USER_ANALYTIC_VIEW_CALC_MEAS
• 6.303 USER_ANALYTIC_VIEW_CLASS
• 6.304 USER_ANALYTIC_VIEW_COLUMNS
• 6.305 USER_ANALYTIC_VIEW_DIM_CLASS
• 6.306 USER_ANALYTIC_VIEW_DIMENSIONS
• 6.307 USER_ANALYTIC_VIEW_HIER_CLASS
• 6.308 USER_ANALYTIC_VIEW_HIERS
• 6.309 USER_ANALYTIC_VIEW_KEYS
• 6.310 USER_ANALYTIC_VIEW_LEVEL_CLASS
• 6.311 USER_ANALYTIC_VIEW_LEVELS
• 6.312 USER_ANALYTIC_VIEW_LVLGRPS
• 6.313 USER_ANALYTIC_VIEW_MEAS_CLASS
• 6.314 USER_ANALYTIC_VIEWS
• 6.315 USER_APPLY_ERROR
• 6.316 USER_AQ_AGENT_PRIVS
• 6.317 USER_ARGUMENTS
• 6.318 USER_ASSEMBLIES
• 6.319 USER_ASSOCIATIONS
• 6.320 USER_ATTRIBUTE_DIM_ATTR_CLASS
• 6.321 USER_ATTRIBUTE_DIM_ATTRS
• 6.322 USER_ATTRIBUTE_DIM_CLASS
• 6.323 USER_ATTRIBUTE_DIM_JOIN_PATHS
• 6.324 USER_ATTRIBUTE_DIM_KEYS
• 6.325 USER_ATTRIBUTE_DIM_LEVEL_ATTRS
• 6.326 USER_ATTRIBUTE_DIM_LEVELS
• 6.327 USER_ATTRIBUTE_DIM_LVL_CLASS
• 6.328 USER_ATTRIBUTE_DIM_ORDER_ATTRS
• 6.329 USER_ATTRIBUTE_DIM_TABLES
• 6.330 USER_ATTRIBUTE_DIMENSIONS
• 6.331 USER_ATTRIBUTE_TRANSFORMATIONS
• 6.332 USER_AUDIT_OBJECT
• 6.333 USER_AUDIT_POLICIES
• 6.334 USER_AUDIT_POLICY_COLUMNS
• 6.335 USER_AUDIT_SESSION
• 6.336 USER_AUDIT_STATEMENT
• 6.337 USER_AUDIT_TRAIL
• 6.338 USER_AW_PS
• 6.339 USER_AWS
• 6.340 USER_BASE_TABLE_MVIEWS
• 6.341 USER_CATALOG
• 6.342 USER_CHANGE_NOTIFICATION_REGS
• 6.343 USER_CLU_COLUMNS
• 6.344 USER_CLUSTER_HASH_EXPRESSIONS
• 6.345 USER_CLUSTERING_DIMENSIONS
• 6.346 USER_CLUSTERING_JOINS
• 6.347 USER_CLUSTERING_KEYS
• 6.348 USER_CLUSTERING_TABLES
• 6.349 USER_CLUSTERS
• 6.350 USER_CODE_ROLE_PRIVS
• 6.351 USER_COL_COMMENTS
• 6.352 USER_COL_PENDING_STATS
• 6.353 USER_COL_PRIVS
• 6.354 USER_COL_PRIVS_MADE
• 6.355 USER_COL_PRIVS_RECD
• 6.356 USER_COLL_TYPES
• 6.357 USER_COMPARISON
• 6.358 USER_COMPARISON_COLUMNS
• 6.359 USER_COMPARISON_ROW_DIF
• 6.360 USER_COMPARISON_SCAN
• 6.361 USER_COMPARISON_SCAN_VALUES
• 6.362 USER_CONS_COLUMNS
• 6.363 USER_CONS_OBJ_COLUMNS
• 6.364 USER_CONSTRAINTS
• 6.365 USER_CQ_NOTIFICATION_QUERIES
• 6.366 USER_CREDENTIALS
• 6.367 USER_CUBE_ATTR_VISIBILITY
• 6.368 USER_CUBE_ATTRIBUTES
• 6.369 USER_CUBE_BUILD_PROCESSES
• 6.370 USER_CUBE_CALCULATED_MEMBERS
• 6.371 USER_CUBE_DIM_LEVELS
• 6.372 USER_CUBE_DIM_MODELS
• 6.373 USER_CUBE_DIM_VIEW_COLUMNS
• 6.374 USER_CUBE_DIM_VIEWS
• 6.375 USER_CUBE_DIMENSIONALITY
• 6.376 USER_CUBE_DIMENSIONS
• 6.377 USER_CUBE_HIER_LEVELS
• 6.378 USER_CUBE_HIER_VIEW_COLUMNS
• 6.379 USER_CUBE_HIER_VIEWS
• 6.380 USER_CUBE_HIERARCHIES
• 6.381 USER_CUBE_MEASURES
• 6.382 USER_CUBE_NAMED_BUILD_SPECS
• 6.383 USER_CUBE_SUB_PARTITION_LEVELS
• 6.384 USER_CUBE_VIEW_COLUMNS
• 6.385 USER_CUBE_VIEWS
• 6.386 USER_CUBES
• 6.387 USER_DATAPUMP_JOBS
• 6.388 USER_DB_LINKS
• 6.389 USER_DBFS_HS
• 6.390 USER_DBFS_HS_COMMANDS
• 6.391 USER_DBFS_HS_FILES
• 6.392 USER_DBFS_HS_FIXED_PROPERTIES
• 6.393 USER_DBFS_HS_PROPERTIES
• 6.394 USER_DEPENDENCIES
• 6.395 USER_DIM_ATTRIBUTES
• 6.396 USER_DIM_CHILD_OF
• 6.397 USER_DIM_HIERARCHIES
• 6.398 USER_DIM_JOIN_KEY
• 6.399 USER_DIM_LEVEL_KEY
• 6.400 USER_DIM_LEVELS
• 6.401 USER_DIMENSIONS
• 6.402 USER_EDITIONED_TYPES
• 6.403 USER_EDITIONING_VIEW_COLS
• 6.404 USER_EDITIONING_VIEW_COLS_AE
• 6.405 USER_EDITIONING_VIEWS
• 6.406 USER_EDITIONING_VIEWS_AE
• 6.407 USER_ENCRYPTED_COLUMNS
• 6.408 USER_EPG_DAD_AUTHORIZATION
• 6.409 USER_ERROR_TRANSLATIONS
• 6.410 USER_ERRORS
• 6.411 USER_ERRORS_AE
• 6.412 USER_EVALUATION_CONTEXT_TABLES
• 6.413 USER_EVALUATION_CONTEXT_VARS
• 6.414 USER_EVALUATION_CONTEXTS
• 6.415 USER_EXPRESSION_STATISTICS
• 6.416 USER_EXTENTS
• 6.417 USER_EXTERNAL_LOCATIONS
• 6.418 USER_EXTERNAL_TABLES
• 6.419 USER_FILE_GROUP_EXPORT_INFO
• 6.420 USER_FILE_GROUP_FILES
• 6.421 USER_FILE_GROUP_TABLES
• 6.422 USER_FILE_GROUP_TABLESPACES
• 6.423 USER_FILE_GROUP_VERSIONS
• 6.424 USER_FILE_GROUPS
• 6.425 USER_FLASHBACK_ARCHIVE
• 6.426 USER_FLASHBACK_ARCHIVE_TABLES
• 6.427 USER_FLASHBACK_TXN_REPORT
• 6.428 USER_FLASHBACK_TXN_STATE
• 6.429 USER_FREE_SPACE
• 6.430 USER_GOLDENGATE_PRIVILEGES
• 6.431 USER_HEAT_MAP_SEG_HISTOGRAM
• 6.432 USER_HEAT_MAP_SEGMENT
• 6.433 USER_HIER_CLASS
• 6.434 USER_HIER_COLUMNS
• 6.435 USER_HIER_HIER_ATTR_CLASS
• 6.436 USER_HIER_HIER_ATTRIBUTES
• 6.437 USER_HIER_JOIN_PATHS
• 6.438 USER_HIER_LEVEL_ID_ATTRS
• 6.439 USER_HIER_LEVELS
• 6.440 USER_HIERARCHIES
• 6.441 USER_HISTOGRAMS
• 6.442 USER_HIVE_COLUMNS
• 6.443 USER_HIVE_DATABASES
• 6.444 USER_HIVE_PART_KEY_COLUMNS
• 6.445 USER_HIVE_TAB_PARTITIONS
• 6.446 USER_HIVE_TABLES
• 6.447 USER_HOST_ACES
• 6.448 USER_IDENTIFIERS
• 6.449 USER_ILMDATAMOVEMENTPOLICIES
• 6.450 USER_ILMEVALUATIONDETAILS
• 6.451 USER_ILMOBJECTS
• 6.452 USER_ILMPOLICIES
• 6.453 USER_ILMRESULTS
• 6.454 USER_ILMTASKS
• 6.455 USER_IM_EXPRESSIONS
• 6.456 USER_IND_COLUMNS
• 6.457 USER_IND_EXPRESSIONS
• 6.458 USER_IND_PARTITIONS
• 6.459 USER_IND_PENDING_STATS
• 6.460 USER_IND_STATISTICS
• 6.461 USER_IND_SUBPARTITIONS
• 6.462 USER_INDEXES
• 6.463 USER_INDEXTYPE_ARRAYTYPES
• 6.464 USER_INDEXTYPE_COMMENTS
• 6.465 USER_INDEXTYPE_OPERATORS
• 6.466 USER_INDEXTYPES
• 6.467 USER_INTERNAL_TRIGGERS
• 6.468 USER_JAVA_ARGUMENTS
• 6.469 USER_JAVA_CLASSES
• 6.470 USER_JAVA_COMPILER_OPTIONS
• 6.471 USER_JAVA_DERIVATIONS
• 6.472 USER_JAVA_FIELDS
• 6.473 USER_JAVA_IMPLEMENTS
• 6.474 USER_JAVA_INNERS
• 6.475 USER_JAVA_LAYOUTS
• 6.476 USER_JAVA_METHODS
• 6.477 USER_JAVA_NCOMPS
• 6.478 USER_JAVA_POLICY
• 6.479 USER_JAVA_RESOLVERS
• 6.480 USER_JAVA_THROWS
• 6.481 USER_JOBS
• 6.482 USER_JOIN_IND_COLUMNS
• 6.483 USER_JOINGROUPS
• 6.484 USER_JSON_COLUMNS
• 6.485 USER_JSON_DATAGUIDES
• 6.486 USER_LIBRARIES
• 6.487 USER_LOB_PARTITIONS
• 6.488 USER_LOB_SUBPARTITIONS
• 6.489 USER_LOB_TEMPLATES
• 6.490 USER_LOBS
• 6.491 USER_LOG_GROUP_COLUMNS
• 6.492 USER_LOG_GROUPS
• 6.493 USER_MEASURE_FOLDER_CONTENTS
• 6.494 USER_MEASURE_FOLDER_SUBFOLDERS
• 6.495 USER_MEASURE_FOLDERS
• 6.496 USER_METADATA_PROPERTIES
• 6.497 USER_METHOD_PARAMS
• 6.498 USER_METHOD_RESULTS
• 6.499 USER_MINING_MODEL_ATTRIBUTES
• 6.500 USER_MINING_MODEL_PARTITIONS
• 6.501 USER_MINING_MODEL_SETTINGS
• 6.502 USER_MINING_MODEL_VIEWS
• 6.503 USER_MINING_MODEL_XFORMS
• 6.504 USER_MINING_MODELS
• 6.505 USER_MVIEW_AGGREGATES
• 6.506 USER_MVIEW_ANALYSIS
• 6.507 USER_MVIEW_COMMENTS
• 6.508 USER_MVIEW_DETAIL_PARTITION
• 6.509 USER_MVIEW_DETAIL_RELATIONS
• 6.510 USER_MVIEW_DETAIL_SUBPARTITION
• 6.511 USER_MVIEW_JOINS
• 6.512 USER_MVIEW_KEYS
• 6.513 USER_MVIEW_LOGS
• 6.514 USER_MVIEW_REFRESH_TIMES
• 6.515 USER_MVIEWS
• 6.516 USER_MVREF_CHANGE_STATS
• 6.517 USER_MVREF_RUN_STATS
• 6.518 USER_MVREF_STATS
• 6.519 USER_MVREF_STATS_PARAMS
• 6.520 USER_MVREF_STATS_SYS_DEFAULTS
• 6.521 USER_MVREF_STMT_STATS
• 6.522 USER_NESTED_TABLE_COLS
• 6.523 USER_NESTED_TABLES
• 6.524 USER_NETWORK_ACL_PRIVILEGES
• 6.525 USER_OBJ_AUDIT_OPTS
• 6.526 USER_OBJ_COLATTRS
• 6.527 USER_OBJECT_SIZE
• 6.528 USER_OBJECT_TABLES
• 6.529 USER_OBJECT_USAGE
• 6.530 USER_OBJECTS
• 6.531 USER_OBJECTS_AE
• 6.532 USER_OPANCILLARY
• 6.533 USER_OPARGUMENTS
• 6.534 USER_OPBINDINGS
• 6.535 USER_OPERATOR_COMMENTS
• 6.536 USER_OPERATORS
• 6.537 USER_OUTLINE_HINTS
• 6.538 USER_OUTLINES
• 6.539 USER_PARALLEL_EXECUTE_CHUNKS
• 6.540 USER_PARALLEL_EXECUTE_TASKS
• 6.541 USER_PART_COL_STATISTICS
• 6.542 USER_PART_HISTOGRAMS
• 6.543 USER_PART_INDEXES
• 6.544 USER_PART_KEY_COLUMNS
• 6.545 USER_PART_LOBS
• 6.546 USER_PART_TABLES
• 6.547 USER_PARTIAL_DROP_TABS
• 6.548 USER_PASSWORD_LIMITS
• 6.549 USER_PENDING_CONV_TABLES
• 6.550 USER_PLSQL_COLL_TYPES
• 6.551 USER_PLSQL_OBJECT_SETTINGS
• 6.552 USER_PLSQL_TYPE_ATTRS
• 6.553 USER_PLSQL_TYPES
• 6.554 USER_POLICIES
• 6.555 USER_POLICY_ATTRIBUTES
• 6.556 USER_POLICY_CONTEXTS
• 6.557 USER_POLICY_GROUPS
• 6.558 USER_PRIVILEGE_MAP
• 6.559 USER_PROCEDURES
• 6.560 USER_PROXIES
• 6.561 USER_QUEUE_SCHEDULES
• 6.562 USER_QUEUE_SUBSCRIBERS
• 6.563 USER_QUEUE_TABLES
• 6.564 USER_QUEUES
• 6.565 USER_RECYCLEBIN
• 6.566 USER_REFRESH
• 6.567 USER_REFRESH_CHILDREN
• 6.568 USER_REFS
• 6.569 USER_REGISTERED_MVIEWS
• 6.570 USER_REGISTRY
• 6.571 USER_RESOURCE_LIMITS
• 6.572 USER_RESUMABLE
• 6.573 USER_REWRITE_EQUIVALENCES
• 6.574 USER_ROLE_PRIVS
• 6.575 USER_RSRC_CONSUMER_GROUP_PRIVS
• 6.576 USER_RSRC_MANAGER_SYSTEM_PRIVS
• 6.577 USER_RULE_SET_RULES
• 6.578 USER_RULE_SETS
• 6.579 USER_RULES
• 6.580 USER_SCHEDULER_CHAIN_RULES
• 6.581 USER_SCHEDULER_CHAIN_STEPS
• 6.582 USER_SCHEDULER_CHAINS
• 6.583 USER_SCHEDULER_CREDENTIALS
• 6.584 USER_SCHEDULER_DB_DESTS
• 6.585 USER_SCHEDULER_DESTS
• 6.586 USER_SCHEDULER_FILE_WATCHERS
• 6.587 USER_SCHEDULER_GROUP_MEMBERS
• 6.588 USER_SCHEDULER_GROUPS
• 6.589 USER_SCHEDULER_INCOMPAT_MEMBER
• 6.590 USER_SCHEDULER_INCOMPATS
• 6.591 USER_SCHEDULER_JOB_ARGS
• 6.592 USER_SCHEDULER_JOB_DESTS
• 6.593 USER_SCHEDULER_JOB_LOG
• 6.594 USER_SCHEDULER_JOB_RUN_DETAILS
• 6.595 USER_SCHEDULER_JOBS
• 6.596 USER_SCHEDULER_NOTIFICATIONS
• 6.597 USER_SCHEDULER_PROGRAM_ARGS
• 6.598 USER_SCHEDULER_PROGRAMS
• 6.599 USER_SCHEDULER_REMOTE_JOBSTATE
• 6.600 USER_SCHEDULER_RESOURCES
• 6.601 USER_SCHEDULER_RSC_CONSTRAINTS
• 6.602 USER_SCHEDULER_RUNNING_CHAINS
• 6.603 USER_SCHEDULER_RUNNING_JOBS
• 6.604 USER_SCHEDULER_SCHEDULES
• 6.605 USER_SEC_RELEVANT_COLS
• 6.606 USER_SECONDARY_OBJECTS
• 6.607 USER_SEGMENTS
• 6.608 USER_SEQUENCES
• 6.609 USER_SOURCE
• 6.610 USER_SOURCE_AE
• 6.611 USER_SQL_TRANSLATION_PROFILES
• 6.612 USER_SQL_TRANSLATIONS
• 6.613 USER_SQLJ_TYPE_ATTRS
• 6.614 USER_SQLJ_TYPE_METHODS
• 6.615 USER_SQLJ_TYPES
• 6.616 USER_SQLSET
• 6.617 USER_SQLSET_BINDS
• 6.618 USER_SQLSET_PLANS
• 6.619 USER_SQLSET_REFERENCES
• 6.620 USER_SQLSET_STATEMENTS
• 6.621 USER_SQLTUNE_BINDS
• 6.622 USER_SQLTUNE_PLANS
• 6.623 USER_SQLTUNE_RATIONALE_PLAN
• 6.624 USER_SQLTUNE_STATISTICS
• 6.625 USER_SR_GRP_STATUS
• 6.626 USER_SR_GRP_STATUS_ALL
• 6.627 USER_SR_OBJ
• 6.628 USER_SR_OBJ_ALL
• 6.629 USER_SR_OBJ_STATUS
• 6.630 USER_SR_OBJ_STATUS_ALL
• 6.631 USER_SR_PARTN_OPS
• 6.632 USER_SR_STLOG_EXCEPTIONS
• 6.633 USER_SR_STLOG_STATS
• 6.634 USER_STAT_EXTENSIONS
• 6.635 USER_STATEMENTS
• 6.636 USER_STORED_SETTINGS
• 6.637 USER_SUBPART_COL_STATISTICS
• 6.638 USER_SUBPART_HISTOGRAMS
• 6.639 USER_SUBPART_KEY_COLUMNS
• 6.640 USER_SUBPARTITION_TEMPLATES
• 6.641 USER_SUBSCR_REGISTRATIONS
• 6.642 USER_SYNONYMS
• 6.643 USER_SYS_PRIVS
• 6.644 USER_TAB_COL_STATISTICS
• 6.645 USER_TAB_COLS
• 6.646 USER_TAB_COLUMNS
• 6.647 USER_TAB_COMMENTS
• 6.648 USER_TAB_HISTGRM_PENDING_STATS
• 6.649 USER_TAB_HISTOGRAMS
• 6.650 USER_TAB_IDENTITY_COLS
• 6.651 USER_TAB_MODIFICATIONS
• 6.652 USER_TAB_PARTITIONS
• 6.653 USER_TAB_PENDING_STATS
• 6.654 USER_TAB_PRIVS
• 6.655 USER_TAB_PRIVS_MADE
• 6.656 USER_TAB_PRIVS_RECD
• 6.657 USER_TAB_STAT_PREFS
• 6.658 USER_TAB_STATISTICS
• 6.659 USER_TAB_STATS_HISTORY
• 6.660 USER_TAB_SUBPARTITIONS
• 6.661 USER_TABLES
• 6.662 USER_TABLESPACES
• 6.663 USER_TRANSFORMATIONS
• 6.664 USER_TRIGGER_COLS
• 6.665 USER_TRIGGER_ORDERING
• 6.666 USER_TRIGGERS
• 6.667 USER_TS_QUOTAS
• 6.668 USER_TSTZ_TAB_COLS
• 6.669 USER_TSTZ_TABLES
• 6.670 USER_TUNE_MVIEW
• 6.671 USER_TYPE_ATTRS
• 6.672 USER_TYPE_METHODS
• 6.673 USER_TYPE_VERSIONS
• 6.674 USER_TYPES
• 6.675 USER_UNUSED_COL_TABS
• 6.676 USER_UPDATABLE_COLUMNS
• 6.677 USER_USERS
• 6.678 USER_USTATS
• 6.679 USER_VARRAYS
• 6.680 USER_VIEWS
• 6.681 USER_VIEWS_AE
• 6.682 USER_WALLET_ACES
• 6.683 USER_WARNING_SETTINGS
• 6.684 USER_XML_INDEXES
• 6.685 USER_XML_NESTED_TABLES
• 6.686 USER_XML_OUT_OF_LINE_TABLES
• 6.687 USER_XML_SCHEMA_ATTRIBUTES
• 6.688 USER_XML_SCHEMA_COMPLEX_TYPES
• 6.689 USER_XML_SCHEMA_ELEMENTS
• 6.690 USER_XML_SCHEMA_NAMESPACES
• 6.691 USER_XML_SCHEMA_SIMPLE_TYPES
• 6.692 USER_XML_SCHEMA_SUBSTGRP_HEAD
• 6.693 USER_XML_SCHEMA_SUBSTGRP_MBRS
• 6.694 USER_XML_SCHEMAS
• 6.695 USER_XML_TAB_COLS
• 6.696 USER_XML_TABLES
• 6.697 USER_XML_VIEW_COLS
• 6.698 USER_XML_VIEWS
• 6.699 USER_XTERNAL_LOC_PARTITIONS
• 6.700 USER_XTERNAL_LOC_SUBPARTITIONS
• 6.701 USER_XTERNAL_PART_TABLES
• 6.702 USER_XTERNAL_TAB_PARTITIONS
• 6.703 USER_XTERNAL_TAB_SUBPARTITIONS
• 6.704 USER_ZONEMAP_MEASURES
• 6.705 USER_ZONEMAPS

Part III Dynamic Performance Views

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

• 7.1 About Dynamic Performance Views
  • 7.1.1 V$ Views
  • 7.1.2 GV$ Views
• 7.2 Dynamic Performance View Descriptions
• 7.3 V$ACCESS
• 7.4 V$ACTIVE_INSTANCES
• 7.5 V$ACTIVE_SERVICES
• 7.6 V$ACTIVE_SESS_POOL_MTH
• 7.7 V$ACTIVE_SESSION_HISTORY
• 7.8 V$ADVISOR_PROGRESS
• 7.9 V$ALERT_TYPES
• 7.10 V$AQ
• 7.11 V$AQ_BACKGROUND_COORDINATOR
• 7.12 V$AQ_BMAP_NONDUR_SUBSCRIBERS
• 7.13 V$AQ_CROSS_INSTANCE_JOBS
• 7.14 V$AQ_JOB_COORDINATOR
• 7.15 V$AQ_MESSAGE_CACHE
• 7.16 V$AQ_MESSAGE_CACHE_ADVICE
• 7.17 V$AQ_MESSAGE_CACHE_STAT
• 7.18 V$AQ_NONDUR_REGISTRATIONS
• 7.19 V$AQ_NONDUR_SUBSCRIBER
• 7.20 V$AQ_NONDUR_SUBSCRIBER_LWM
• 7.21 V$AQ_NOTIFICATION_CLIENTS
• 7.22 V$AQ_REMOTE_DEQUEUE_AFFINITY
• 7.23 V$AQ_SERVER_POOL
• 7.24 V$AQ_SHARDED_SUBSCRIBER_STAT
• 7.25 V$AQ_SUBSCRIBER_LOAD
• 7.26 V$ARCHIVE
• 7.27 V$ARCHIVE_DEST
• 7.28 V$ARCHIVE_DEST_STATUS
• 7.29 V$ARCHIVE_GAP
• 7.30 V$ARCHIVE_PROCESSES
• 7.31 V$ARCHIVED_LOG
• 7.32 V$ASM_ACFS_ENCRYPTION_INFO
• 7.33 V$ASM_ACFS_SEC_ADMIN
• 7.34 V$ASM_ACFS_SEC_CMDRULE
• 7.35 V$ASM_ACFS_SEC_REALM
• 7.36 V$ASM_ACFS_SEC_REALM_FILTER
• 7.37 V$ASM_ACFS_SEC_REALM_GROUP
• 7.38 V$ASM_ACFS_SEC_REALM_USER
• 7.39 V$ASM_ACFS_SEC_RULE
• 7.40 V$ASM_ACFS_SEC_RULESET
• 7.41 V$ASM_ACFS_SEC_RULESET_RULE
• 7.42 V$ASM_ACFS_SECURITY_INFO
• 7.43 V$ASM_ACFSREPL
• 7.44 V$ASM_ACFSREPLTAG
• 7.45 V$ASM_ACFSSNAPSHOTS
• 7.46 V$ASM_ACFSTAG
• 7.47 V$ASM_ACFSVOLUMES
• 7.48 V$ASM_ALIAS
• 7.49 V$ASM_ATTRIBUTE
• 7.50 V$ASM_AUDIT_CLEAN_EVENTS
• 7.51 V$ASM_AUDIT_CLEANUP_JOBS
• 7.52 V$ASM_AUDIT_CONFIG_PARAMS
• 7.53 V$ASM_AUDIT_LAST_ARCH_TS
• 7.54 V$ASM_CLIENT
• 7.55 V$ASM_DISK
• 7.56 V$ASM_DISK_IOSTAT
• 7.57 V$ASM_DISK_STAT
• 7.58 V$ASM_DISKGROUP
• 7.59 V$ASM_DISKGROUP_STAT
• 7.60 V$ASM_ESTIMATE
• 7.61 V$ASM_FILE
• 7.62 V$ASM_FILEGROUP
• 7.63 V$ASM_FILEGROUP_FILE
• 7.64 V$ASM_FILEGROUP_PROPERTY
• 7.65 V$ASM_FILESYSTEM
• 7.66 V$ASM_OPERATION
• 7.67 V$ASM_QUOTAGROUP
• 7.68 V$ASM_TEMPLATE
• 7.69 V$ASM_USER
• 7.70 V$ASM_USERGROUP
• 7.71 V$ASM_USERGROUP_MEMBER
• 7.72 V$ASM_VOLUME
• 7.73 V$ASM_VOLUME_STAT
• 7.74 V$AW_AGGREGATE_OP
• 7.75 V$AW_ALLOCATE_OP
• 7.76 V$AW_CALC
• 7.77 V$AW_LONGOPS
• 7.78 V$AW_OLAP
• 7.79 V$AW_SESSION_INFO
• 7.80 V$BACKUP
• 7.81 V$BACKUP_ARCHIVELOG_DETAILS
• 7.82 V$BACKUP_ARCHIVELOG_SUMMARY
• 7.83 V$BACKUP_ASYNC_IO
• 7.84 V$BACKUP_CONTROLFILE_DETAILS
• 7.85 V$BACKUP_CONTROLFILE_SUMMARY
• 7.86 V$BACKUP_COPY_DETAILS
• 7.87 V$BACKUP_COPY_SUMMARY
• 7.88 V$BACKUP_CORRUPTION
• 7.89 V$BACKUP_DATAFILE
• 7.90 V$BACKUP_DATAFILE_DETAILS
• 7.91 V$BACKUP_DATAFILE_SUMMARY
• 7.92 V$BACKUP_DEVICE
• 7.93 V$BACKUP_FILES
• 7.94 V$BACKUP_NONLOGGED
• 7.95 V$BACKUP_PIECE
• 7.96 V$BACKUP_PIECE_DETAILS
• 7.97 V$BACKUP_REDOLOG
• 7.98 V$BACKUP_SET
• 7.99 V$BACKUP_SET_DETAILS
• 7.100 V$BACKUP_SET_SUMMARY
• 7.101 V$BACKUP_SPFILE
• 7.102 V$BACKUP_SPFILE_DETAILS
• 7.103 V$BACKUP_SPFILE_SUMMARY
• 7.104 V$BACKUP_SYNC_IO
• 7.105 V$BGPROCESS
• 7.106 V$BH
• 7.107 V$BLOCK_CHANGE_TRACKING
• 7.108 V$BLOCKING_QUIESCE
• 7.109 V$BT_SCAN_CACHE
• 7.110 V$BT_SCAN_OBJ_TEMPS
• 7.111 V$BUFFER_POOL
• 7.112 V$BUFFER_POOL_STATISTICS
• 7.113 V$BUFFERED_PUBLISHERS
• 7.114 V$BUFFERED_QUEUES
• 7.115 V$BUFFERED_SUBSCRIBERS
• 7.116 V$CACHE
• 7.117 V$CACHE_LOCK
• 7.118 V$CACHE_TRANSFER
• 7.119 V$CHUNK_METRIC
• 7.120 V$CIRCUIT
• 7.121 V$CLASS_CACHE_TRANSFER
• 7.122 V$CLEANUP_PROCESS
• 7.123 V$CLIENT_SECRETS
• 7.124 V$CLIENT_STATS
• 7.125 V$CLONEDFILE
• 7.126 V$CLUSTER_INTERCONNECTS
• 7.127 V$CODE_CLAUSE
• 7.128 V$CON_EVENT_HISTOGRAM_MICRO
• 7.129 V$CON_SYS_TIME_MODEL
• 7.130 V$CON_SYSMETRIC
• 7.131 V$CON_SYSMETRIC_HISTORY
• 7.132 V$CON_SYSMETRIC_SUMMARY
• 7.133 V$CON_SYSSTAT
• 7.134 V$CON_SYSTEM_EVENT
• 7.135 V$CON_SYSTEM_WAIT_CLASS
• 7.136 V$CONFIGURED_INTERCONNECTS
• 7.137 V$CONTAINERS
• 7.138 V$CONTEXT
• 7.139 V$CONTROLFILE
• 7.140 V$CONTROLFILE_RECORD_SECTION
• 7.141 V$COPY_CORRUPTION
• 7.142 V$COPY_NONLOGGED
• 7.143 V$CORRUPT_XID_LIST
• 7.144 V$CPOOL_CC_INFO
• 7.145 V$CPOOL_CC_STATS
• 7.146 V$CPOOL_CONN_INFO
• 7.147 V$CPOOL_STATS
• 7.148 V$CR_BLOCK_SERVER
• 7.149 V$CURRENT_BLOCK_SERVER
• 7.150 V$DATABASE
• 7.151 V$DATABASE_BLOCK_CORRUPTION
• 7.152 V$DATABASE_INCARNATION
• 7.153 V$DATABASE_KEY_INFO
• 7.154 V$DATAFILE
• 7.155 V$DATAFILE_COPY
• 7.156 V$DATAFILE_HEADER
• 7.157 V$DATAGUARD_CONFIG
• 7.158 V$DATAGUARD_PROCESS
• 7.159 V$DATAGUARD_STATS
• 7.160 V$DATAGUARD_STATUS
• 7.161 V$DB_CACHE_ADVICE
• 7.162 V$DB_OBJECT_CACHE
• 7.163 V$DB_PIPES
• 7.164 V$DB_TRANSPORTABLE_PLATFORM
• 7.165 V$DBFILE
• 7.166 V$DBLINK
• 7.167 V$DEAD_CLEANUP
• 7.168 V$DELETED_OBJECT
• 7.169 V$DG_BROKER_CONFIG
• 7.170 V$DIAG_ALERT_EXT
• 7.171 V$DIAG_APP_TRACE_FILE
• 7.172 V$DIAG_INCIDENT
• 7.173 V$DIAG_INFO
• 7.174 V$DIAG_OPT_TRACE_RECORDS
• 7.175 V$DIAG_PROBLEM
• 7.176 V$DIAG_SESS_OPT_TRACE_RECORDS
• 7.177 V$DIAG_SESS_SQL_TRACE_RECORDS
• 7.178 V$DIAG_SQL_TRACE_RECORDS
• 7.179 V$DIAG_TRACE_FILE
• 7.180 V$DIAG_TRACE_FILE_CONTENTS
• 7.181 V$DISPATCHER
• 7.182 V$DISPATCHER_CONFIG
• 7.183 V$DISPATCHER_RATE
• 7.184 V$DNFS_CHANNELS
• 7.185 V$DNFS_FILES
• 7.186 V$DNFS_SERVERS
• 7.187 V$DNFS_STATS
• 7.188 V$DYNAMIC_REMASTER_STATS
• 7.189 V$EDITIONABLE_TYPES
• 7.190 V$EMON
• 7.191 V$EMX_USAGE_STATS
• 7.192 V$ENABLEDPRIVS
• 7.193 V$ENCRYPTED_TABLESPACES
• 7.194 V$ENCRYPTION_KEYS
• 7.195 V$ENCRYPTION_WALLET
• 7.196 V$ENQUEUE_LOCK
• 7.197 V$ENQUEUE_STAT
• 7.198 V$ENQUEUE_STATISTICS
• 7.199 V$EVENT_HISTOGRAM
• 7.200 V$EVENT_HISTOGRAM_MICRO
• 7.201 V$EVENT_NAME
• 7.202 V$EVENTMETRIC
• 7.203 V$EXADIRECT_ACL
• 7.204 V$EXECUTION
• 7.205 V$EXP_STATS
• 7.206 V$FALSE_PING
• 7.207 V$FAST_START_SERVERS
• 7.208 V$FAST_START_TRANSACTIONS
• 7.209 V$FILE_CACHE_TRANSFER
• 7.210 V$FILE_HISTOGRAM
• 7.211 V$FILEMETRIC
• 7.212 V$FILEMETRIC_HISTORY
• 7.213 V$FILESPACE_USAGE
• 7.214 V$FILESTAT
• 7.215 V$FIXED_TABLE
• 7.216 V$FIXED_VIEW_DEFINITION
• 7.217 V$FLASHBACK_DATABASE_LOG
• 7.218 V$FLASHBACK_DATABASE_LOGFILE
• 7.219 V$FLASHBACK_DATABASE_STAT
• 7.220 V$FLASHBACK_TXN_GRAPH
• 7.221 V$FLASHBACK_TXN_MODS
• 7.222 V$FLASHFILESTAT
• 7.223 V$FOREIGN_ARCHIVED_LOG
• 7.224 V$FS_FAILOVER_OBSERVERS
• 7.225 V$FS_FAILOVER_STATS
• 7.226 V$FS_OBSERVER_HISTOGRAM
• 7.227 V$GC_ELEMENT
• 7.228 V$GC_ELEMENTS_WITH_COLLISIONS
• 7.229 V$GCR_ACTIONS
• 7.230 V$GCR_LOG
• 7.231 V$GCR_METRICS
• 7.232 V$GCR_STATUS
• 7.233 V$GCSHVMASTER_INFO
• 7.234 V$GCSPFMASTER_INFO
• 7.235 V$GES_BLOCKING_ENQUEUE
• 7.236 V$GES_CONVERT_LOCAL
• 7.237 V$GES_CONVERT_REMOTE
• 7.238 V$GES_ENQUEUE
• 7.239 V$GES_LATCH
• 7.240 V$GES_RESOURCE
• 7.241 V$GES_STATISTICS
• 7.242 V$GG_APPLY_COORDINATOR
• 7.243 V$GG_APPLY_READER
• 7.244 V$GG_APPLY_RECEIVER
• 7.245 V$GG_APPLY_SERVER
• 7.246 V$GLOBAL_BLOCKED_LOCKS
• 7.247 V$GLOBAL_TRANSACTION
• 7.248 V$GOLDENGATE_CAPTURE
• 7.249 V$GOLDENGATE_MESSAGE_TRACKING
• 7.250 V$GOLDENGATE_PROCEDURE_STATS
• 7.251 V$GOLDENGATE_TABLE_STATS
• 7.252 V$GOLDENGATE_TRANSACTION
• 7.253 V$HANG_INFO
• 7.254 V$HANG_SESSION_INFO
• 7.255 V$HANG_STATISTICS
• 7.256 V$HEAT_MAP_SEGMENT
• 7.257 V$HM_CHECK
• 7.258 V$HM_CHECK_PARAM
• 7.259 V$HM_FINDING
• 7.260 V$HM_INFO
• 7.261 V$HM_RECOMMENDATION
• 7.262 V$HM_RUN
• 7.263 V$HS_AGENT
• 7.264 V$HS_PARAMETER
• 7.265 V$HS_SESSION
• 7.266 V$HVMASTER_INFO

8 Dynamic Performance (V$) Views: V$IM_COLUMN_LEVEL to V$RULE_SET_AGGREGATE_STATS

• 8.1 V$IM_COLUMN_LEVEL
• 8.2 V$IM_SEGMENTS
• 8.3 V$IM_USER_SEGMENTS
• 8.4 V$INDEX_USAGE_INFO
• 8.5 V$INDEXED_FIXED_COLUMN
• 8.6 V$INMEMORY_AREA
• 8.7 V$INMEMORY_FASTSTART_AREA
• 8.8 V$INSTANCE
• 8.9 V$INSTANCE_CACHE_TRANSFER
• 8.10 V$INSTANCE_PING
• 8.11 V$INSTANCE_RECOVERY
• 8.12 V$IO_CALIBRATION_STATUS
• 8.13 V$IO_OUTLIER
• 8.14 V$IOFUNCMETRIC
• 8.15 V$IOFUNCMETRIC_HISTORY
• 8.16 V$IOS_CLIENT
• 8.17 V$IOSTAT_CONSUMER_GROUP
• 8.18 V$IOSTAT_FILE
• 8.19 V$IOSTAT_FUNCTION
• 8.20 V$IOSTAT_FUNCTION_DETAIL
• 8.21 V$IOSTAT_NETWORK
• 8.22 V$IP_ACL
• 8.23 V$JAVA_LIBRARY_CACHE_MEMORY
• 8.24 V$JAVA_POOL_ADVICE
• 8.25 V$KERNEL_IO_OUTLIER
• 8.26 V$KEY_VECTOR
• 8.27 V$LATCH
• 8.28 V$LATCH_CHILDREN
• 8.29 V$LATCH_MISSES
• 8.30 V$LATCH_PARENT
• 8.31 V$LATCHHOLDER
• 8.32 V$LATCHNAME
• 8.33 V$LGWRIO_OUTLIER
• 8.34 V$LIBCACHE_LOCKS
• 8.35 V$LIBRARY_CACHE_MEMORY
• 8.36 V$LIBRARYCACHE
• 8.37 V$LICENSE
• 8.38 V$LOADISTAT
• 8.39 V$LOADPSTAT
• 8.40 V$LOCK
• 8.41 V$LOCK_ACTIVITY
• 8.42 V$LOCK_TYPE
• 8.43 V$LOCKED_OBJECT
• 8.44 V$LOG
• 8.45 V$LOG_HISTORY
• 8.46 V$LOGFILE
• 8.47 V$LOGHIST
• 8.48 V$LOGMNR_CONTENTS
• 8.49 V$LOGMNR_DICTIONARY
• 8.50 V$LOGMNR_DICTIONARY_LOAD
• 8.51 V$LOGMNR_LATCH
• 8.52 V$LOGMNR_LOGS
• 8.53 V$LOGMNR_PARAMETERS
• 8.54 V$LOGMNR_PROCESS
• 8.55 V$LOGMNR_SESSION
• 8.56 V$LOGMNR_STATS
• 8.57 V$LOGSTDBY
• 8.58 V$LOGSTDBY_PROCESS
• 8.59 V$LOGSTDBY_PROGRESS
• 8.60 V$LOGSTDBY_STATE
• 8.61 V$LOGSTDBY_STATS
• 8.62 V$LOGSTDBY_TRANSACTION
• 8.63 V$MANAGED_STANDBY
• 8.64 V$MAP_COMP_LIST
• 8.65 V$MAP_ELEMENT
• 8.66 V$MAP_EXT_ELEMENT
• 8.67 V$MAP_FILE
• 8.68 V$MAP_FILE_EXTENT
• 8.69 V$MAP_FILE_IO_STACK
• 8.70 V$MAP_LIBRARY
• 8.71 V$MAP_SUBELEMENT
• 8.72 V$MAPPED_SQL
• 8.73 V$MEMORY_CURRENT_RESIZE_OPS
• 8.74 V$MEMORY_DYNAMIC_COMPONENTS
• 8.75 V$MEMORY_RESIZE_OPS
• 8.76 V$MEMORY_TARGET_ADVICE
• 8.77 V$METRIC
• 8.78 V$METRICGROUP
• 8.79 V$METRIC_HISTORY
• 8.80 V$METRICNAME
• 8.81 V$MTTR_TARGET_ADVICE
• 8.82 V$MUTEX_SLEEP
• 8.83 V$MUTEX_SLEEP_HISTORY
• 8.84 V$MVREFRESH
• 8.85 V$MYSTAT
• 8.86 V$NFS_CLIENTS
• 8.87 V$NFS_LOCKS
• 8.88 V$NFS_OPEN_FILES
• 8.89 V$NLS_PARAMETERS
• 8.90 V$NLS_VALID_VALUES
• 8.91 V$NONLOGGED_BLOCK
• 8.92 V$OBJECT_DEPENDENCY
• 8.93 V$OBJECT_PRIVILEGE
• 8.94 V$OBJECT_USAGE
• 8.95 V$OBSOLETE_BACKUP_FILES
• 8.96 V$OBSOLETE_PARAMETER
• 8.97 V$OFFLINE_RANGE
• 8.98 V$OFS_STATS
• 8.99 V$OFSMOUNT
• 8.100 V$ONLINE_REDEF
• 8.101 V$OPEN_CURSOR
• 8.102 V$OPTIMIZER_PROCESSING_RATE
• 8.103 V$OPTION
• 8.104 V$OSSTAT
• 8.105 V$PARALLEL_DEGREE_LIMIT_MTH
• 8.106 V$PARAMETER
• 8.107 V$PARAMETER_VALID_VALUES
• 8.108 V$PARAMETER2
• 8.109 V$PASSWORDFILE_INFO
• 8.110 V$PATCHES
• 8.111 V$PDB_INCARNATION
• 8.112 V$PDBS
• 8.113 V$PERSISTENT_PUBLISHERS
• 8.114 V$PERSISTENT_QMN_CACHE
• 8.115 V$PERSISTENT_QUEUES
• 8.116 V$PERSISTENT_SUBSCRIBERS
• 8.117 V$PGA_TARGET_ADVICE
• 8.118 V$PGA_TARGET_ADVICE_HISTOGRAM
• 8.119 V$PGASTAT
• 8.120 V$PLSQL_DEBUGGABLE_SESSIONS
• 8.121 V$PQ_SESSTAT
• 8.122 V$PQ_SLAVE
• 8.123 V$PQ_SYSSTAT
• 8.124 V$PQ_TQSTAT
• 8.125 V$PROCESS
• 8.126 V$PROCESS_MEMORY
• 8.127 V$PROCESS_MEMORY_DETAIL
• 8.128 V$PROCESS_POOL
• 8.129 V$PROPAGATION_RECEIVER
• 8.130 V$PROPAGATION_SENDER
• 8.131 V$PROXY_ARCHIVEDLOG
• 8.132 V$PROXY_ARCHIVELOG_DETAILS
• 8.133 V$PROXY_ARCHIVELOG_SUMMARY
• 8.134 V$PROXY_COPY_DETAILS
• 8.135 V$PROXY_COPY_SUMMARY
• 8.136 V$PROXY_DATAFILE
• 8.137 V$PROXY_PDB_TARGETS
• 8.138 V$PWFILE_USERS
• 8.139 V$PX_INSTANCE_GROUP
• 8.140 V$PX_PROCESS
• 8.141 V$PX_PROCESS_SYSSTAT
• 8.142 V$PX_SESSION
• 8.143 V$PX_SESSTAT
• 8.144 V$QMON_COORDINATOR_STATS
• 8.145 V$QMON_SERVER_STATS
• 8.146 V$QMON_TASK_STATS
• 8.147 V$QMON_TASKS
• 8.148 V$QUARANTINE
• 8.149 V$QUEUE
• 8.150 V$QUEUEING_MTH
• 8.151 V$RECOVER_FILE
• 8.152 V$RECOVERY_AREA_USAGE
• 8.153 V$RECOVERY_FILE_DEST
• 8.154 V$RECOVERY_FILE_STATUS
• 8.155 V$RECOVERY_LOG
• 8.156 V$RECOVERY_PROGRESS
• 8.157 V$RECOVERY_SLAVE
• 8.158 V$RECOVERY_STATUS
• 8.159 V$REDO_DEST_RESP_HISTOGRAM
• 8.160 V$REQDIST
• 8.161 V$RESERVED_WORDS
• 8.162 V$RESOURCE
• 8.163 V$RESOURCE_LIMIT
• 8.164 V$RESTORE_POINT
• 8.165 V$RESULT_CACHE_DEPENDENCY
• 8.166 V$RESULT_CACHE_MEMORY
• 8.167 V$RESULT_CACHE_OBJECTS
• 8.168 V$RESULT_CACHE_STATISTICS
• 8.169 V$RMAN_BACKUP_JOB_DETAILS
• 8.170 V$RMAN_BACKUP_SUBJOB_DETAILS
• 8.171 V$RMAN_BACKUP_TYPE
• 8.172 V$RMAN_COMPRESSION_ALGORITHM
• 8.173 V$RMAN_CONFIGURATION
• 8.174 V$RMAN_ENCRYPTION_ALGORITHMS
• 8.175 V$RMAN_OUTPUT
• 8.176 V$RMAN_STATUS
• 8.177 V$RO_USER_ACCOUNT
• 8.178 V$ROLLNAME
• 8.179 V$ROLLSTAT
• 8.180 V$ROWCACHE
• 8.181 V$ROWCACHE_PARENT
• 8.182 V$ROWCACHE_SUBORDINATE
• 8.183 V$RSRC_CONS_GROUP_HISTORY
• 8.184 V$RSRC_CONSUMER_GROUP
• 8.185 V$RSRC_CONSUMER_GROUP_CPU_MTH
• 8.186 V$RSRC_PDB
• 8.187 V$RSRC_PDB_HISTORY
• 8.188 V$RSRC_PLAN
• 8.189 V$RSRC_PLAN_CPU_MTH
• 8.190 V$RSRC_PLAN_HISTORY
• 8.191 V$RSRC_SESSION_INFO
• 8.192 V$RSRCMGRMETRIC
• 8.193 V$RSRCMGRMETRIC_HISTORY
• 8.194 V$RSRCPDBMETRIC
• 8.195 V$RSRCPDBMETRIC_HISTORY
• 8.196 V$RULE
• 8.197 V$RULE_SET
• 8.198 V$RULE_SET_AGGREGATE_STATS

9 Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS

• 9.1 V$SCHEDULER_RUNNING_JOBS
• 9.2 V$SECUREFILE_TIMER
• 9.3 V$SEGMENT_STATISTICS
• 9.4 V$SEGSTAT
• 9.5 V$SEGSTAT_NAME
• 9.6 V$SERV_MOD_ACT_STATS
• 9.7 V$SERVICE_EVENT
• 9.8 V$SERVICE_REGION_METRIC
• 9.9 V$SERVICE_STATS
• 9.10 V$SERVICE_WAIT_CLASS
• 9.11 V$SERVICEMETRIC
• 9.12 V$SERVICEMETRIC_HISTORY
• 9.13 V$SERVICES
• 9.14 V$SES_OPTIMIZER_ENV
• 9.15 V$SESS_IO
• 9.16 V$SESS_TIME_MODEL
• 9.17 V$SESSION
• 9.18 V$SESSION_BLOCKERS
• 9.19 V$SESSION_CONNECT_INFO
• 9.20 V$SESSION_CURSOR_CACHE
• 9.21 V$SESSION_EVENT
• 9.22 V$SESSION_FIX_CONTROL
• 9.23 V$SESSION_LONGOPS
• 9.24 V$SESSION_OBJECT_CACHE
• 9.25 V$SESSION_WAIT
• 9.26 V$SESSION_WAIT_CLASS
• 9.27 V$SESSION_WAIT_HISTORY
• 9.28 V$SESSIONS_COUNT
• 9.29 V$SESSMETRIC
• 9.30 V$SESSTAT
• 9.31 V$SGA
• 9.32 V$SGA_CURRENT_RESIZE_OPS
• 9.33 V$SGA_DYNAMIC_COMPONENTS
• 9.34 V$SGA_DYNAMIC_FREE_MEMORY
• 9.35 V$SGA_RESIZE_OPS
• 9.36 V$SGA_TARGET_ADVICE
• 9.37 V$SGAINFO
• 9.38 V$SGASTAT
• 9.39 V$SHARED_POOL_ADVICE
• 9.40 V$SHARED_POOL_RESERVED
• 9.41 V$SHARED_SERVER
• 9.42 V$SHARED_SERVER_MONITOR
• 9.43 V$SORT_SEGMENT
• 9.44 V$SPPARAMETER
• 9.45 V$SQL
• 9.46 V$SQL_BIND_CAPTURE
• 9.47 V$SQL_BIND_DATA
• 9.48 V$SQL_BIND_METADATA
• 9.49 V$SQL_CS_HISTOGRAM
• 9.50 V$SQL_CS_SELECTIVITY
• 9.51 V$SQL_CS_STATISTICS
• 9.52 V$SQL_CURSOR
• 9.53 V$SQL_JOIN_FILTER
• 9.54 V$SQL_MONITOR
• 9.55 V$SQL_MONITOR_SESSTAT
• 9.56 V$SQL_MONITOR_STATNAME
• 9.57 V$SQL_OPTIMIZER_ENV
• 9.58 V$SQL_PLAN
• 9.59 V$SQL_PLAN_MONITOR
• 9.60 V$SQL_PLAN_STATISTICS
• 9.61 V$SQL_PLAN_STATISTICS_ALL
• 9.62 V$SQL_REDIRECTION
• 9.63 V$SQL_SHARED_CURSOR
• 9.64 V$SQL_SHARED_MEMORY
• 9.65 V$SQL_WORKAREA
• 9.66 V$SQL_WORKAREA_ACTIVE
• 9.67 V$SQL_WORKAREA_HISTOGRAM
• 9.68 V$SQLAREA
• 9.69 V$SQLAREA_PLAN_HASH
• 9.70 V$SQLCOMMAND
• 9.71 V$SQLFN_ARG_METADATA
• 9.72 V$SQLFN_METADATA
• 9.73 V$SQLSTATS
• 9.74 V$SQLSTATS_PLAN_HASH
• 9.75 V$SQLTEXT
• 9.76 V$SQLTEXT_WITH_NEWLINES
• 9.77 V$STANDBY_EVENT_HISTOGRAM
• 9.78 V$STANDBY_LOG
• 9.79 V$STATISTICS_LEVEL
• 9.80 V$STATNAME
• 9.81 V$STATS_ADVISOR_RULES
• 9.82 V$STREAMS_APPLY_COORDINATOR
• 9.83 V$STREAMS_APPLY_READER
• 9.84 V$STREAMS_APPLY_SERVER
• 9.85 V$STREAMS_CAPTURE
• 9.86 V$STREAMS_MESSAGE_TRACKING
• 9.87 V$STREAMS_POOL_ADVICE
• 9.88 V$STREAMS_POOL_STATISTICS
• 9.89 V$STREAMS_TRANSACTION
• 9.90 V$SUBCACHE
• 9.91 V$SUBSCR_REGISTRATION_STATS
• 9.92 V$SYS_OPTIMIZER_ENV
• 9.93 V$SYS_TIME_MODEL
• 9.94 V$SYSAUX_OCCUPANTS
• 9.95 V$SYSMETRIC
• 9.96 V$SYSMETRIC_HISTORY
• 9.97 V$SYSMETRIC_SUMMARY
• 9.98 V$SYSSTAT
• 9.99 V$SYSTEM_CURSOR_CACHE
• 9.100 V$SYSTEM_EVENT
• 9.101 V$SYSTEM_FIX_CONTROL
• 9.102 V$SYSTEM_PARAMETER
• 9.103 V$SYSTEM_PARAMETER2
• 9.104 V$SYSTEM_WAIT_CLASS
• 9.105 V$TABLESPACE
• 9.106 V$TEMP_CACHE_TRANSFER
• 9.107 V$TEMP_EXTENT_MAP
• 9.108 V$TEMP_EXTENT_POOL
• 9.109 V$TEMP_SPACE_HEADER
• 9.110 V$TEMPFILE
• 9.111 V$TEMPORARY_LOBS
• 9.112 V$TEMPSEG_USAGE
• 9.113 V$TEMPSTAT
• 9.114 V$TEMPUNDOSTAT
• 9.115 V$THREAD
• 9.116 V$THRESHOLD_TYPES
• 9.117 V$TIMER
• 9.118 V$TIMEZONE_NAMES
• 9.119 V$TOPLEVELCALL
• 9.120 V$TRANSACTION
• 9.121 V$TRANSACTION_ENQUEUE
• 9.122 V$TRANSPORTABLE_PLATFORM
• 9.123 V$TSDP_SUPPORTED_FEATURE
• 9.124 V$TYPE_SIZE
• 9.125 V$UNDOSTAT
• 9.126 V$UNUSABLE_BACKUPFILE_DETAILS
• 9.127 V$VERSION
• 9.128 V$VPD_POLICY
• 9.129 V$WAIT_CHAINS
• 9.130 V$WAITCLASSMETRIC
• 9.131 V$WAITCLASSMETRIC_HISTORY
• 9.132 V$WAITSTAT
• 9.133 V$WALLET
• 9.134 V$WORKLOAD_REPLAY_THREAD
• 9.135 V$XML_AUDIT_TRAIL
• 9.136 V$XSTREAM_APPLY_COORDINATOR
• 9.137 V$XSTREAM_APPLY_READER
• 9.138 V$XSTREAM_APPLY_RECEIVER
• 9.139 V$XSTREAM_APPLY_SERVER
• 9.140 V$XSTREAM_CAPTURE
• 9.141 V$XSTREAM_MESSAGE_TRACKING
• 9.142 V$XSTREAM_OUTBOUND_SERVER
• 9.143 V$XSTREAM_TABLE_STATS
• 9.144 V$XSTREAM_TRANSACTION
• 9.145 V$ZONEMAP_USAGE_STATS

Part IV Appendixes

A Database Limits

• A.1 Datatype Limits
• A.2 Physical Database Limits
• A.3 Logical Database Limits
• A.4 Process and Runtime Limits

B SQL Scripts

• B.1 Creating the Data Dictionary
• B.2 Creating Additional Data Dictionary Structures
• B.3 The "NO" Scripts
• B.4 Upgrade Scripts
• B.5 Java Scripts

C Oracle Wait Events

• C.1 Classes of Wait Events
• C.2 Descriptions of Common Wait Event Parameters
• C.3 Descriptions of Wait Events
  • C.3.1 alter system set dispatcher
  • C.3.2 ARCH Remote Write
  • C.3.3 ASYNC Remote Write
  • C.3.4 batched allocate scn lock request
  • C.3.5 BFILE check if exists
  • C.3.6 BFILE check if open
  • C.3.7 BFILE closure
  • C.3.8 BFILE get length
  • C.3.9 BFILE get name object
  • C.3.10 BFILE get path object
  • C.3.11 BFILE internal seek
  • C.3.12 BFILE open
  • C.3.13 BFILE read
  • C.3.14 broadcast mesg queue transition
  • C.3.15 broadcast mesg recovery queue transition
  • C.3.16 buffer busy waits
  • C.3.17 buffer deadlock
  • C.3.18 buffer latch
  • C.3.19 buffer read retry
  • C.3.20 checkpoint completed
  • C.3.21 cleanup of aborted processes
  • C.3.22 control file parallel write
  • C.3.23 control file sequential read
  • C.3.24 control file single write
  • C.3.25 cursor: mutex S
  • C.3.26 cursor: mutex X
  • C.3.27 cursor: pin S
  • C.3.28 cursor: pin S wait on X
  • C.3.29 cursor: pin X
  • C.3.30 Data Guard: process clean up
  • C.3.31 Data Guard: process exit
  • C.3.32 Data Guard Broker: single instance
  • C.3.33 db file asynch I/O submit
  • C.3.34 db file parallel read
  • C.3.35 db file parallel write
  • C.3.36 db file scattered read
  • C.3.37 db file sequential read
  • C.3.38 db file single write
  • C.3.39 DFS db file lock
  • C.3.40 DFS lock handle
  • C.3.41 direct path read
  • C.3.42 direct path sync
  • C.3.43 direct path write
  • C.3.44 Disk file operations I/O
  • C.3.45 dispatcher shutdown
  • C.3.46 dispatcher timer
  • C.3.47 duplicate cluster key
  • C.3.48 enq: OW - initialization
  • C.3.49 enq: OW - termination
  • C.3.50 enq: TX - index contention
  • C.3.51 enq: TX - row lock contention
  • C.3.52 enqueue
  • C.3.53 flashback buf free by RVWR
  • C.3.54 flashback logfile sync
  • C.3.55 free buffer waits
  • C.3.56 free global transaction table entry
  • C.3.57 free process state object
  • C.3.58 gc recovery quiesce
  • C.3.59 GCS lock open S
  • C.3.60 GCS lock open X
  • C.3.61 gcs remastering wait for drop pkey
  • C.3.62 global cache busy
  • C.3.63 global cache lock cleanup
  • C.3.64 global cache freelist
  • C.3.65 inactive session
  • C.3.66 inactive transaction branch
  • C.3.67 index block split
  • C.3.68 instance state change
  • C.3.69 io done
  • C.3.70 kcl bg acks
  • C.3.71 ksxr wait for mount shared
  • C.3.72 ktm: instance recovery
  • C.3.73 latch activity
  • C.3.74 latch free
  • C.3.75 latch: redo copy
  • C.3.76 latch: row cache objects
  • C.3.77 library cache load lock
  • C.3.78 library cache lock
  • C.3.79 library cache pin
  • C.3.80 library cache shutdown
  • C.3.81 library cache: mutex X
  • C.3.82 LMON global data update
  • C.3.83 lock manager wait for remote message
  • C.3.84 Log archive I/O
  • C.3.85 log buffer space
  • C.3.86 log file parallel write
  • C.3.87 log file sequential read
  • C.3.88 log file single write
  • C.3.89 log file switch (archiving needed)
  • C.3.90 log file switch (checkpoint incomplete)
  • C.3.91 log file switch (clearing log file)
  • C.3.92 log file switch (private strand flush incomplete)
  • C.3.93 log file switch completion
  • C.3.94 log file sync
  • C.3.95 log switch/archive
  • C.3.96 optimizer stats update retry
  • C.3.97 parallel recovery change buffer free
  • C.3.98 parallel recovery control message reply
  • C.3.99 parallel recovery coord send blocked
  • C.3.100 parallel recovery coord wait for reply
  • C.3.101 parallel recovery coordinator waits for slave cleanup
  • C.3.102 parallel recovery read buffer free
  • C.3.103 parallel recovery slave next change
  • C.3.104 pending global transaction(s)
  • C.3.105 pipe get
  • C.3.106 pipe put
  • C.3.107 PL/SQL lock timer
  • C.3.108 pmon timer
  • C.3.109 prewarm transfer retry
  • C.3.110 prior process spawner to be cleaned up
  • C.3.111 process startup
  • C.3.112 PX Deque wait
  • C.3.113 PX qref latch
  • C.3.114 PX server shutdown
  • C.3.115 PX signal server
  • C.3.116 rdbms ipc message
  • C.3.117 rdbms ipc message block
  • C.3.118 rdbms ipc reply
  • C.3.119 read by other session
  • C.3.120 recovery active instance mapping setup
  • C.3.121 recovery apply pending
  • C.3.122 recovery cancel
  • C.3.123 recovery checkpoint
  • C.3.124 recovery file header update for checkpoint
  • C.3.125 recovery file header update for fuzziness
  • C.3.126 recovery marker apply
  • C.3.127 recovery merge pending
  • C.3.128 recovery metadata latch
  • C.3.129 recovery move influx buffers
  • C.3.130 recovery read
  • C.3.131 recovery receive buffer free
  • C.3.132 recovery remote file verification
  • C.3.133 recovery send buffer free
  • C.3.134 recovery shutdown
  • C.3.135 Redo Transport Attach
  • C.3.136 Redo Transport Close
  • C.3.137 Redo Transport Detach
  • C.3.138 Redo Transport Open
  • C.3.139 Redo Transport Ping
  • C.3.140 Redo Transport Slave Shutdown
  • C.3.141 Redo Transport Slave Startup
  • C.3.142 Redo Writer Remote Sync Complete
  • C.3.143 Redo Write Remote Sync Notify
  • C.3.144 Remote Sync Ping
  • C.3.145 resmgr:become active
  • C.3.146 resmgr:cpu quantum
  • C.3.147 resmgr: I/O rate limit
  • C.3.148 resmgr:pq queued
  • C.3.149 rolling migration: cluster quiesce
  • C.3.150 row cache lock
  • C.3.151 RVWR wait for flashback copy
  • C.3.152 sbtbufinfo
  • C.3.153 sbtgetbuf
  • C.3.154 sbtmapbuf
  • C.3.155 sbtrelbuf
  • C.3.156 scginq AST call
  • C.3.157 SGA: allocation forcing component growth
  • C.3.158 SGA: MMAN sleep for component shrink
  • C.3.159 SGA: sga_target resize
  • C.3.160 Shared IO Pool Memory
  • C.3.161 shared server idle wait
  • C.3.162 single-task message
  • C.3.163 smon timer
  • C.3.164 SQL*Net break/reset to client
  • C.3.165 SQL*Net break/reset to dblink
  • C.3.166 SQL*Net message from client
  • C.3.167 SQL*Net message from dblink
  • C.3.168 SQL*Net message to client
  • C.3.169 SQL*Net message to dblink
  • C.3.170 SQL*Net more data from client
  • C.3.171 SQL*Net more data from dblink
  • C.3.172 SQL*Net more data to client
  • C.3.173 SQL*Net more data to dblink
  • C.3.174 Streams AQ: waiting for messages in the queue
  • C.3.175 switch logfile command
  • C.3.176 SYNC Remote Write
  • C.3.177 TCP Socket (KGAS)
  • C.3.178 timer in sksawat
  • C.3.179 transaction
  • C.3.180 unbound tx
  • C.3.181 undo_retention publish retry
  • C.3.182 undo segment extension
  • C.3.183 undo segment recovery
  • C.3.184 undo segment tx slot
  • C.3.185 utl_file I/O
  • C.3.186 virtual circuit status
  • C.3.187 virtual circuit wait
  • C.3.188 WCR: replay client notify
  • C.3.189 WCR: replay clock
  • C.3.190 WCR: replay lock order
  • C.3.191 WCR: replay paused
  • C.3.192 WCR: Sync context busy
  • C.3.193 WMON goes to sleep
  • C.3.194 write complete waits
  • C.3.195 writes stopped by instance recovery or database suspension

D Oracle Enqueue Names

E Statistics Descriptions

• E.1 Displaying Statistics
• E.2 Statistics Descriptions

F Background Processes

Index