1/2693

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 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 Specifying Values in an Initialization Parameter File
      • 1.3.2.1.1 Rules Governing Initialization Parameter Files
      • 1.3.2.1.2 Using Special Characters in Parameter Values
      • 1.3.2.1.3 Using the Escape Character
      • 1.3.2.1.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 AQ_TM_PROCESSES
• 1.9 ARCHIVE_LAG_TARGET
• 1.10 ASM_DISKGROUPS
• 1.11 ASM_DISKSTRING
• 1.12 ASM_POWER_LIMIT
• 1.13 ASM_PREFERRED_READ_FAILURE_GROUPS
• 1.14 AUDIT_FILE_DEST
• 1.15 AUDIT_SYS_OPERATIONS
• 1.16 AUDIT_SYSLOG_LEVEL
• 1.17 AUDIT_TRAIL
• 1.18 AWR_SNAPSHOT_TIME_OFFSET
• 1.19 BACKGROUND_CORE_DUMP
• 1.20 BACKGROUND_DUMP_DEST
• 1.21 BACKUP_TAPE_IO_SLAVES
• 1.22 BITMAP_MERGE_AREA_SIZE
• 1.23 BLANK_TRIMMING
• 1.24 CIRCUITS
• 1.25 CLIENT_RESULT_CACHE_LAG
• 1.26 CLIENT_RESULT_CACHE_SIZE
• 1.27 CLONEDB
• 1.28 CLUSTER_DATABASE
• 1.29 CLUSTER_DATABASE_INSTANCES
• 1.30 CLUSTER_INTERCONNECTS
• 1.31 COMMIT_LOGGING
• 1.32 COMMIT_POINT_STRENGTH
• 1.33 COMMIT_WAIT
• 1.34 COMMIT_WRITE
• 1.35 COMMON_USER_PREFIX
• 1.36 COMPATIBLE
• 1.37 CONNECTION_BROKERS
• 1.38 CONTROL_FILE_RECORD_KEEP_TIME
• 1.39 CONTROL_FILES
• 1.40 CONTROL_MANAGEMENT_PACK_ACCESS
• 1.41 CORE_DUMP_DEST
• 1.42 CPU_COUNT
• 1.43 CREATE_BITMAP_AREA_SIZE
• 1.44 CREATE_STORED_OUTLINES
• 1.45 CURSOR_BIND_CAPTURE_DESTINATION
• 1.46 CURSOR_SHARING
• 1.47 CURSOR_SPACE_FOR_TIME
• 1.48 DB_nK_CACHE_SIZE
• 1.49 DB_BIG_TABLE_CACHE_PERCENT_TARGET
• 1.50 DB_BLOCK_BUFFERS
• 1.51 DB_BLOCK_CHECKING
• 1.52 DB_BLOCK_CHECKSUM
• 1.53 DB_BLOCK_SIZE
• 1.54 DB_CACHE_ADVICE
• 1.55 DB_CACHE_SIZE
• 1.56 DB_CREATE_FILE_DEST
• 1.57 DB_CREATE_ONLINE_LOG_DEST_n
• 1.58 DB_DOMAIN
• 1.59 DB_FILE_MULTIBLOCK_READ_COUNT
• 1.60 DB_FILE_NAME_CONVERT
• 1.61 DB_FILES
• 1.62 DB_FLASH_CACHE_FILE
• 1.63 DB_FLASH_CACHE_SIZE
• 1.64 DB_FLASHBACK_RETENTION_TARGET
• 1.65 DB_INDEX_COMPRESSION_INHERITANCE
• 1.66 DB_KEEP_CACHE_SIZE
• 1.67 DB_LOST_WRITE_PROTECT
• 1.68 DB_NAME
• 1.69 DB_RECOVERY_FILE_DEST
• 1.70 DB_RECOVERY_FILE_DEST_SIZE
• 1.71 DB_RECYCLE_CACHE_SIZE
• 1.72 DB_SECUREFILE
• 1.73 DB_ULTRA_SAFE
• 1.74 DB_UNIQUE_NAME
• 1.75 DB_UNRECOVERABLE_SCN_TRACKING
• 1.76 DB_WRITER_PROCESSES
• 1.77 DBFIPS_140
• 1.78 DBWR_IO_SLAVES
• 1.79 DDL_LOCK_TIMEOUT
• 1.80 DEFERRED_SEGMENT_CREATION
• 1.81 DG_BROKER_CONFIG_FILEn
• 1.82 DG_BROKER_START
• 1.83 DIAGNOSTIC_DEST
• 1.84 DISK_ASYNCH_IO
• 1.85 DISPATCHERS
• 1.86 DISTRIBUTED_LOCK_TIMEOUT
• 1.87 DML_LOCKS
• 1.88 DNFS_BATCH_SIZE
• 1.89 DST_UPGRADE_INSERT_CONV
• 1.90 ENABLE_DDL_LOGGING
• 1.91 ENABLE_GOLDENGATE_REPLICATION
• 1.92 ENABLE_PLUGGABLE_DATABASE
• 1.93 EVENT
• 1.94 EXAFUSION_ENABLED
• 1.95 FAL_CLIENT
• 1.96 FAL_SERVER
• 1.97 FAST_START_MTTR_TARGET
• 1.98 FAST_START_PARALLEL_ROLLBACK
• 1.99 FILE_MAPPING
• 1.100 FILEIO_NETWORK_ADAPTERS
• 1.101 FILESYSTEMIO_OPTIONS
• 1.102 FIXED_DATE
• 1.103 GCS_SERVER_PROCESSES
• 1.104 GLOBAL_CONTEXT_POOL_SIZE
• 1.105 GLOBAL_NAMES
• 1.106 GLOBAL_TXN_PROCESSES
• 1.107 HASH_AREA_SIZE
• 1.108 HEAT_MAP
• 1.109 HI_SHARED_MEMORY_ADDRESS
• 1.110 HS_AUTOREGISTER
• 1.111 IFILE
• 1.112 INMEMORY_CLAUSE_DEFAULT
• 1.113 INMEMORY_FORCE
• 1.114 INMEMORY_MAX_POPULATE_SERVERS
• 1.115 INMEMORY_QUERY
• 1.116 INMEMORY_SIZE
• 1.117 INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
• 1.118 INSTANCE_GROUPS
• 1.119 INSTANCE_NAME
• 1.120 INSTANCE_NUMBER
• 1.121 INSTANCE_TYPE
• 1.122 JAVA_JIT_ENABLED
• 1.123 JAVA_MAX_SESSIONSPACE_SIZE
• 1.124 JAVA_POOL_SIZE
• 1.125 JAVA_SOFT_SESSIONSPACE_LIMIT
• 1.126 JOB_QUEUE_PROCESSES
• 1.127 LARGE_POOL_SIZE
• 1.128 LDAP_DIRECTORY_ACCESS
• 1.129 LDAP_DIRECTORY_SYSAUTH
• 1.130 LICENSE_MAX_SESSIONS
• 1.131 LICENSE_MAX_USERS
• 1.132 LICENSE_SESSIONS_WARNING
• 1.133 LISTENER_NETWORKS
• 1.134 LOCAL_LISTENER
• 1.135 LOCK_NAME_SPACE
• 1.136 LOCK_SGA
• 1.137 LOG_ARCHIVE_CONFIG
• 1.138 LOG_ARCHIVE_DEST
• 1.139 LOG_ARCHIVE_DEST_n
• 1.140 LOG_ARCHIVE_DEST_STATE_n
• 1.141 LOG_ARCHIVE_DUPLEX_DEST
• 1.142 LOG_ARCHIVE_FORMAT
• 1.143 LOG_ARCHIVE_MAX_PROCESSES
• 1.144 LOG_ARCHIVE_MIN_SUCCEED_DEST
• 1.145 LOG_ARCHIVE_TRACE
• 1.146 LOG_BUFFER
• 1.147 LOG_CHECKPOINT_INTERVAL
• 1.148 LOG_CHECKPOINT_TIMEOUT
• 1.149 LOG_CHECKPOINTS_TO_ALERT
• 1.150 LOG_FILE_NAME_CONVERT
• 1.151 MAX_DISPATCHERS
• 1.152 MAX_DUMP_FILE_SIZE
• 1.153 MAX_ENABLED_ROLES
• 1.154 MAX_SHARED_SERVERS
• 1.155 MAX_STRING_SIZE
• 1.156 MEMORY_MAX_TARGET
• 1.157 MEMORY_TARGET
• 1.158 NLS_CALENDAR
• 1.159 NLS_COMP
• 1.160 NLS_CURRENCY
• 1.161 NLS_DATE_FORMAT
• 1.162 NLS_DATE_LANGUAGE
• 1.163 NLS_DUAL_CURRENCY
• 1.164 NLS_ISO_CURRENCY
• 1.165 NLS_LANGUAGE
• 1.166 NLS_LENGTH_SEMANTICS
• 1.167 NLS_NCHAR_CONV_EXCP
• 1.168 NLS_NUMERIC_CHARACTERS
• 1.169 NLS_SORT
• 1.170 NLS_TERRITORY
• 1.171 NLS_TIMESTAMP_FORMAT
• 1.172 NLS_TIMESTAMP_TZ_FORMAT
• 1.173 NONCDB_COMPATIBLE
• 1.174 O7_DICTIONARY_ACCESSIBILITY
• 1.175 OBJECT_CACHE_MAX_SIZE_PERCENT
• 1.176 OBJECT_CACHE_OPTIMAL_SIZE
• 1.177 OLAP_PAGE_POOL_SIZE
• 1.178 OPEN_CURSORS
• 1.179 OPEN_LINKS
• 1.180 OPEN_LINKS_PER_INSTANCE
• 1.181 OPTIMIZER_ADAPTIVE_FEATURES
• 1.182 OPTIMIZER_ADAPTIVE_REPORTING_ONLY
• 1.183 OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
• 1.184 OPTIMIZER_DYNAMIC_SAMPLING
• 1.185 OPTIMIZER_FEATURES_ENABLE
• 1.186 OPTIMIZER_INDEX_CACHING
• 1.187 OPTIMIZER_INDEX_COST_ADJ
• 1.188 OPTIMIZER_INMEMORY_AWARE
• 1.189 OPTIMIZER_MODE
• 1.190 OPTIMIZER_SECURE_VIEW_MERGING
• 1.191 OPTIMIZER_USE_INVISIBLE_INDEXES
• 1.192 OPTIMIZER_USE_PENDING_STATISTICS
• 1.193 OPTIMIZER_USE_SQL_PLAN_BASELINES
• 1.194 OS_AUTHENT_PREFIX
• 1.195 OS_ROLES
• 1.196 PARALLEL_ADAPTIVE_MULTI_USER
• 1.197 PARALLEL_AUTOMATIC_TUNING
• 1.198 PARALLEL_DEGREE_LIMIT
• 1.199 PARALLEL_DEGREE_POLICY
• 1.200 PARALLEL_EXECUTION_MESSAGE_SIZE
• 1.201 PARALLEL_FORCE_LOCAL
• 1.202 PARALLEL_INSTANCE_GROUP
• 1.203 PARALLEL_IO_CAP_ENABLED
• 1.204 PARALLEL_MAX_SERVERS
• 1.205 PARALLEL_MIN_PERCENT
• 1.206 PARALLEL_MIN_SERVERS
• 1.207 PARALLEL_MIN_TIME_THRESHOLD
• 1.208 PARALLEL_SERVERS_TARGET
• 1.209 PARALLEL_THREADS_PER_CPU
• 1.210 PDB_FILE_NAME_CONVERT
• 1.211 PERMIT_92_WRAP_FORMAT
• 1.212 PGA_AGGREGATE_LIMIT
• 1.213 PGA_AGGREGATE_TARGET
• 1.214 PLSCOPE_SETTINGS
• 1.215 PLSQL_CCFLAGS
• 1.216 PLSQL_CODE_TYPE
• 1.217 PLSQL_DEBUG
• 1.218 PLSQL_OPTIMIZE_LEVEL
• 1.219 PLSQL_V2_COMPATIBILITY
• 1.220 PLSQL_WARNINGS
• 1.221 PRE_PAGE_SGA
• 1.222 PROCESSES
• 1.223 PROCESSOR_GROUP_NAME
• 1.224 QUERY_REWRITE_ENABLED
• 1.225 QUERY_REWRITE_INTEGRITY
• 1.226 RDBMS_SERVER_DN
• 1.227 READ_ONLY_OPEN_DELAYED
• 1.228 RECOVERY_PARALLELISM
• 1.229 RECYCLEBIN
• 1.230 REDO_TRANSPORT_USER
• 1.231 REMOTE_DEPENDENCIES_MODE
• 1.232 REMOTE_LISTENER
• 1.233 REMOTE_LOGIN_PASSWORDFILE
• 1.234 REMOTE_OS_AUTHENT
• 1.235 REMOTE_OS_ROLES
• 1.236 REPLICATION_DEPENDENCY_TRACKING
• 1.237 RESOURCE_LIMIT
• 1.238 RESOURCE_MANAGER_CPU_ALLOCATION
• 1.239 RESOURCE_MANAGER_PLAN
• 1.240 RESULT_CACHE_MAX_RESULT
• 1.241 RESULT_CACHE_MAX_SIZE
• 1.242 RESULT_CACHE_MODE
• 1.243 RESULT_CACHE_REMOTE_EXPIRATION
• 1.244 RESUMABLE_TIMEOUT
• 1.245 ROLLBACK_SEGMENTS
• 1.246 SEC_CASE_SENSITIVE_LOGON
• 1.247 SEC_MAX_FAILED_LOGIN_ATTEMPTS
• 1.248 SEC_PROTOCOL_ERROR_FURTHER_ACTION
• 1.249 SEC_PROTOCOL_ERROR_TRACE_ACTION
• 1.250 SEC_RETURN_SERVER_RELEASE_BANNER
• 1.251 SERIAL_REUSE
• 1.252 SERVICE_NAMES
• 1.253 SESSION_CACHED_CURSORS
• 1.254 SESSION_MAX_OPEN_FILES
• 1.255 SESSIONS
• 1.256 SGA_MAX_SIZE
• 1.257 SGA_TARGET
• 1.258 SHADOW_CORE_DUMP
• 1.259 SHARED_MEMORY_ADDRESS
• 1.260 SHARED_POOL_RESERVED_SIZE
• 1.261 SHARED_POOL_SIZE
• 1.262 SHARED_SERVER_SESSIONS
• 1.263 SHARED_SERVERS
• 1.264 SKIP_UNUSABLE_INDEXES
• 1.265 SMTP_OUT_SERVER
• 1.266 SORT_AREA_RETAINED_SIZE
• 1.267 SORT_AREA_SIZE
• 1.268 SPATIAL_VECTOR_ACCELERATION
• 1.269 SPFILE
• 1.270 SQL_TRACE
• 1.271 SQL92_SECURITY
• 1.272 SQLTUNE_CATEGORY
• 1.273 STANDBY_ARCHIVE_DEST
• 1.274 STANDBY_FILE_MANAGEMENT
• 1.275 STAR_TRANSFORMATION_ENABLED
• 1.276 STATISTICS_LEVEL
• 1.277 STREAMS_POOL_SIZE
• 1.278 TAPE_ASYNCH_IO
• 1.279 TEMP_UNDO_ENABLED
• 1.280 THREAD
• 1.281 THREADED_EXECUTION
• 1.282 TIMED_OS_STATISTICS
• 1.283 TIMED_STATISTICS
• 1.284 TRACE_ENABLED
• 1.285 TRACEFILE_IDENTIFIER
• 1.286 TRANSACTIONS
• 1.287 TRANSACTIONS_PER_ROLLBACK_SEGMENT
• 1.288 UNDO_MANAGEMENT
• 1.289 UNDO_RETENTION
• 1.290 UNDO_TABLESPACE
• 1.291 UNIFIED_AUDIT_SGA_QUEUE_SIZE
• 1.292 USE_DEDICATED_BROKER
• 1.293 USE_INDIRECT_DATA_BUFFERS
• 1.294 USE_LARGE_PAGES
• 1.295 USER_DUMP_DEST
• 1.296 UTL_FILE_DIR
• 1.297 WORKAREA_SIZE_POLICY
• 1.298 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 Oracle Database Real Application Security Views
• 2.4 Oracle Label Security Views
• 2.5 Oracle Database Vault Views
• 2.6 Oracle Replication Views
• 2.7 Oracle Workspace Manager Views
• 2.8 Recovery Catalog Views
• 2.9 Static Data Dictionary View Descriptions
• 2.10 ALL_ALL_TABLES
• 2.11 ALL_APPLY
• 2.12 ALL_APPLY_CHANGE_HANDLERS
• 2.13 ALL_APPLY_CONFLICT_COLUMNS
• 2.14 ALL_APPLY_DML_HANDLERS
• 2.15 ALL_APPLY_ENQUEUE
• 2.16 ALL_APPLY_ERROR
• 2.17 ALL_APPLY_ERROR_MESSAGES
• 2.18 ALL_APPLY_EXECUTE
• 2.19 ALL_APPLY_INSTANTIATED_GLOBAL
• 2.20 ALL_APPLY_INSTANTIATED_OBJECTS
• 2.21 ALL_APPLY_INSTANTIATED_SCHEMAS
• 2.22 ALL_APPLY_KEY_COLUMNS
• 2.23 ALL_APPLY_PARAMETERS
• 2.24 ALL_APPLY_PROGRESS
• 2.25 ALL_APPLY_TABLE_COLUMNS
• 2.26 ALL_ARGUMENTS
• 2.27 ALL_ASSEMBLIES
• 2.28 ALL_ASSOCIATIONS
• 2.29 ALL_ATTRIBUTE_TRANSFORMATIONS
• 2.30 ALL_AUDIT_POLICIES
• 2.31 ALL_AUDIT_POLICY_COLUMNS
• 2.32 ALL_AW_PS
• 2.33 ALL_AWS
• 2.34 ALL_BASE_TABLE_MVIEWS
• 2.35 ALL_CAPTURE
• 2.36 ALL_CAPTURE_EXTRA_ATTRIBUTES
• 2.37 ALL_CAPTURE_PARAMETERS
• 2.38 ALL_CAPTURE_PREPARED_DATABASE
• 2.39 ALL_CAPTURE_PREPARED_SCHEMAS
• 2.40 ALL_CAPTURE_PREPARED_TABLES
• 2.41 ALL_CATALOG
• 2.42 ALL_CLUSTER_HASH_EXPRESSIONS
• 2.43 ALL_CLUSTERING_DIMENSIONS
• 2.44 ALL_CLUSTERING_JOINS
• 2.45 ALL_CLUSTERING_KEYS
• 2.46 ALL_CLUSTERING_TABLES
• 2.47 ALL_CLUSTERS
• 2.48 ALL_CODE_ROLE_PRIVS
• 2.49 ALL_COL_COMMENTS
• 2.50 ALL_COL_PENDING_STATS
• 2.51 ALL_COL_PRIVS
• 2.52 ALL_COL_PRIVS_MADE
• 2.53 ALL_COL_PRIVS_RECD
• 2.54 ALL_COLL_TYPES
• 2.55 ALL_CONS_COLUMNS
• 2.56 ALL_CONS_OBJ_COLUMNS
• 2.57 ALL_CONSTRAINTS
• 2.58 ALL_CONTEXT
• 2.59 ALL_CREDENTIALS
• 2.60 ALL_CUBE_ATTR_VISIBILITY
• 2.61 ALL_CUBE_ATTRIBUTES
• 2.62 ALL_CUBE_BUILD_PROCESSES
• 2.63 ALL_CUBE_CALCULATED_MEMBERS
• 2.64 ALL_CUBE_DIM_LEVELS
• 2.65 ALL_CUBE_DIM_MODELS
• 2.66 ALL_CUBE_DIM_VIEW_COLUMNS
• 2.67 ALL_CUBE_DIM_VIEWS
• 2.68 ALL_CUBE_DIMENSIONALITY
• 2.69 ALL_CUBE_DIMENSIONS
• 2.70 ALL_CUBE_HIER_LEVELS
• 2.71 ALL_CUBE_HIER_VIEW_COLUMNS
• 2.72 ALL_CUBE_HIER_VIEWS
• 2.73 ALL_CUBE_HIERARCHIES
• 2.74 ALL_CUBE_MEASURES
• 2.75 ALL_CUBE_NAMED_BUILD_SPECS
• 2.76 ALL_CUBE_SUB_PARTITION_LEVELS
• 2.77 ALL_CUBE_VIEW_COLUMNS
• 2.78 ALL_CUBE_VIEWS
• 2.79 ALL_CUBES
• 2.80 ALL_DB_LINKS
• 2.81 ALL_DEF_AUDIT_OPTS
• 2.82 ALL_DEPENDENCIES
• 2.83 ALL_DEQUEUE_QUEUES
• 2.84 ALL_DIM_ATTRIBUTES
• 2.85 ALL_DIM_CHILD_OF
• 2.86 ALL_DIM_HIERARCHIES
• 2.87 ALL_DIM_JOIN_KEY
• 2.88 ALL_DIM_LEVEL_KEY
• 2.89 ALL_DIM_LEVELS
• 2.90 ALL_DIMENSIONS
• 2.91 ALL_DIRECTORIES
• 2.92 ALL_EDITION_COMMENTS
• 2.93 ALL_EDITIONING_VIEW_COLS
• 2.94 ALL_EDITIONING_VIEW_COLS_AE
• 2.95 ALL_EDITIONING_VIEWS
• 2.96 ALL_EDITIONING_VIEWS_AE
• 2.97 ALL_EDITIONS
• 2.98 ALL_ENCRYPTED_COLUMNS
• 2.99 ALL_ERROR_TRANSLATIONS
• 2.100 ALL_ERRORS
• 2.101 ALL_ERRORS_AE
• 2.102 ALL_EVALUATION_CONTEXT_TABLES
• 2.103 ALL_EVALUATION_CONTEXT_VARS
• 2.104 ALL_EVALUATION_CONTEXTS
• 2.105 ALL_EXTERNAL_LOCATIONS
• 2.106 ALL_EXTERNAL_TABLES
• 2.107 ALL_FILE_GROUP_EXPORT_INFO
• 2.108 ALL_FILE_GROUP_FILES
• 2.109 ALL_FILE_GROUP_TABLES
• 2.110 ALL_FILE_GROUP_TABLESPACES
• 2.111 ALL_FILE_GROUP_VERSIONS
• 2.112 ALL_FILE_GROUPS
• 2.113 ALL_GG_INBOUND_PROGRESS
• 2.114 ALL_GOLDENGATE_INBOUND
• 2.115 ALL_GOLDENGATE_PRIVILEGES
• 2.116 ALL_GOLDENGATE_RULES
• 2.117 ALL_HEAT_MAP_SEG_HISTOGRAM
• 2.118 ALL_HEAT_MAP_SEGMENT
• 2.119 ALL_HISTOGRAMS
• 2.120 ALL_IDENTIFIERS
• 2.121 ALL_IND_COLUMNS
• 2.122 ALL_IND_EXPRESSIONS
• 2.123 ALL_IND_PARTITIONS
• 2.124 ALL_IND_PENDING_STATS
• 2.125 ALL_IND_STATISTICS
• 2.126 ALL_IND_SUBPARTITIONS
• 2.127 ALL_INDEXES
• 2.128 ALL_INDEXTYPE_ARRAYTYPES
• 2.129 ALL_INDEXTYPE_COMMENTS
• 2.130 ALL_INDEXTYPE_OPERATORS
• 2.131 ALL_INDEXTYPES
• 2.132 ALL_INTERNAL_TRIGGERS
• 2.133 ALL_JAVA_ARGUMENTS
• 2.134 ALL_JAVA_CLASSES
• 2.135 ALL_JAVA_COMPILER_OPTIONS
• 2.136 ALL_JAVA_DERIVATIONS
• 2.137 ALL_JAVA_FIELDS
• 2.138 ALL_JAVA_IMPLEMENTS
• 2.139 ALL_JAVA_INNERS
• 2.140 ALL_JAVA_LAYOUTS
• 2.141 ALL_JAVA_METHODS
• 2.142 ALL_JAVA_NCOMPS
• 2.143 ALL_JAVA_RESOLVERS
• 2.144 ALL_JAVA_THROWS
• 2.145 ALL_JOBS
• 2.146 ALL_JOIN_IND_COLUMNS
• 2.147 ALL_JSON_COLUMNS
• 2.148 ALL_LIBRARIES
• 2.149 ALL_LOB_PARTITIONS
• 2.150 ALL_LOB_SUBPARTITIONS
• 2.151 ALL_LOB_TEMPLATES
• 2.152 ALL_LOBS
• 2.153 ALL_LOG_GROUP_COLUMNS
• 2.154 ALL_LOG_GROUPS
• 2.155 ALL_MEASURE_FOLDER_CONTENTS
• 2.156 ALL_MEASURE_FOLDER_SUBFOLDERS
• 2.157 ALL_MEASURE_FOLDERS
• 2.158 ALL_METADATA_PROPERTIES
• 2.159 ALL_METHOD_PARAMS
• 2.160 ALL_METHOD_RESULTS
• 2.161 ALL_MINING_MODEL_ATTRIBUTES
• 2.162 ALL_MINING_MODEL_SETTINGS
• 2.163 ALL_MINING_MODELS
• 2.164 ALL_MVIEW_AGGREGATES
• 2.165 ALL_MVIEW_ANALYSIS
• 2.166 ALL_MVIEW_COMMENTS
• 2.167 ALL_MVIEW_DETAIL_PARTITION
• 2.168 ALL_MVIEW_DETAIL_RELATIONS
• 2.169 ALL_MVIEW_DETAIL_SUBPARTITION
• 2.170 ALL_MVIEW_JOINS
• 2.171 ALL_MVIEW_KEYS
• 2.172 ALL_MVIEW_LOGS
• 2.173 ALL_MVIEW_REFRESH_TIMES
• 2.174 ALL_MVIEWS
• 2.175 ALL_NESTED_TABLE_COLS
• 2.176 ALL_NESTED_TABLES
• 2.177 ALL_OBJ_COLATTRS
• 2.178 ALL_OBJECT_TABLES
• 2.179 ALL_OBJECTS
• 2.180 ALL_OBJECTS_AE
• 2.181 ALL_OPANCILLARY
• 2.182 ALL_OPARGUMENTS
• 2.183 ALL_OPBINDINGS
• 2.184 ALL_OPERATOR_COMMENTS
• 2.185 ALL_OPERATORS
• 2.186 ALL_OUTLINE_HINTS
• 2.187 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_REWRITE_EQUIVALENCES
• 3.31 ALL_RULE_SET_RULES
• 3.32 ALL_RULE_SETS
• 3.33 ALL_RULES
• 3.34 ALL_SCHEDULER_CHAIN_RULES
• 3.35 ALL_SCHEDULER_CHAIN_STEPS
• 3.36 ALL_SCHEDULER_CHAINS
• 3.37 ALL_SCHEDULER_CREDENTIALS
• 3.38 ALL_SCHEDULER_DB_DESTS
• 3.39 ALL_SCHEDULER_DESTS
• 3.40 ALL_SCHEDULER_EXTERNAL_DESTS
• 3.41 ALL_SCHEDULER_FILE_WATCHERS
• 3.42 ALL_SCHEDULER_GLOBAL_ATTRIBUTE
• 3.43 ALL_SCHEDULER_GROUP_MEMBERS
• 3.44 ALL_SCHEDULER_GROUPS
• 3.45 ALL_SCHEDULER_JOB_ARGS
• 3.46 ALL_SCHEDULER_JOB_CLASSES
• 3.47 ALL_SCHEDULER_JOB_DESTS
• 3.48 ALL_SCHEDULER_JOB_LOG
• 3.49 ALL_SCHEDULER_JOB_RUN_DETAILS
• 3.50 ALL_SCHEDULER_JOBS
• 3.51 ALL_SCHEDULER_NOTIFICATIONS
• 3.52 ALL_SCHEDULER_PROGRAM_ARGS
• 3.53 ALL_SCHEDULER_PROGRAMS
• 3.54 ALL_SCHEDULER_REMOTE_DATABASES
• 3.55 ALL_SCHEDULER_REMOTE_JOBSTATE
• 3.56 ALL_SCHEDULER_RUNNING_CHAINS
• 3.57 ALL_SCHEDULER_RUNNING_JOBS
• 3.58 ALL_SCHEDULER_SCHEDULES
• 3.59 ALL_SCHEDULER_WINDOW_DETAILS
• 3.60 ALL_SCHEDULER_WINDOW_GROUPS
• 3.61 ALL_SCHEDULER_WINDOW_LOG
• 3.62 ALL_SCHEDULER_WINDOWS
• 3.63 ALL_SCHEDULER_WINGROUP_MEMBERS
• 3.64 ALL_SEC_RELEVANT_COLS
• 3.65 ALL_SECONDARY_OBJECTS
• 3.66 ALL_SEQUENCES
• 3.67 ALL_SERVICES
• 3.68 ALL_SOURCE
• 3.69 ALL_SOURCE_AE
• 3.70 ALL_SQL_TRANSLATION_PROFILES
• 3.71 ALL_SQL_TRANSLATIONS
• 3.72 ALL_SQLJ_TYPE_ATTRS
• 3.73 ALL_SQLJ_TYPE_METHODS
• 3.74 ALL_SQLJ_TYPES
• 3.75 ALL_SQLSET
• 3.76 ALL_SQLSET_BINDS
• 3.77 ALL_SQLSET_PLANS
• 3.78 ALL_SQLSET_REFERENCES
• 3.79 ALL_SQLSET_STATEMENTS
• 3.80 ALL_STAT_EXTENSIONS
• 3.81 ALL_STORED_SETTINGS
• 3.82 ALL_STREAMS_COLUMNS
• 3.83 ALL_STREAMS_GLOBAL_RULES
• 3.84 ALL_STREAMS_MESSAGE_CONSUMERS
• 3.85 ALL_STREAMS_MESSAGE_RULES
• 3.86 ALL_STREAMS_NEWLY_SUPPORTED
• 3.87 ALL_STREAMS_RULES
• 3.88 ALL_STREAMS_SCHEMA_RULES
• 3.89 ALL_STREAMS_TABLE_RULES
• 3.90 ALL_STREAMS_TRANSFORM_FUNCTION
• 3.91 ALL_STREAMS_UNSUPPORTED
• 3.92 ALL_SUBPART_COL_STATISTICS
• 3.93 ALL_SUBPART_HISTOGRAMS
• 3.94 ALL_SUBPART_KEY_COLUMNS
• 3.95 ALL_SUBPARTITION_TEMPLATES
• 3.96 ALL_SUMDELTA
• 3.97 ALL_SYNC_CAPTURE
• 3.98 ALL_SYNC_CAPTURE_PREPARED_TABS
• 3.99 ALL_SYNC_CAPTURE_TABLES
• 3.100 ALL_SYNONYMS
• 3.101 ALL_TAB_COL_STATISTICS
• 3.102 ALL_TAB_COLS
• 3.103 ALL_TAB_COLUMNS
• 3.104 ALL_TAB_COMMENTS
• 3.105 ALL_TAB_HISTGRM_PENDING_STATS
• 3.106 ALL_TAB_HISTOGRAMS
• 3.107 ALL_TAB_IDENTITY_COLS
• 3.108 ALL_TAB_MODIFICATIONS
• 3.109 ALL_TAB_PARTITIONS
• 3.110 ALL_TAB_PENDING_STATS
• 3.111 ALL_TAB_PRIVS
• 3.112 ALL_TAB_PRIVS_MADE
• 3.113 ALL_TAB_PRIVS_RECD
• 3.114 ALL_TAB_STAT_PREFS
• 3.115 ALL_TAB_STATISTICS
• 3.116 ALL_TAB_STATS_HISTORY
• 3.117 ALL_TAB_SUBPARTITIONS
• 3.118 ALL_TABLES
• 3.119 ALL_TRANSFORMATIONS
• 3.120 ALL_TRIGGER_COLS
• 3.121 ALL_TRIGGER_ORDERING
• 3.122 ALL_TRIGGERS
• 3.123 ALL_TSTZ_TAB_COLS
• 3.124 ALL_TSTZ_TABLES
• 3.125 ALL_TYPE_ATTRS
• 3.126 ALL_TYPE_METHODS
• 3.127 ALL_TYPE_VERSIONS
• 3.128 ALL_TYPES
• 3.129 ALL_UNUSED_COL_TABS
• 3.130 ALL_UPDATABLE_COLUMNS
• 3.131 ALL_USERS
• 3.132 ALL_USTATS
• 3.133 ALL_VARRAYS
• 3.134 ALL_VIEWS
• 3.135 ALL_VIEWS_AE
• 3.136 ALL_WARNING_SETTINGS
• 3.137 ALL_XML_INDEXES
• 3.138 ALL_XML_NESTED_TABLES
• 3.139 ALL_XML_OUT_OF_LINE_TABLES
• 3.140 ALL_XML_SCHEMA_ATTRIBUTES
• 3.141 ALL_XML_SCHEMA_COMPLEX_TYPES
• 3.142 ALL_XML_SCHEMA_ELEMENTS
• 3.143 ALL_XML_SCHEMA_NAMESPACES
• 3.144 ALL_XML_SCHEMA_SIMPLE_TYPES
• 3.145 ALL_XML_SCHEMA_SUBSTGRP_HEAD
• 3.146 ALL_XML_SCHEMA_SUBSTGRP_MBRS
• 3.147 ALL_XML_SCHEMAS
• 3.148 ALL_XML_TAB_COLS
• 3.149 ALL_XML_TABLES
• 3.150 ALL_XML_VIEW_COLS
• 3.151 ALL_XML_VIEWS
• 3.152 ALL_XSTREAM_ADMINISTRATOR
• 3.153 ALL_XSTREAM_INBOUND
• 3.154 ALL_XSTREAM_INBOUND_PROGRESS
• 3.155 ALL_XSTREAM_OUT_SUPPORT_MODE
• 3.156 ALL_XSTREAM_OUTBOUND
• 3.157 ALL_XSTREAM_OUTBOUND_PROGRESS
• 3.158 ALL_XSTREAM_RULES
• 3.159 ALL_XSTREAM_TRANSFORMATIONS
• 3.160 ALL_ZONEMAP_MEASURES
• 3.161 ALL_ZONEMAPS
• 3.162 AUDIT_ACTIONS
• 3.163 AUDIT_UNIFIED_CONTEXTS
• 3.164 AUDIT_UNIFIED_ENABLED_POLICIES
• 3.165 AUDIT_UNIFIED_POLICIES
• 3.166 AUDIT_UNIFIED_POLICY_COMMENTS
• 3.167 AUDITABLE_SYSTEM_ACTIONS
• 3.168 CAT
• 3.169 CATALOG
• 3.170 CHAINED_ROWS
• 3.171 CLIENT_RESULT_CACHE_STATS$
• 3.172 CLU
• 3.173 COL
• 3.174 COLS
• 3.175 DATABASE_EXPORT_OBJECTS
• 3.176 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_APPLICATION_ROLES
• 4.49 DBA_APPLY
• 4.50 DBA_APPLY_CHANGE_HANDLERS
• 4.51 DBA_APPLY_CONFLICT_COLUMNS
• 4.52 DBA_APPLY_DML_HANDLERS
• 4.53 DBA_APPLY_ENQUEUE
• 4.54 DBA_APPLY_ERROR
• 4.55 DBA_APPLY_ERROR_MESSAGES
• 4.56 DBA_APPLY_EXECUTE
• 4.57 DBA_APPLY_INSTANTIATED_GLOBAL
• 4.58 DBA_APPLY_INSTANTIATED_OBJECTS
• 4.59 DBA_APPLY_INSTANTIATED_SCHEMAS
• 4.60 DBA_APPLY_KEY_COLUMNS
• 4.61 DBA_APPLY_OBJECT_DEPENDENCIES
• 4.62 DBA_APPLY_PARAMETERS
• 4.63 DBA_APPLY_PROGRESS
• 4.64 DBA_APPLY_SPILL_TXN
• 4.65 DBA_APPLY_TABLE_COLUMNS
• 4.66 DBA_APPLY_VALUE_DEPENDENCIES
• 4.67 DBA_AQ_AGENT_PRIVS
• 4.68 DBA_AQ_AGENTS
• 4.69 DBA_ARGUMENTS
• 4.70 DBA_ASSEMBLIES
• 4.71 DBA_ASSOCIATIONS
• 4.72 DBA_ATTRIBUTE_TRANSFORMATIONS
• 4.73 DBA_AUDIT_EXISTS
• 4.74 DBA_AUDIT_MGMT_CLEAN_EVENTS
• 4.75 DBA_AUDIT_MGMT_CLEANUP_JOBS
• 4.76 DBA_AUDIT_MGMT_CONFIG_PARAMS
• 4.77 DBA_AUDIT_MGMT_LAST_ARCH_TS
• 4.78 DBA_AUDIT_OBJECT
• 4.79 DBA_AUDIT_POLICIES
• 4.80 DBA_AUDIT_POLICY_COLUMNS
• 4.81 DBA_AUDIT_SESSION
• 4.82 DBA_AUDIT_STATEMENT
• 4.83 DBA_AUDIT_TRAIL
• 4.84 DBA_AUTO_SEGADV_CTL
• 4.85 DBA_AUTO_SEGADV_SUMMARY
• 4.86 DBA_AUTOTASK_CLIENT
• 4.87 DBA_AUTOTASK_CLIENT_HISTORY
• 4.88 DBA_AUTOTASK_CLIENT_JOB
• 4.89 DBA_AUTOTASK_JOB_HISTORY
• 4.90 DBA_AUTOTASK_OPERATION
• 4.91 DBA_AUTOTASK_SCHEDULE
• 4.92 DBA_AUTOTASK_STATUS
• 4.93 DBA_AUTOTASK_TASK
• 4.94 DBA_AUTOTASK_WINDOW_CLIENTS
• 4.95 DBA_AUTOTASK_WINDOW_HISTORY
• 4.96 DBA_AW_PS
• 4.97 DBA_AWS
• 4.98 DBA_BASE_TABLE_MVIEWS
• 4.99 DBA_BLOCKERS
• 4.100 DBA_CAPTURE
• 4.101 DBA_CAPTURE_EXTRA_ATTRIBUTES
• 4.102 DBA_CAPTURE_PARAMETERS
• 4.103 DBA_CAPTURE_PREPARED_DATABASE
• 4.104 DBA_CAPTURE_PREPARED_SCHEMAS
• 4.105 DBA_CAPTURE_PREPARED_TABLES
• 4.106 DBA_CATALOG
• 4.107 DBA_CDB_RSRC_PLAN_DIRECTIVES
• 4.108 DBA_CDB_RSRC_PLANS
• 4.109 DBA_CHANGE_NOTIFICATION_REGS
• 4.110 DBA_CLU_COLUMNS
• 4.111 DBA_CLUSTER_HASH_EXPRESSIONS
• 4.112 DBA_CLUSTERING_DIMENSIONS
• 4.113 DBA_CLUSTERING_JOINS
• 4.114 DBA_CLUSTERING_KEYS
• 4.115 DBA_CLUSTERING_TABLES
• 4.116 DBA_CLUSTERS
• 4.117 DBA_CODE_ROLE_PRIVS
• 4.118 DBA_COL_COMMENTS
• 4.119 DBA_COL_PENDING_STATS
• 4.120 DBA_COL_PRIVS
• 4.121 DBA_COLL_TYPES
• 4.122 DBA_COMMON_AUDIT_TRAIL
• 4.123 DBA_COMPARISON
• 4.124 DBA_COMPARISON_COLUMNS
• 4.125 DBA_COMPARISON_ROW_DIF
• 4.126 DBA_COMPARISON_SCAN
• 4.127 DBA_COMPARISON_SCAN_VALUES
• 4.128 DBA_CONNECT_ROLE_GRANTEES
• 4.129 DBA_CONS_COLUMNS
• 4.130 DBA_CONS_OBJ_COLUMNS
• 4.131 DBA_CONSTRAINTS
• 4.132 DBA_CONTAINER_DATA
• 4.133 DBA_CONTEXT
• 4.134 DBA_CPOOL_INFO
• 4.135 DBA_CPU_USAGE_STATISTICS
• 4.136 DBA_CQ_NOTIFICATION_QUERIES
• 4.137 DBA_CREDENTIALS
• 4.138 DBA_CUBE_ATTR_VISIBILITY
• 4.139 DBA_CUBE_ATTRIBUTES
• 4.140 DBA_CUBE_BUILD_PROCESSES
• 4.141 DBA_CUBE_CALCULATED_MEMBERS
• 4.142 DBA_CUBE_DIM_LEVELS
• 4.143 DBA_CUBE_DIM_MODELS
• 4.144 DBA_CUBE_DIM_VIEW_COLUMNS
• 4.145 DBA_CUBE_DIM_VIEWS
• 4.146 DBA_CUBE_DIMENSIONALITY
• 4.147 DBA_CUBE_DIMENSIONS
• 4.148 DBA_CUBE_HIER_LEVELS
• 4.149 DBA_CUBE_HIER_VIEW_COLUMNS
• 4.150 DBA_CUBE_HIER_VIEWS
• 4.151 DBA_CUBE_HIERARCHIES
• 4.152 DBA_CUBE_MEASURES
• 4.153 DBA_CUBE_NAMED_BUILD_SPECS
• 4.154 DBA_CUBE_SUB_PARTITION_LEVELS
• 4.155 DBA_CUBE_VIEW_COLUMNS
• 4.156 DBA_CUBE_VIEWS
• 4.157 DBA_CUBES
• 4.158 DBA_DATA_FILES
• 4.159 DBA_DATAPUMP_JOBS
• 4.160 DBA_DATAPUMP_SESSIONS
• 4.161 DBA_DB_LINKS
• 4.162 DBA_DBFS_HS
• 4.163 DBA_DBFS_HS_COMMANDS
• 4.164 DBA_DBFS_HS_FIXED_PROPERTIES
• 4.165 DBA_DBFS_HS_PROPERTIES
• 4.166 DBA_DDL_LOCKS
• 4.167 DBA_DEPENDENCIES
• 4.168 DBA_DIGEST_VERIFIERS
• 4.169 DBA_DIM_ATTRIBUTES
• 4.170 DBA_DIM_CHILD_OF
• 4.171 DBA_DIM_HIERARCHIES
• 4.172 DBA_DIM_JOIN_KEY
• 4.173 DBA_DIM_LEVEL_KEY
• 4.174 DBA_DIM_LEVELS
• 4.175 DBA_DIMENSIONS
• 4.176 DBA_DIRECTORIES
• 4.177 DBA_DISCOVERY_SOURCE
• 4.178 DBA_DML_LOCKS
• 4.179 DBA_DMT_FREE_SPACE
• 4.180 DBA_DMT_USED_EXTENTS
• 4.181 DBA_EDITION_COMMENTS
• 4.182 DBA_EDITIONED_TYPES
• 4.183 DBA_EDITIONING_VIEW_COLS
• 4.184 DBA_EDITIONING_VIEW_COLS_AE
• 4.185 DBA_EDITIONING_VIEWS
• 4.186 DBA_EDITIONING_VIEWS_AE
• 4.187 DBA_EDITIONS
• 4.188 DBA_ENABLED_AGGREGATIONS
• 4.189 DBA_ENABLED_TRACES
• 4.190 DBA_ENCRYPTED_COLUMNS
• 4.191 DBA_EPG_DAD_AUTHORIZATION
• 4.192 DBA_ERROR_TRANSLATIONS
• 4.193 DBA_ERRORS
• 4.194 DBA_ERRORS_AE
• 4.195 DBA_EVALUATION_CONTEXT_TABLES
• 4.196 DBA_EVALUATION_CONTEXT_VARS
• 4.197 DBA_EVALUATION_CONTEXTS
• 4.198 DBA_EXP_FILES
• 4.199 DBA_EXP_OBJECTS
• 4.200 DBA_EXP_VERSION
• 4.201 DBA_EXTENTS
• 4.202 DBA_EXTERNAL_LOCATIONS
• 4.203 DBA_EXTERNAL_TABLES
• 4.204 DBA_FEATURE_USAGE_STATISTICS
• 4.205 DBA_FGA_AUDIT_TRAIL
• 4.206 DBA_FILE_GROUP_EXPORT_INFO
• 4.207 DBA_FILE_GROUP_FILES
• 4.208 DBA_FILE_GROUP_TABLES
• 4.209 DBA_FILE_GROUP_TABLESPACES
• 4.210 DBA_FILE_GROUP_VERSIONS
• 4.211 DBA_FILE_GROUPS
• 4.212 DBA_FLASHBACK_ARCHIVE
• 4.213 DBA_FLASHBACK_ARCHIVE_TABLES
• 4.214 DBA_FLASHBACK_ARCHIVE_TS
• 4.215 DBA_FLASHBACK_TXN_REPORT
• 4.216 DBA_FLASHBACK_TXN_STATE
• 4.217 DBA_FREE_SPACE
• 4.218 DBA_FREE_SPACE_COALESCED
• 4.219 DBA_GG_INBOUND_PROGRESS
• 4.220 DBA_GLOBAL_CONTEXT
• 4.221 DBA_GOLDENGATE_INBOUND
• 4.222 DBA_GOLDENGATE_PRIVILEGES
• 4.223 DBA_GOLDENGATE_RULES
• 4.224 DBA_GOLDENGATE_SUPPORT_MODE
• 4.225 DBA_HEAT_MAP_SEG_HISTOGRAM
• 4.226 DBA_HEAT_MAP_SEGMENT
• 4.227 DBA_HEATMAP_TOP_OBJECTS
• 4.228 DBA_HEATMAP_TOP_TABLESPACES
• 4.229 DBA_HIGH_WATER_MARK_STATISTICS
• 4.230 DBA_HIST_ACTIVE_SESS_HISTORY
• 4.231 DBA_HIST_APPLY_SUMMARY
• 4.232 DBA_HIST_ASH_SNAPSHOT
• 4.233 DBA_HIST_BASELINE
• 4.234 DBA_HIST_BASELINE_DETAILS
• 4.235 DBA_HIST_BASELINE_METADATA
• 4.236 DBA_HIST_BASELINE_TEMPLATE
• 4.237 DBA_HIST_BG_EVENT_SUMMARY
• 4.238 DBA_HIST_BUFFER_POOL_STAT
• 4.239 DBA_HIST_BUFFERED_QUEUES
• 4.240 DBA_HIST_BUFFERED_SUBSCRIBERS
• 4.241 DBA_HIST_CAPTURE
• 4.242 DBA_HIST_CLUSTER_INTERCON
• 4.243 DBA_HIST_COLORED_SQL
• 4.244 DBA_HIST_COMP_IOSTAT
• 4.245 DBA_HIST_CR_BLOCK_SERVER
• 4.246 DBA_HIST_CURRENT_BLOCK_SERVER
• 4.247 DBA_HIST_DATABASE_INSTANCE
• 4.248 DBA_HIST_DATAFILE
• 4.249 DBA_HIST_DB_CACHE_ADVICE
• 4.250 DBA_HIST_DISPATCHER
• 4.251 DBA_HIST_DLM_MISC
• 4.252 DBA_HIST_DYN_REMASTER_STATS
• 4.253 DBA_HIST_ENQUEUE_STAT
• 4.254 DBA_HIST_EVENT_HISTOGRAM
• 4.255 DBA_HIST_EVENT_NAME
• 4.256 DBA_HIST_FILEMETRIC_HISTORY
• 4.257 DBA_HIST_FILESTATXS
• 4.258 DBA_HIST_IC_CLIENT_STATS
• 4.259 DBA_HIST_IC_DEVICE_STATS
• 4.260 DBA_HIST_IM_SEG_STAT
• 4.261 DBA_HIST_IM_SEG_STAT_OBJ
• 4.262 DBA_HIST_INST_CACHE_TRANSFER
• 4.263 DBA_HIST_INSTANCE_RECOVERY
• 4.264 DBA_HIST_INTERCONNECT_PINGS
• 4.265 DBA_HIST_IOSTAT_DETAIL
• 4.266 DBA_HIST_IOSTAT_FILETYPE
• 4.267 DBA_HIST_IOSTAT_FILETYPE_NAME
• 4.268 DBA_HIST_IOSTAT_FUNCTION
• 4.269 DBA_HIST_IOSTAT_FUNCTION_NAME
• 4.270 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_INSTANCE
• 5.20 DBA_HIST_PERSISTENT_QMN_CACHE
• 5.21 DBA_HIST_PERSISTENT_QUEUES
• 5.22 DBA_HIST_PERSISTENT_SUBS
• 5.23 DBA_HIST_PGA_TARGET_ADVICE
• 5.24 DBA_HIST_PGASTAT
• 5.25 DBA_HIST_PLAN_OPERATION_NAME
• 5.26 DBA_HIST_PLAN_OPTION_NAME
• 5.27 DBA_HIST_PROCESS_MEM_SUMMARY
• 5.28 DBA_HIST_REPLICATION_TBL_STATS
• 5.29 DBA_HIST_REPLICATION_TXN_STATS
• 5.30 DBA_HIST_REPORTS
• 5.31 DBA_HIST_REPORTS_CONTROL
• 5.32 DBA_HIST_REPORTS_DETAILS
• 5.33 DBA_HIST_REPORTS_TIMEBANDS
• 5.34 DBA_HIST_RESOURCE_LIMIT
• 5.35 DBA_HIST_ROWCACHE_SUMMARY
• 5.36 DBA_HIST_RSRC_CONSUMER_GROUP
• 5.37 DBA_HIST_RSRC_PLAN
• 5.38 DBA_HIST_RULE_SET
• 5.39 DBA_HIST_SEG_STAT
• 5.40 DBA_HIST_SEG_STAT_OBJ
• 5.41 DBA_HIST_SERVICE_NAME
• 5.42 DBA_HIST_SERVICE_STAT
• 5.43 DBA_HIST_SERVICE_WAIT_CLASS
• 5.44 DBA_HIST_SESS_SGA_STATS
• 5.45 DBA_HIST_SESS_TIME_STATS
• 5.46 DBA_HIST_SESSMETRIC_HISTORY
• 5.47 DBA_HIST_SGA
• 5.48 DBA_HIST_SGA_TARGET_ADVICE
• 5.49 DBA_HIST_SGASTAT
• 5.50 DBA_HIST_SHARED_POOL_ADVICE
• 5.51 DBA_HIST_SHARED_SERVER_SUMMARY
• 5.52 DBA_HIST_SNAP_ERROR
• 5.53 DBA_HIST_SNAPSHOT
• 5.54 DBA_HIST_SQL_BIND_METADATA
• 5.55 DBA_HIST_SQL_PLAN
• 5.56 DBA_HIST_SQL_SUMMARY
• 5.57 DBA_HIST_SQL_WORKAREA_HSTGRM
• 5.58 DBA_HIST_SQLBIND
• 5.59 DBA_HIST_SQLCOMMAND_NAME
• 5.60 DBA_HIST_SQLSTAT
• 5.61 DBA_HIST_SQLTEXT
• 5.62 DBA_HIST_STAT_NAME
• 5.63 DBA_HIST_STREAMS_APPLY_SUM
• 5.64 DBA_HIST_STREAMS_CAPTURE
• 5.65 DBA_HIST_STREAMS_POOL_ADVICE
• 5.66 DBA_HIST_SYS_TIME_MODEL
• 5.67 DBA_HIST_SYSMETRIC_HISTORY
• 5.68 DBA_HIST_SYSMETRIC_SUMMARY
• 5.69 DBA_HIST_SYSSTAT
• 5.70 DBA_HIST_SYSTEM_EVENT
• 5.71 DBA_HIST_TABLESPACE
• 5.72 DBA_HIST_TABLESPACE_STAT
• 5.73 DBA_HIST_TBSPC_SPACE_USAGE
• 5.74 DBA_HIST_TEMPFILE
• 5.75 DBA_HIST_TEMPSTATXS
• 5.76 DBA_HIST_THREAD
• 5.77 DBA_HIST_TOPLEVELCALL_NAME
• 5.78 DBA_HIST_UNDOSTAT
• 5.79 DBA_HIST_WAITCLASSMET_HISTORY
• 5.80 DBA_HIST_WAITSTAT
• 5.81 DBA_HIST_WR_CONTROL
• 5.82 DBA_HISTOGRAMS
• 5.83 DBA_HOST_ACES
• 5.84 DBA_HOST_ACLS
• 5.85 DBA_IDENTIFIERS
• 5.86 DBA_ILMDATAMOVEMENTPOLICIES
• 5.87 DBA_ILMEVALUATIONDETAILS
• 5.88 DBA_ILMOBJECTS
• 5.89 DBA_ILMPARAMETERS
• 5.90 DBA_ILMPOLICIES
• 5.91 DBA_ILMRESULTS
• 5.92 DBA_ILMTASKS
• 5.93 DBA_IND_COLUMNS
• 5.94 DBA_IND_EXPRESSIONS
• 5.95 DBA_IND_PARTITIONS
• 5.96 DBA_IND_PENDING_STATS
• 5.97 DBA_IND_STATISTICS
• 5.98 DBA_IND_SUBPARTITIONS
• 5.99 DBA_INDEXES
• 5.100 DBA_INDEXTYPE_ARRAYTYPES
• 5.101 DBA_INDEXTYPE_COMMENTS
• 5.102 DBA_INDEXTYPE_OPERATORS
• 5.103 DBA_INDEXTYPES
• 5.104 DBA_INTERNAL_TRIGGERS
• 5.105 DBA_JAVA_ARGUMENTS
• 5.106 DBA_JAVA_CLASSES
• 5.107 DBA_JAVA_COMPILER_OPTIONS
• 5.108 DBA_JAVA_DERIVATIONS
• 5.109 DBA_JAVA_FIELDS
• 5.110 DBA_JAVA_IMPLEMENTS
• 5.111 DBA_JAVA_INNERS
• 5.112 DBA_JAVA_LAYOUTS
• 5.113 DBA_JAVA_METHODS
• 5.114 DBA_JAVA_NCOMPS
• 5.115 DBA_JAVA_POLICY
• 5.116 DBA_JAVA_RESOLVERS
• 5.117 DBA_JAVA_THROWS
• 5.118 DBA_JOBS
• 5.119 DBA_JOBS_RUNNING
• 5.120 DBA_JOIN_IND_COLUMNS
• 5.121 DBA_JSON_COLUMNS
• 5.122 DBA_KGLLOCK
• 5.123 DBA_LIBRARIES
• 5.124 DBA_LMT_FREE_SPACE
• 5.125 DBA_LMT_USED_EXTENTS
• 5.126 DBA_LOB_PARTITIONS
• 5.127 DBA_LOB_SUBPARTITIONS
• 5.128 DBA_LOB_TEMPLATES
• 5.129 DBA_LOBS
• 5.130 DBA_LOCK
• 5.131 DBA_LOCK_INTERNAL
• 5.132 DBA_LOCKS
• 5.133 DBA_LOG_GROUP_COLUMNS
• 5.134 DBA_LOG_GROUPS
• 5.135 DBA_LOGMNR_LOG
• 5.136 DBA_LOGMNR_PURGED_LOG
• 5.137 DBA_LOGMNR_SESSION
• 5.138 DBA_LOGSTDBY_EDS_SUPPORTED
• 5.139 DBA_LOGSTDBY_EDS_TABLES
• 5.140 DBA_LOGSTDBY_EVENTS
• 5.141 DBA_LOGSTDBY_HISTORY
• 5.142 DBA_LOGSTDBY_LOG
• 5.143 DBA_LOGSTDBY_NOT_UNIQUE
• 5.144 DBA_LOGSTDBY_PARAMETERS
• 5.145 DBA_LOGSTDBY_PLSQL_MAP
• 5.146 DBA_LOGSTDBY_PLSQL_SUPPORT
• 5.147 DBA_LOGSTDBY_PROGRESS
• 5.148 DBA_LOGSTDBY_SKIP
• 5.149 DBA_LOGSTDBY_SKIP_TRANSACTION
• 5.150 DBA_LOGSTDBY_UNSUPPORTED
• 5.151 DBA_LOGSTDBY_UNSUPPORTED_TABLE
• 5.152 DBA_MEASURE_FOLDER_CONTENTS
• 5.153 DBA_MEASURE_FOLDER_SUBFOLDERS
• 5.154 DBA_MEASURE_FOLDERS
• 5.155 DBA_METADATA_PROPERTIES
• 5.156 DBA_METHOD_PARAMS
• 5.157 DBA_METHOD_RESULTS
• 5.158 DBA_MINING_MODEL_ATTRIBUTES
• 5.159 DBA_MINING_MODEL_SETTINGS
• 5.160 DBA_MINING_MODEL_TABLES
• 5.161 DBA_MINING_MODELS
• 5.162 DBA_MVIEW_AGGREGATES
• 5.163 DBA_MVIEW_ANALYSIS
• 5.164 DBA_MVIEW_COMMENTS
• 5.165 DBA_MVIEW_DETAIL_PARTITION
• 5.166 DBA_MVIEW_DETAIL_RELATIONS
• 5.167 DBA_MVIEW_DETAIL_SUBPARTITION
• 5.168 DBA_MVIEW_JOINS
• 5.169 DBA_MVIEW_KEYS
• 5.170 DBA_MVIEW_LOG_FILTER_COLS
• 5.171 DBA_MVIEW_LOGS
• 5.172 DBA_MVIEW_REFRESH_TIMES
• 5.173 DBA_MVIEWS
• 5.174 DBA_NESTED_TABLE_COLS
• 5.175 DBA_NESTED_TABLES
• 5.176 DBA_NETWORK_ACL_PRIVILEGES
• 5.177 DBA_NETWORK_ACLS
• 5.178 DBA_OBJ_AUDIT_OPTS
• 5.179 DBA_OBJ_COLATTRS
• 5.180 DBA_OBJECT_SIZE
• 5.181 DBA_OBJECT_TABLES
• 5.182 DBA_OBJECT_USAGE
• 5.183 DBA_OBJECTS
• 5.184 DBA_OBJECTS_AE
• 5.185 DBA_OPANCILLARY
• 5.186 DBA_OPARGUMENTS
• 5.187 DBA_OPBINDINGS
• 5.188 DBA_OPERATOR_COMMENTS
• 5.189 DBA_OPERATORS
• 5.190 DBA_OPTSTAT_OPERATION_TASKS
• 5.191 DBA_OPTSTAT_OPERATIONS
• 5.192 DBA_ORPHAN_KEY_TABLE
• 5.193 DBA_OUTLINE_HINTS
• 5.194 DBA_OUTLINES
• 5.195 DBA_OUTSTANDING_ALERTS
• 5.196 DBA_PARALLEL_EXECUTE_CHUNKS
• 5.197 DBA_PARALLEL_EXECUTE_TASKS
• 5.198 DBA_PART_COL_STATISTICS
• 5.199 DBA_PART_HISTOGRAMS
• 5.200 DBA_PART_INDEXES
• 5.201 DBA_PART_KEY_COLUMNS
• 5.202 DBA_PART_LOBS
• 5.203 DBA_PART_TABLES
• 5.204 DBA_PARTIAL_DROP_TABS
• 5.205 DBA_PDB_HISTORY
• 5.206 DBA_PDB_SAVED_STATES
• 5.207 DBA_PDBS
• 5.208 DBA_PENDING_CONV_TABLES
• 5.209 DBA_PENDING_TRANSACTIONS
• 5.210 DBA_PLSQL_COLL_TYPES
• 5.211 DBA_PLSQL_OBJECT_SETTINGS
• 5.212 DBA_PLSQL_TYPE_ATTRS
• 5.213 DBA_PLSQL_TYPES
• 5.214 DBA_POLICIES
• 5.215 DBA_POLICY_ATTRIBUTES
• 5.216 DBA_POLICY_CONTEXTS
• 5.217 DBA_POLICY_GROUPS
• 5.218 DBA_PRIV_AUDIT_OPTS
• 5.219 DBA_PRIV_CAPTURES
• 5.220 DBA_PROCEDURES
• 5.221 DBA_PROFILES
• 5.222 DBA_PROPAGATION
• 5.223 DBA_PROXIES
• 5.224 DBA_QUEUE_SCHEDULES
• 5.225 DBA_QUEUE_SUBSCRIBERS
• 5.226 DBA_QUEUE_TABLES
• 5.227 DBA_QUEUES
• 5.228 DBA_RCHILD
• 5.229 DBA_RECOVERABLE_SCRIPT
• 5.230 DBA_RECOVERABLE_SCRIPT_BLOCKS
• 5.231 DBA_RECOVERABLE_SCRIPT_ERRORS
• 5.232 DBA_RECOVERABLE_SCRIPT_HIST
• 5.233 DBA_RECOVERABLE_SCRIPT_PARAMS
• 5.234 DBA_RECYCLEBIN
• 5.235 DBA_REDEFINITION_ERRORS
• 5.236 DBA_REDEFINITION_OBJECTS
• 5.237 DBA_REDEFINITION_STATUS
• 5.238 DBA_REFRESH
• 5.239 DBA_REFRESH_CHILDREN
• 5.240 DBA_REFS
• 5.241 DBA_REGISTERED_ARCHIVED_LOG
• 5.242 DBA_REGISTERED_MVIEW_GROUPS
• 5.243 DBA_REGISTERED_MVIEWS
• 5.244 DBA_REGISTRY
• 5.245 DBA_REGISTRY_HIERARCHY
• 5.246 DBA_REGISTRY_HISTORY
• 5.247 DBA_REGISTRY_LOG
• 5.248 DBA_REGISTRY_SQLPATCH
• 5.249 DBA_REPAIR_TABLE
• 5.250 DBA_REPL_DBNAME_MAPPING
• 5.251 DBA_RESOURCE_INCARNATIONS
• 5.252 DBA_RESUMABLE
• 5.253 DBA_REWRITE_EQUIVALENCES
• 5.254 DBA_RGROUP
• 5.255 DBA_ROLE_PRIVS
• 5.256 DBA_ROLES
• 5.257 DBA_ROLLBACK_SEGS
• 5.258 DBA_ROLLING_DATABASES
• 5.259 DBA_ROLLING_EVENTS
• 5.260 DBA_ROLLING_PARAMETERS
• 5.261 DBA_ROLLING_PLAN
• 5.262 DBA_ROLLING_STATISTICS
• 5.263 DBA_ROLLING_STATUS
• 5.264 DBA_ROLLING_UNSUPPORTED
• 5.265 DBA_RSRC_CATEGORIES
• 5.266 DBA_RSRC_CONSUMER_GROUP_PRIVS
• 5.267 DBA_RSRC_CONSUMER_GROUPS
• 5.268 DBA_RSRC_GROUP_MAPPINGS
• 5.269 DBA_RSRC_IO_CALIBRATE
• 5.270 DBA_RSRC_MANAGER_SYSTEM_PRIVS
• 5.271 DBA_RSRC_MAPPING_PRIORITY
• 5.272 DBA_RSRC_PLAN_DIRECTIVES
• 5.273 DBA_RSRC_PLANS
• 5.274 DBA_RULE_SET_RULES
• 5.275 DBA_RULE_SETS
• 5.276 DBA_RULES
• 5.277 DBA_SCHEDULER_CHAIN_RULES
• 5.278 DBA_SCHEDULER_CHAIN_STEPS
• 5.279 DBA_SCHEDULER_CHAINS
• 5.280 DBA_SCHEDULER_CREDENTIALS
• 5.281 DBA_SCHEDULER_DB_DESTS
• 5.282 DBA_SCHEDULER_DESTS
• 5.283 DBA_SCHEDULER_EXTERNAL_DESTS
• 5.284 DBA_SCHEDULER_FILE_WATCHERS
• 5.285 DBA_SCHEDULER_GLOBAL_ATTRIBUTE
• 5.286 DBA_SCHEDULER_GROUP_MEMBERS
• 5.287 DBA_SCHEDULER_GROUPS
• 5.288 DBA_SCHEDULER_JOB_ARGS
• 5.289 DBA_SCHEDULER_JOB_CLASSES
• 5.290 DBA_SCHEDULER_JOB_DESTS
• 5.291 DBA_SCHEDULER_JOB_LOG
• 5.292 DBA_SCHEDULER_JOB_ROLES
• 5.293 DBA_SCHEDULER_JOB_RUN_DETAILS
• 5.294 DBA_SCHEDULER_JOBS
• 5.295 DBA_SCHEDULER_NOTIFICATIONS
• 5.296 DBA_SCHEDULER_PROGRAM_ARGS
• 5.297 DBA_SCHEDULER_PROGRAMS
• 5.298 DBA_SCHEDULER_REMOTE_DATABASES
• 5.299 DBA_SCHEDULER_REMOTE_JOBSTATE
• 5.300 DBA_SCHEDULER_RUNNING_CHAINS
• 5.301 DBA_SCHEDULER_RUNNING_JOBS
• 5.302 DBA_SCHEDULER_SCHEDULES
• 5.303 DBA_SCHEDULER_WINDOW_DETAILS
• 5.304 DBA_SCHEDULER_WINDOW_GROUPS
• 5.305 DBA_SCHEDULER_WINDOW_LOG
• 5.306 DBA_SCHEDULER_WINDOWS
• 5.307 DBA_SCHEDULER_WINGROUP_MEMBERS
• 5.308 DBA_SEC_RELEVANT_COLS
• 5.309 DBA_SECONDARY_OBJECTS
• 5.310 DBA_SEGMENTS
• 5.311 DBA_SEGMENTS_OLD
• 5.312 DBA_SENSITIVE_COLUMN_TYPES
• 5.313 DBA_SENSITIVE_DATA
• 5.314 DBA_SEQUENCES
• 5.315 DBA_SERVER_REGISTRY
• 5.316 DBA_SERVICES
• 5.317 DBA_SOURCE
• 5.318 DBA_SOURCE_AE
• 5.319 DBA_SQL_MANAGEMENT_CONFIG
• 5.320 DBA_SQL_PATCHES
• 5.321 DBA_SQL_PLAN_BASELINES
• 5.322 DBA_SQL_PLAN_DIR_OBJECTS
• 5.323 DBA_SQL_PLAN_DIRECTIVES
• 5.324 DBA_SQL_PROFILES
• 5.325 DBA_SQL_TRANSLATION_PROFILES
• 5.326 DBA_SQL_TRANSLATIONS
• 5.327 DBA_SQLJ_TYPE_ATTRS
• 5.328 DBA_SQLJ_TYPE_METHODS
• 5.329 DBA_SQLJ_TYPES
• 5.330 DBA_SQLSET
• 5.331 DBA_SQLSET_BINDS
• 5.332 DBA_SQLSET_PLANS
• 5.333 DBA_SQLSET_REFERENCES
• 5.334 DBA_SQLSET_STATEMENTS
• 5.335 DBA_SQLTUNE_BINDS
• 5.336 DBA_SQLTUNE_PLANS
• 5.337 DBA_SQLTUNE_RATIONALE_PLAN
• 5.338 DBA_SQLTUNE_STATISTICS
• 5.339 DBA_SR_GRP_STATUS
• 5.340 DBA_SR_GRP_STATUS_ALL
• 5.341 DBA_SR_OBJ
• 5.342 DBA_SR_OBJ_ALL
• 5.343 DBA_SR_OBJ_STATUS
• 5.344 DBA_SR_OBJ_STATUS_ALL
• 5.345 DBA_SR_PARTN_OPS
• 5.346 DBA_SR_STLOG_EXCEPTIONS
• 5.347 DBA_SR_STLOG_STATS
• 5.348 DBA_SSCR_CAPTURE
• 5.349 DBA_SSCR_RESTORE
• 5.350 DBA_STAT_EXTENSIONS
• 5.351 DBA_STMT_AUDIT_OPTS
• 5.352 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_UNDO_EXTENTS
• 6.84 DBA_UNUSED_COL_TABS
• 6.85 DBA_UNUSED_OBJPRIVS
• 6.86 DBA_UNUSED_OBJPRIVS_PATH
• 6.87 DBA_UNUSED_PRIVS
• 6.88 DBA_UNUSED_SYSPRIVS
• 6.89 DBA_UNUSED_SYSPRIVS_PATH
• 6.90 DBA_UNUSED_USERPRIVS
• 6.91 DBA_UNUSED_USERPRIVS_PATH
• 6.92 DBA_UPDATABLE_COLUMNS
• 6.93 DBA_USED_OBJPRIVS
• 6.94 DBA_USED_OBJPRIVS_PATH
• 6.95 DBA_USED_PRIVS
• 6.96 DBA_USED_PUBPRIVS
• 6.97 DBA_USED_SYSPRIVS
• 6.98 DBA_USED_SYSPRIVS_PATH
• 6.99 DBA_USED_USERPRIVS
• 6.100 DBA_USED_USERPRIVS_PATH
• 6.101 DBA_USERS
• 6.102 DBA_USERS_WITH_DEFPWD
• 6.103 DBA_USTATS
• 6.104 DBA_VARRAYS
• 6.105 DBA_VIEWS
• 6.106 DBA_VIEWS_AE
• 6.107 DBA_WAITERS
• 6.108 DBA_WALLET_ACES
• 6.109 DBA_WALLET_ACLS
• 6.110 DBA_WARNING_SETTINGS
• 6.111 DBA_WI_CAPTURE_FILES
• 6.112 DBA_WI_JOBS
• 6.113 DBA_WI_OBJECTS
• 6.114 DBA_WI_PATTERN_ITEMS
• 6.115 DBA_WI_PATTERNS
• 6.116 DBA_WI_STATEMENTS
• 6.117 DBA_WI_TEMPLATE_EXECUTIONS
• 6.118 DBA_WI_TEMPLATES
• 6.119 DBA_WORKLOAD_ACTIVE_USER_MAP
• 6.120 DBA_WORKLOAD_CAPTURES
• 6.121 DBA_WORKLOAD_CONNECTION_MAP
• 6.122 DBA_WORKLOAD_FILTERS
• 6.123 DBA_WORKLOAD_REPLAY_DIVERGENCE
• 6.124 DBA_WORKLOAD_REPLAY_SCHEDULES
• 6.125 DBA_WORKLOAD_REPLAYS
• 6.126 DBA_WORKLOAD_SCHEDULE_CAPTURES
• 6.127 DBA_WORKLOAD_SCHEDULE_ORDERING
• 6.128 DBA_WORKLOAD_USER_MAP
• 6.129 DBA_XML_INDEXES
• 6.130 DBA_XML_NESTED_TABLES
• 6.131 DBA_XML_OUT_OF_LINE_TABLES
• 6.132 DBA_XML_SCHEMA_ATTRIBUTES
• 6.133 DBA_XML_SCHEMA_COMPLEX_TYPES
• 6.134 DBA_XML_SCHEMA_ELEMENTS
• 6.135 DBA_XML_SCHEMA_NAMESPACES
• 6.136 DBA_XML_SCHEMA_SIMPLE_TYPES
• 6.137 DBA_XML_SCHEMA_SUBSTGRP_HEAD
• 6.138 DBA_XML_SCHEMA_SUBSTGRP_MBRS
• 6.139 DBA_XML_SCHEMAS
• 6.140 DBA_XML_TAB_COLS
• 6.141 DBA_XML_TABLES
• 6.142 DBA_XML_VIEW_COLS
• 6.143 DBA_XML_VIEWS
• 6.144 DBA_XS_AUDIT_POLICY_OPTIONS
• 6.145 DBA_XS_AUDIT_TRAIL
• 6.146 DBA_XS_ENB_AUDIT_POLICIES
• 6.147 DBA_XSTREAM_ADMINISTRATOR
• 6.148 DBA_XSTREAM_INBOUND
• 6.149 DBA_XSTREAM_INBOUND_PROGRESS
• 6.150 DBA_XSTREAM_OUT_SUPPORT_MODE
• 6.151 DBA_XSTREAM_OUTBOUND
• 6.152 DBA_XSTREAM_OUTBOUND_PROGRESS
• 6.153 DBA_XSTREAM_RULES
• 6.154 DBA_XSTREAM_SPLIT_MERGE
• 6.155 DBA_XSTREAM_SPLIT_MERGE_HIST
• 6.156 DBA_XSTREAM_STMT_HANDLERS
• 6.157 DBA_XSTREAM_STMTS
• 6.158 DBA_XSTREAM_TRANSFORMATIONS
• 6.159 DBA_ZONEMAP_MEASURES
• 6.160 DBA_ZONEMAPS
• 6.161 DBFS_CONTENT
• 6.162 DBFS_CONTENT_PROPERTIES
• 6.163 DBMS_ALERT_INFO
• 6.164 DBMS_LOCK_ALLOCATED
• 6.165 DEPTREE
• 6.166 DICT
• 6.167 DICT_COLUMNS
• 6.168 DICTIONARY
• 6.169 DM_USER_MODELS
• 6.170 DOCUMENT_LINKS
• 6.171 ERROR_SIZE
• 6.172 EXCEPTIONS
• 6.173 FLASHBACK_TRANSACTION_QUERY
• 6.174 GLOBAL_CONTEXT
• 6.175 GLOBAL_NAME
• 6.176 HS_ALL_CAPS
• 6.177 HS_ALL_DD
• 6.178 HS_ALL_INITS
• 6.179 HS_BASE_CAPS
• 6.180 HS_BASE_DD
• 6.181 HS_CLASS_CAPS
• 6.182 HS_CLASS_DD
• 6.183 HS_CLASS_INIT
• 6.184 HS_FDS_CLASS
• 6.185 HS_FDS_INST
• 6.186 HS_INST_CAPS
• 6.187 HS_INST_DD
• 6.188 HS_INST_INIT
• 6.189 IDEPTREE
• 6.190 IND
• 6.191 INDEX_HISTOGRAM
• 6.192 INDEX_STATS
• 6.193 LOGSTDBY_UNSUPPORTED_TABLES
• 6.194 MAP_OBJECT
• 6.195 NLS_DATABASE_PARAMETERS
• 6.196 NLS_INSTANCE_PARAMETERS
• 6.197 NLS_SESSION_PARAMETERS
• 6.198 OBJ
• 6.199 PATH_VIEW
• 6.200 PDB_ALERTS
• 6.201 PDB_PLUG_IN_VIOLATIONS
• 6.202 PLAN_TABLE
• 6.203 PLUGGABLE_SET_CHECK
• 6.204 PRODUCT_COMPONENT_VERSION
• 6.205 PROXY_USERS
• 6.206 PSTUBTBL
• 6.207 PUBLIC_DEPENDENCY
• 6.208 PUBLICSYN
• 6.209 QUEUE_PRIVILEGES
• 6.210 RECYCLEBIN
• 6.211 REDACTION_COLUMNS
• 6.212 REDACTION_POLICIES
• 6.213 REDACTION_VALUES_FOR_TYPE_FULL
• 6.214 REPORT_COMPONENTS
• 6.215 REPORT_FILES
• 6.216 REPORT_FORMATS
• 6.217 RESOURCE_COST
• 6.218 RESOURCE_MAP
• 6.219 RESOURCE_VIEW
• 6.220 ROLE_ROLE_PRIVS
• 6.221 ROLE_SYS_PRIVS
• 6.222 ROLE_TAB_PRIVS
• 6.223 SCHEDULER_BATCH_ERRORS
• 6.224 SCHEMA_EXPORT_OBJECTS
• 6.225 SEQ
• 6.226 SESSION_CONTEXT
• 6.227 SESSION_PRIVS
• 6.228 SESSION_ROLES
• 6.229 SOURCE_SIZE
• 6.230 STMT_AUDIT_OPTION_MAP
• 6.231 SYN
• 6.232 SYNONYMS
• 6.233 SYS_OBJECTS
• 6.234 SYSCATALOG
• 6.235 SYSFILES
• 6.236 SYSSEGOBJ
• 6.237 SYSTEM_PRIVILEGE_MAP
• 6.238 TAB
• 6.239 TABLE_EXPORT_OBJECTS
• 6.240 TABLE_PRIVILEGE_MAP
• 6.241 TABQUOTAS
• 6.242 TABS
• 6.243 TRUSTED_SERVERS
• 6.244 TS_PITR_CHECK
• 6.245 TS_PITR_OBJECTS_TO_BE_DROPPED
• 6.246 UNI_PLUGGABLE_SET_CHECK
• 6.247 UNIFIED_AUDIT_TRAIL
• 6.248 USABLE_EDITIONS
• 6.249 USER_ADDM_FDG_BREAKDOWN
• 6.250 USER_ADDM_FINDINGS
• 6.251 USER_ADDM_INSTANCES
• 6.252 USER_ADDM_TASK_DIRECTIVES
• 6.253 USER_ADDM_TASKS
• 6.254 USER_ADVISOR_ACTIONS
• 6.255 USER_ADVISOR_DIR_TASK_INST
• 6.256 USER_ADVISOR_EXEC_PARAMETERS
• 6.257 USER_ADVISOR_EXECUTIONS
• 6.258 USER_ADVISOR_FDG_BREAKDOWN
• 6.259 USER_ADVISOR_FINDINGS
• 6.260 USER_ADVISOR_JOURNAL
• 6.261 USER_ADVISOR_LOG
• 6.262 USER_ADVISOR_OBJECTS
• 6.263 USER_ADVISOR_PARAMETERS
• 6.264 USER_ADVISOR_RATIONALE
• 6.265 USER_ADVISOR_RECOMMENDATIONS
• 6.266 USER_ADVISOR_SQLA_REC_SUM
• 6.267 USER_ADVISOR_SQLA_TABLES
• 6.268 USER_ADVISOR_SQLA_WK_MAP
• 6.269 USER_ADVISOR_SQLA_WK_STMTS
• 6.270 USER_ADVISOR_SQLPLANS
• 6.271 USER_ADVISOR_SQLSTATS
• 6.272 USER_ADVISOR_SQLW_JOURNAL
• 6.273 USER_ADVISOR_SQLW_PARAMETERS
• 6.274 USER_ADVISOR_SQLW_STMTS
• 6.275 USER_ADVISOR_SQLW_SUM
• 6.276 USER_ADVISOR_SQLW_TABLES
• 6.277 USER_ADVISOR_SQLW_TEMPLATES
• 6.278 USER_ADVISOR_TASKS
• 6.279 USER_ADVISOR_TEMPLATES
• 6.280 USER_ALL_TABLES
• 6.281 USER_APPLY_ERROR
• 6.282 USER_AQ_AGENT_PRIVS
• 6.283 USER_ARGUMENTS
• 6.284 USER_ASSEMBLIES
• 6.285 USER_ASSOCIATIONS
• 6.286 USER_ATTRIBUTE_TRANSFORMATIONS
• 6.287 USER_AUDIT_OBJECT
• 6.288 USER_AUDIT_POLICIES
• 6.289 USER_AUDIT_POLICY_COLUMNS
• 6.290 USER_AUDIT_SESSION
• 6.291 USER_AUDIT_STATEMENT
• 6.292 USER_AUDIT_TRAIL
• 6.293 USER_AW_PS
• 6.294 USER_AWS
• 6.295 USER_BASE_TABLE_MVIEWS
• 6.296 USER_CATALOG
• 6.297 USER_CHANGE_NOTIFICATION_REGS
• 6.298 USER_CLU_COLUMNS
• 6.299 USER_CLUSTER_HASH_EXPRESSIONS
• 6.300 USER_CLUSTERING_DIMENSIONS
• 6.301 USER_CLUSTERING_JOINS
• 6.302 USER_CLUSTERING_KEYS
• 6.303 USER_CLUSTERING_TABLES
• 6.304 USER_CLUSTERS
• 6.305 USER_CODE_ROLE_PRIVS
• 6.306 USER_COL_COMMENTS
• 6.307 USER_COL_PENDING_STATS
• 6.308 USER_COL_PRIVS
• 6.309 USER_COL_PRIVS_MADE
• 6.310 USER_COL_PRIVS_RECD
• 6.311 USER_COLL_TYPES
• 6.312 USER_COMPARISON
• 6.313 USER_COMPARISON_COLUMNS
• 6.314 USER_COMPARISON_ROW_DIF
• 6.315 USER_COMPARISON_SCAN
• 6.316 USER_COMPARISON_SCAN_VALUES
• 6.317 USER_CONS_COLUMNS
• 6.318 USER_CONS_OBJ_COLUMNS
• 6.319 USER_CONSTRAINTS
• 6.320 USER_CQ_NOTIFICATION_QUERIES
• 6.321 USER_CREDENTIALS
• 6.322 USER_CUBE_ATTR_VISIBILITY
• 6.323 USER_CUBE_ATTRIBUTES
• 6.324 USER_CUBE_BUILD_PROCESSES
• 6.325 USER_CUBE_CALCULATED_MEMBERS
• 6.326 USER_CUBE_DIM_LEVELS
• 6.327 USER_CUBE_DIM_MODELS
• 6.328 USER_CUBE_DIM_VIEW_COLUMNS
• 6.329 USER_CUBE_DIM_VIEWS
• 6.330 USER_CUBE_DIMENSIONALITY
• 6.331 USER_CUBE_DIMENSIONS
• 6.332 USER_CUBE_HIER_LEVELS
• 6.333 USER_CUBE_HIER_VIEW_COLUMNS
• 6.334 USER_CUBE_HIER_VIEWS
• 6.335 USER_CUBE_HIERARCHIES
• 6.336 USER_CUBE_MEASURES
• 6.337 USER_CUBE_NAMED_BUILD_SPECS
• 6.338 USER_CUBE_SUB_PARTITION_LEVELS
• 6.339 USER_CUBE_VIEW_COLUMNS
• 6.340 USER_CUBE_VIEWS
• 6.341 USER_CUBES
• 6.342 USER_DATAPUMP_JOBS
• 6.343 USER_DB_LINKS
• 6.344 USER_DBFS_HS
• 6.345 USER_DBFS_HS_COMMANDS
• 6.346 USER_DBFS_HS_FILES
• 6.347 USER_DBFS_HS_FIXED_PROPERTIES
• 6.348 USER_DBFS_HS_PROPERTIES
• 6.349 USER_DEPENDENCIES
• 6.350 USER_DIM_ATTRIBUTES
• 6.351 USER_DIM_CHILD_OF
• 6.352 USER_DIM_HIERARCHIES
• 6.353 USER_DIM_JOIN_KEY
• 6.354 USER_DIM_LEVEL_KEY
• 6.355 USER_DIM_LEVELS
• 6.356 USER_DIMENSIONS
• 6.357 USER_EDITIONED_TYPES
• 6.358 USER_EDITIONING_VIEW_COLS
• 6.359 USER_EDITIONING_VIEW_COLS_AE
• 6.360 USER_EDITIONING_VIEWS
• 6.361 USER_EDITIONING_VIEWS_AE
• 6.362 USER_ENCRYPTED_COLUMNS
• 6.363 USER_EPG_DAD_AUTHORIZATION
• 6.364 USER_ERROR_TRANSLATIONS
• 6.365 USER_ERRORS
• 6.366 USER_ERRORS_AE
• 6.367 USER_EVALUATION_CONTEXT_TABLES
• 6.368 USER_EVALUATION_CONTEXT_VARS
• 6.369 USER_EVALUATION_CONTEXTS
• 6.370 USER_EXTENTS
• 6.371 USER_EXTERNAL_LOCATIONS
• 6.372 USER_EXTERNAL_TABLES
• 6.373 USER_FILE_GROUP_EXPORT_INFO
• 6.374 USER_FILE_GROUP_FILES
• 6.375 USER_FILE_GROUP_TABLES
• 6.376 USER_FILE_GROUP_TABLESPACES
• 6.377 USER_FILE_GROUP_VERSIONS
• 6.378 USER_FILE_GROUPS
• 6.379 USER_FLASHBACK_ARCHIVE
• 6.380 USER_FLASHBACK_ARCHIVE_TABLES
• 6.381 USER_FLASHBACK_TXN_REPORT
• 6.382 USER_FLASHBACK_TXN_STATE
• 6.383 USER_FREE_SPACE
• 6.384 USER_GOLDENGATE_PRIVILEGES
• 6.385 USER_HEAT_MAP_SEG_HISTOGRAM
• 6.386 USER_HEAT_MAP_SEGMENT
• 6.387 USER_HISTOGRAMS
• 6.388 USER_HOST_ACES
• 6.389 USER_IDENTIFIERS
• 6.390 USER_ILMDATAMOVEMENTPOLICIES
• 6.391 USER_ILMEVALUATIONDETAILS
• 6.392 USER_ILMOBJECTS
• 6.393 USER_ILMPOLICIES
• 6.394 USER_ILMRESULTS
• 6.395 USER_ILMTASKS
• 6.396 USER_IND_COLUMNS
• 6.397 USER_IND_EXPRESSIONS
• 6.398 USER_IND_PARTITIONS
• 6.399 USER_IND_PENDING_STATS
• 6.400 USER_IND_STATISTICS
• 6.401 USER_IND_SUBPARTITIONS
• 6.402 USER_INDEXES
• 6.403 USER_INDEXTYPE_ARRAYTYPES
• 6.404 USER_INDEXTYPE_COMMENTS
• 6.405 USER_INDEXTYPE_OPERATORS
• 6.406 USER_INDEXTYPES
• 6.407 USER_INTERNAL_TRIGGERS
• 6.408 USER_JAVA_ARGUMENTS
• 6.409 USER_JAVA_CLASSES
• 6.410 USER_JAVA_COMPILER_OPTIONS
• 6.411 USER_JAVA_DERIVATIONS
• 6.412 USER_JAVA_FIELDS
• 6.413 USER_JAVA_IMPLEMENTS
• 6.414 USER_JAVA_INNERS
• 6.415 USER_JAVA_LAYOUTS
• 6.416 USER_JAVA_METHODS
• 6.417 USER_JAVA_NCOMPS
• 6.418 USER_JAVA_POLICY
• 6.419 USER_JAVA_RESOLVERS
• 6.420 USER_JAVA_THROWS
• 6.421 USER_JOBS
• 6.422 USER_JOIN_IND_COLUMNS
• 6.423 USER_JSON_COLUMNS
• 6.424 USER_LIBRARIES
• 6.425 USER_LOB_PARTITIONS
• 6.426 USER_LOB_SUBPARTITIONS
• 6.427 USER_LOB_TEMPLATES
• 6.428 USER_LOBS
• 6.429 USER_LOG_GROUP_COLUMNS
• 6.430 USER_LOG_GROUPS
• 6.431 USER_MEASURE_FOLDER_CONTENTS
• 6.432 USER_MEASURE_FOLDER_SUBFOLDERS
• 6.433 USER_MEASURE_FOLDERS
• 6.434 USER_METADATA_PROPERTIES
• 6.435 USER_METHOD_PARAMS
• 6.436 USER_METHOD_RESULTS
• 6.437 USER_MINING_MODEL_ATTRIBUTES
• 6.438 USER_MINING_MODEL_SETTINGS
• 6.439 USER_MINING_MODELS
• 6.440 USER_MVIEW_AGGREGATES
• 6.441 USER_MVIEW_ANALYSIS
• 6.442 USER_MVIEW_COMMENTS
• 6.443 USER_MVIEW_DETAIL_PARTITION
• 6.444 USER_MVIEW_DETAIL_RELATIONS
• 6.445 USER_MVIEW_DETAIL_SUBPARTITION
• 6.446 USER_MVIEW_JOINS
• 6.447 USER_MVIEW_KEYS
• 6.448 USER_MVIEW_LOGS
• 6.449 USER_MVIEW_REFRESH_TIMES
• 6.450 USER_MVIEWS
• 6.451 USER_NESTED_TABLE_COLS
• 6.452 USER_NESTED_TABLES
• 6.453 USER_NETWORK_ACL_PRIVILEGES
• 6.454 USER_OBJ_AUDIT_OPTS
• 6.455 USER_OBJ_COLATTRS
• 6.456 USER_OBJECT_SIZE
• 6.457 USER_OBJECT_TABLES
• 6.458 USER_OBJECT_USAGE
• 6.459 USER_OBJECTS
• 6.460 USER_OBJECTS_AE
• 6.461 USER_OPANCILLARY
• 6.462 USER_OPARGUMENTS
• 6.463 USER_OPBINDINGS
• 6.464 USER_OPERATOR_COMMENTS
• 6.465 USER_OPERATORS
• 6.466 USER_OUTLINE_HINTS
• 6.467 USER_OUTLINES
• 6.468 USER_PARALLEL_EXECUTE_CHUNKS
• 6.469 USER_PARALLEL_EXECUTE_TASKS
• 6.470 USER_PART_COL_STATISTICS
• 6.471 USER_PART_HISTOGRAMS
• 6.472 USER_PART_INDEXES
• 6.473 USER_PART_KEY_COLUMNS
• 6.474 USER_PART_LOBS
• 6.475 USER_PART_TABLES
• 6.476 USER_PARTIAL_DROP_TABS
• 6.477 USER_PASSWORD_LIMITS
• 6.478 USER_PENDING_CONV_TABLES
• 6.479 USER_PLSQL_COLL_TYPES
• 6.480 USER_PLSQL_OBJECT_SETTINGS
• 6.481 USER_PLSQL_TYPE_ATTRS
• 6.482 USER_PLSQL_TYPES
• 6.483 USER_POLICIES
• 6.484 USER_POLICY_ATTRIBUTES
• 6.485 USER_POLICY_CONTEXTS
• 6.486 USER_POLICY_GROUPS
• 6.487 USER_PRIVILEGE_MAP
• 6.488 USER_PROCEDURES
• 6.489 USER_PROXIES
• 6.490 USER_QUEUE_SCHEDULES
• 6.491 USER_QUEUE_SUBSCRIBERS
• 6.492 USER_QUEUE_TABLES
• 6.493 USER_QUEUES
• 6.494 USER_RECYCLEBIN
• 6.495 USER_REFRESH
• 6.496 USER_REFRESH_CHILDREN
• 6.497 USER_REFS
• 6.498 USER_REGISTERED_MVIEWS
• 6.499 USER_REGISTRY
• 6.500 USER_RESOURCE_LIMITS
• 6.501 USER_RESUMABLE
• 6.502 USER_REWRITE_EQUIVALENCES
• 6.503 USER_ROLE_PRIVS
• 6.504 USER_RSRC_CONSUMER_GROUP_PRIVS
• 6.505 USER_RSRC_MANAGER_SYSTEM_PRIVS
• 6.506 USER_RULE_SET_RULES
• 6.507 USER_RULE_SETS
• 6.508 USER_RULES
• 6.509 USER_SCHEDULER_CHAIN_RULES
• 6.510 USER_SCHEDULER_CHAIN_STEPS
• 6.511 USER_SCHEDULER_CHAINS
• 6.512 USER_SCHEDULER_CREDENTIALS
• 6.513 USER_SCHEDULER_DB_DESTS
• 6.514 USER_SCHEDULER_DESTS
• 6.515 USER_SCHEDULER_FILE_WATCHERS
• 6.516 USER_SCHEDULER_GROUP_MEMBERS
• 6.517 USER_SCHEDULER_GROUPS
• 6.518 USER_SCHEDULER_JOB_ARGS
• 6.519 USER_SCHEDULER_JOB_DESTS
• 6.520 USER_SCHEDULER_JOB_LOG
• 6.521 USER_SCHEDULER_JOB_RUN_DETAILS
• 6.522 USER_SCHEDULER_JOBS
• 6.523 USER_SCHEDULER_NOTIFICATIONS
• 6.524 USER_SCHEDULER_PROGRAM_ARGS
• 6.525 USER_SCHEDULER_PROGRAMS
• 6.526 USER_SCHEDULER_REMOTE_JOBSTATE
• 6.527 USER_SCHEDULER_RUNNING_CHAINS
• 6.528 USER_SCHEDULER_RUNNING_JOBS
• 6.529 USER_SCHEDULER_SCHEDULES
• 6.530 USER_SEC_RELEVANT_COLS
• 6.531 USER_SECONDARY_OBJECTS
• 6.532 USER_SEGMENTS
• 6.533 USER_SEQUENCES
• 6.534 USER_SOURCE
• 6.535 USER_SOURCE_AE
• 6.536 USER_SQL_TRANSLATION_PROFILES
• 6.537 USER_SQL_TRANSLATIONS
• 6.538 USER_SQLJ_TYPE_ATTRS
• 6.539 USER_SQLJ_TYPE_METHODS
• 6.540 USER_SQLJ_TYPES
• 6.541 USER_SQLSET
• 6.542 USER_SQLSET_BINDS
• 6.543 USER_SQLSET_PLANS
• 6.544 USER_SQLSET_REFERENCES
• 6.545 USER_SQLSET_STATEMENTS
• 6.546 USER_SQLTUNE_BINDS
• 6.547 USER_SQLTUNE_PLANS
• 6.548 USER_SQLTUNE_RATIONALE_PLAN
• 6.549 USER_SQLTUNE_STATISTICS
• 6.550 USER_SR_GRP_STATUS
• 6.551 USER_SR_GRP_STATUS_ALL
• 6.552 USER_SR_OBJ
• 6.553 USER_SR_OBJ_ALL
• 6.554 USER_SR_OBJ_STATUS
• 6.555 USER_SR_OBJ_STATUS_ALL
• 6.556 USER_SR_PARTN_OPS
• 6.557 USER_SR_STLOG_EXCEPTIONS
• 6.558 USER_SR_STLOG_STATS
• 6.559 USER_STAT_EXTENSIONS
• 6.560 USER_STORED_SETTINGS
• 6.561 USER_SUBPART_COL_STATISTICS
• 6.562 USER_SUBPART_HISTOGRAMS
• 6.563 USER_SUBPART_KEY_COLUMNS
• 6.564 USER_SUBPARTITION_TEMPLATES
• 6.565 USER_SUBSCR_REGISTRATIONS
• 6.566 USER_SYNONYMS
• 6.567 USER_SYS_PRIVS
• 6.568 USER_TAB_COL_STATISTICS
• 6.569 USER_TAB_COLS
• 6.570 USER_TAB_COLUMNS
• 6.571 USER_TAB_COMMENTS
• 6.572 USER_TAB_HISTGRM_PENDING_STATS
• 6.573 USER_TAB_HISTOGRAMS
• 6.574 USER_TAB_IDENTITY_COLS
• 6.575 USER_TAB_MODIFICATIONS
• 6.576 USER_TAB_PARTITIONS
• 6.577 USER_TAB_PENDING_STATS
• 6.578 USER_TAB_PRIVS
• 6.579 USER_TAB_PRIVS_MADE
• 6.580 USER_TAB_PRIVS_RECD
• 6.581 USER_TAB_STAT_PREFS
• 6.582 USER_TAB_STATISTICS
• 6.583 USER_TAB_STATS_HISTORY
• 6.584 USER_TAB_SUBPARTITIONS
• 6.585 USER_TABLES
• 6.586 USER_TABLESPACES
• 6.587 USER_TRANSFORMATIONS
• 6.588 USER_TRIGGER_COLS
• 6.589 USER_TRIGGER_ORDERING
• 6.590 USER_TRIGGERS
• 6.591 USER_TS_QUOTAS
• 6.592 USER_TSTZ_TAB_COLS
• 6.593 USER_TSTZ_TABLES
• 6.594 USER_TUNE_MVIEW
• 6.595 USER_TYPE_ATTRS
• 6.596 USER_TYPE_METHODS
• 6.597 USER_TYPE_VERSIONS
• 6.598 USER_TYPES
• 6.599 USER_UNUSED_COL_TABS
• 6.600 USER_UPDATABLE_COLUMNS
• 6.601 USER_USERS
• 6.602 USER_USTATS
• 6.603 USER_VARRAYS
• 6.604 USER_VIEWS
• 6.605 USER_VIEWS_AE
• 6.606 USER_WALLET_ACES
• 6.607 USER_WARNING_SETTINGS
• 6.608 USER_XML_INDEXES
• 6.609 USER_XML_NESTED_TABLES
• 6.610 USER_XML_OUT_OF_LINE_TABLES
• 6.611 USER_XML_SCHEMA_ATTRIBUTES
• 6.612 USER_XML_SCHEMA_COMPLEX_TYPES
• 6.613 USER_XML_SCHEMA_ELEMENTS
• 6.614 USER_XML_SCHEMA_NAMESPACES
• 6.615 USER_XML_SCHEMA_SIMPLE_TYPES
• 6.616 USER_XML_SCHEMA_SUBSTGRP_HEAD
• 6.617 USER_XML_SCHEMA_SUBSTGRP_MBRS
• 6.618 USER_XML_SCHEMAS
• 6.619 USER_XML_TAB_COLS
• 6.620 USER_XML_TABLES
• 6.621 USER_XML_VIEW_COLS
• 6.622 USER_XML_VIEWS
• 6.623 USER_ZONEMAP_MEASURES
• 6.624 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_NONDUR_REGISTRATIONS
• 7.17 V$AQ_NONDUR_SUBSCRIBER
• 7.18 V$AQ_NONDUR_SUBSCRIBER_LWM
• 7.19 V$AQ_NOTIFICATION_CLIENTS
• 7.20 V$AQ_SERVER_POOL
• 7.21 V$AQ_SUBSCRIBER_LOAD
• 7.22 V$ARCHIVE
• 7.23 V$ARCHIVE_DEST
• 7.24 V$ARCHIVE_DEST_STATUS
• 7.25 V$ARCHIVE_GAP
• 7.26 V$ARCHIVE_PROCESSES
• 7.27 V$ARCHIVED_LOG
• 7.28 V$ASM_ACFS_ENCRYPTION_INFO
• 7.29 V$ASM_ACFS_SEC_ADMIN
• 7.30 V$ASM_ACFS_SEC_CMDRULE
• 7.31 V$ASM_ACFS_SEC_REALM
• 7.32 V$ASM_ACFS_SEC_REALM_FILTER
• 7.33 V$ASM_ACFS_SEC_REALM_GROUP
• 7.34 V$ASM_ACFS_SEC_REALM_USER
• 7.35 V$ASM_ACFS_SEC_RULE
• 7.36 V$ASM_ACFS_SEC_RULESET
• 7.37 V$ASM_ACFS_SEC_RULESET_RULE
• 7.38 V$ASM_ACFS_SECURITY_INFO
• 7.39 V$ASM_ACFSREPL
• 7.40 V$ASM_ACFSREPLTAG
• 7.41 V$ASM_ACFSSNAPSHOTS
• 7.42 V$ASM_ACFSTAG
• 7.43 V$ASM_ACFSVOLUMES
• 7.44 V$ASM_ALIAS
• 7.45 V$ASM_ATTRIBUTE
• 7.46 V$ASM_AUDIT_CLEAN_EVENTS
• 7.47 V$ASM_AUDIT_CLEANUP_JOBS
• 7.48 V$ASM_AUDIT_CONFIG_PARAMS
• 7.49 V$ASM_AUDIT_LAST_ARCH_TS
• 7.50 V$ASM_CLIENT
• 7.51 V$ASM_DISK
• 7.52 V$ASM_DISK_IOSTAT
• 7.53 V$ASM_DISK_STAT
• 7.54 V$ASM_DISKGROUP
• 7.55 V$ASM_DISKGROUP_STAT
• 7.56 V$ASM_ESTIMATE
• 7.57 V$ASM_FILE
• 7.58 V$ASM_FILESYSTEM
• 7.59 V$ASM_OPERATION
• 7.60 V$ASM_TEMPLATE
• 7.61 V$ASM_USER
• 7.62 V$ASM_USERGROUP
• 7.63 V$ASM_USERGROUP_MEMBER
• 7.64 V$ASM_VOLUME
• 7.65 V$ASM_VOLUME_STAT
• 7.66 V$AW_AGGREGATE_OP
• 7.67 V$AW_ALLOCATE_OP
• 7.68 V$AW_CALC
• 7.69 V$AW_LONGOPS
• 7.70 V$AW_OLAP
• 7.71 V$AW_SESSION_INFO
• 7.72 V$BACKUP
• 7.73 V$BACKUP_ARCHIVELOG_DETAILS
• 7.74 V$BACKUP_ARCHIVELOG_SUMMARY
• 7.75 V$BACKUP_ASYNC_IO
• 7.76 V$BACKUP_CONTROLFILE_DETAILS
• 7.77 V$BACKUP_CONTROLFILE_SUMMARY
• 7.78 V$BACKUP_COPY_DETAILS
• 7.79 V$BACKUP_COPY_SUMMARY
• 7.80 V$BACKUP_CORRUPTION
• 7.81 V$BACKUP_DATAFILE
• 7.82 V$BACKUP_DATAFILE_DETAILS
• 7.83 V$BACKUP_DATAFILE_SUMMARY
• 7.84 V$BACKUP_DEVICE
• 7.85 V$BACKUP_FILES
• 7.86 V$BACKUP_NONLOGGED
• 7.87 V$BACKUP_PIECE
• 7.88 V$BACKUP_PIECE_DETAILS
• 7.89 V$BACKUP_REDOLOG
• 7.90 V$BACKUP_SET
• 7.91 V$BACKUP_SET_DETAILS
• 7.92 V$BACKUP_SET_SUMMARY
• 7.93 V$BACKUP_SPFILE
• 7.94 V$BACKUP_SPFILE_DETAILS
• 7.95 V$BACKUP_SPFILE_SUMMARY
• 7.96 V$BACKUP_SYNC_IO
• 7.97 V$BGPROCESS
• 7.98 V$BH
• 7.99 V$BLOCK_CHANGE_TRACKING
• 7.100 V$BLOCKING_QUIESCE
• 7.101 V$BT_SCAN_CACHE
• 7.102 V$BT_SCAN_OBJ_TEMPS
• 7.103 V$BUFFER_POOL
• 7.104 V$BUFFER_POOL_STATISTICS
• 7.105 V$BUFFERED_PUBLISHERS
• 7.106 V$BUFFERED_QUEUES
• 7.107 V$BUFFERED_SUBSCRIBERS
• 7.108 V$CACHE
• 7.109 V$CACHE_LOCK
• 7.110 V$CACHE_TRANSFER
• 7.111 V$CIRCUIT
• 7.112 V$CLASS_CACHE_TRANSFER
• 7.113 V$CLIENT_SECRETS
• 7.114 V$CLIENT_STATS
• 7.115 V$CLONEDFILE
• 7.116 V$CLUSTER_INTERCONNECTS
• 7.117 V$CON_SYS_TIME_MODEL
• 7.118 V$CON_SYSSTAT
• 7.119 V$CON_SYSTEM_EVENT
• 7.120 V$CON_SYSTEM_WAIT_CLASS
• 7.121 V$CONFIGURED_INTERCONNECTS
• 7.122 V$CONTAINERS
• 7.123 V$CONTEXT
• 7.124 V$CONTROLFILE
• 7.125 V$CONTROLFILE_RECORD_SECTION
• 7.126 V$COPY_CORRUPTION
• 7.127 V$COPY_NONLOGGED
• 7.128 V$CORRUPT_XID_LIST
• 7.129 V$CPOOL_CC_INFO
• 7.130 V$CPOOL_CC_STATS
• 7.131 V$CPOOL_CONN_INFO
• 7.132 V$CPOOL_STATS
• 7.133 V$CR_BLOCK_SERVER
• 7.134 V$CURRENT_BLOCK_SERVER
• 7.135 V$DATABASE
• 7.136 V$DATABASE_BLOCK_CORRUPTION
• 7.137 V$DATABASE_INCARNATION
• 7.138 V$DATAFILE
• 7.139 V$DATAFILE_COPY
• 7.140 V$DATAFILE_HEADER
• 7.141 V$DATAGUARD_CONFIG
• 7.142 V$DATAGUARD_STATS
• 7.143 V$DATAGUARD_STATUS
• 7.144 V$DB_CACHE_ADVICE
• 7.145 V$DB_OBJECT_CACHE
• 7.146 V$DB_PIPES
• 7.147 V$DB_TRANSPORTABLE_PLATFORM
• 7.148 V$DBFILE
• 7.149 V$DBLINK
• 7.150 V$DEAD_CLEANUP
• 7.151 V$DELETED_OBJECT
• 7.152 V$DG_BROKER_CONFIG
• 7.153 V$DIAG_INFO
• 7.154 V$DISPATCHER
• 7.155 V$DISPATCHER_CONFIG
• 7.156 V$DISPATCHER_RATE
• 7.157 V$DNFS_CHANNELS
• 7.158 V$DNFS_FILES
• 7.159 V$DNFS_SERVERS
• 7.160 V$DNFS_STATS
• 7.161 V$DYNAMIC_REMASTER_STATS
• 7.162 V$EDITIONABLE_TYPES
• 7.163 V$EMON
• 7.164 V$EMX_USAGE_STATS
• 7.165 V$ENABLEDPRIVS
• 7.166 V$ENCRYPTED_TABLESPACES
• 7.167 V$ENCRYPTION_KEYS
• 7.168 V$ENCRYPTION_WALLET
• 7.169 V$ENQUEUE_LOCK
• 7.170 V$ENQUEUE_STAT
• 7.171 V$ENQUEUE_STATISTICS
• 7.172 V$EVENT_HISTOGRAM
• 7.173 V$EVENT_HISTOGRAM_MICRO
• 7.174 V$EVENT_NAME
• 7.175 V$EVENTMETRIC
• 7.176 V$EXECUTION
• 7.177 V$FALSE_PING
• 7.178 V$FAST_START_SERVERS
• 7.179 V$FAST_START_TRANSACTIONS
• 7.180 V$FILE_CACHE_TRANSFER
• 7.181 V$FILE_HISTOGRAM
• 7.182 V$FILEMETRIC
• 7.183 V$FILEMETRIC_HISTORY
• 7.184 V$FILESPACE_USAGE
• 7.185 V$FILESTAT
• 7.186 V$FIXED_TABLE
• 7.187 V$FIXED_VIEW_DEFINITION
• 7.188 V$FLASHBACK_DATABASE_LOG
• 7.189 V$FLASHBACK_DATABASE_LOGFILE
• 7.190 V$FLASHBACK_DATABASE_STAT
• 7.191 V$FLASHBACK_TXN_GRAPH
• 7.192 V$FLASHBACK_TXN_MODS
• 7.193 V$FLASHFILESTAT
• 7.194 V$FOREIGN_ARCHIVED_LOG
• 7.195 V$FS_FAILOVER_STATS
• 7.196 V$FS_OBSERVER_HISTOGRAM
• 7.197 V$GC_ELEMENT
• 7.198 V$GC_ELEMENTS_WITH_COLLISIONS
• 7.199 V$GCSHVMASTER_INFO
• 7.200 V$GCSPFMASTER_INFO
• 7.201 V$GES_BLOCKING_ENQUEUE
• 7.202 V$GES_CONVERT_LOCAL
• 7.203 V$GES_CONVERT_REMOTE
• 7.204 V$GES_ENQUEUE
• 7.205 V$GES_LATCH
• 7.206 V$GES_RESOURCE
• 7.207 V$GES_STATISTICS
• 7.208 V$GG_APPLY_COORDINATOR
• 7.209 V$GG_APPLY_READER
• 7.210 V$GG_APPLY_RECEIVER
• 7.211 V$GG_APPLY_SERVER
• 7.212 V$GLOBAL_BLOCKED_LOCKS
• 7.213 V$GLOBAL_TRANSACTION
• 7.214 V$GOLDENGATE_CAPTURE
• 7.215 V$GOLDENGATE_MESSAGE_TRACKING
• 7.216 V$GOLDENGATE_TABLE_STATS
• 7.217 V$GOLDENGATE_TRANSACTION
• 7.218 V$HANG_INFO
• 7.219 V$HANG_SESSION_INFO
• 7.220 V$HANG_STATISTICS
• 7.221 V$HEAT_MAP_SEGMENT
• 7.222 V$HM_CHECK
• 7.223 V$HM_CHECK_PARAM
• 7.224 V$HM_FINDING
• 7.225 V$HM_INFO
• 7.226 V$HM_RECOMMENDATION
• 7.227 V$HM_RUN
• 7.228 V$HS_AGENT
• 7.229 V$HS_PARAMETER
• 7.230 V$HS_SESSION
• 7.231 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$INDEXED_FIXED_COLUMN
• 8.5 V$INMEMORY_AREA
• 8.6 V$INSTANCE
• 8.7 V$INSTANCE_CACHE_TRANSFER
• 8.8 V$INSTANCE_PING
• 8.9 V$INSTANCE_RECOVERY
• 8.10 V$IO_CALIBRATION_STATUS
• 8.11 V$IO_OUTLIER
• 8.12 V$IOFUNCMETRIC
• 8.13 V$IOFUNCMETRIC_HISTORY
• 8.14 V$IOSTAT_CONSUMER_GROUP
• 8.15 V$IOSTAT_FILE
• 8.16 V$IOSTAT_FUNCTION
• 8.17 V$IOSTAT_FUNCTION_DETAIL
• 8.18 V$IOSTAT_NETWORK
• 8.19 V$JAVA_LIBRARY_CACHE_MEMORY
• 8.20 V$JAVA_POOL_ADVICE
• 8.21 V$KERNEL_IO_OUTLIER
• 8.22 V$KEY_VECTOR
• 8.23 V$LATCH
• 8.24 V$LATCH_CHILDREN
• 8.25 V$LATCH_MISSES
• 8.26 V$LATCH_PARENT
• 8.27 V$LATCHHOLDER
• 8.28 V$LATCHNAME
• 8.29 V$LGWRIO_OUTLIER
• 8.30 V$LIBCACHE_LOCKS
• 8.31 V$LIBRARY_CACHE_MEMORY
• 8.32 V$LIBRARYCACHE
• 8.33 V$LICENSE
• 8.34 V$LOADISTAT
• 8.35 V$LOADPSTAT
• 8.36 V$LOCK
• 8.37 V$LOCK_ACTIVITY
• 8.38 V$LOCK_TYPE
• 8.39 V$LOCKED_OBJECT
• 8.40 V$LOG
• 8.41 V$LOG_HISTORY
• 8.42 V$LOGFILE
• 8.43 V$LOGHIST
• 8.44 V$LOGMNR_CONTENTS
• 8.45 V$LOGMNR_DICTIONARY
• 8.46 V$LOGMNR_DICTIONARY_LOAD
• 8.47 V$LOGMNR_LATCH
• 8.48 V$LOGMNR_LOGS
• 8.49 V$LOGMNR_PARAMETERS
• 8.50 V$LOGMNR_PROCESS
• 8.51 V$LOGMNR_SESSION
• 8.52 V$LOGMNR_STATS
• 8.53 V$LOGSTDBY
• 8.54 V$LOGSTDBY_PROCESS
• 8.55 V$LOGSTDBY_PROGRESS
• 8.56 V$LOGSTDBY_STATE
• 8.57 V$LOGSTDBY_STATS
• 8.58 V$LOGSTDBY_TRANSACTION
• 8.59 V$MANAGED_STANDBY
• 8.60 V$MAP_COMP_LIST
• 8.61 V$MAP_ELEMENT
• 8.62 V$MAP_EXT_ELEMENT
• 8.63 V$MAP_FILE
• 8.64 V$MAP_FILE_EXTENT
• 8.65 V$MAP_FILE_IO_STACK
• 8.66 V$MAP_LIBRARY
• 8.67 V$MAP_SUBELEMENT
• 8.68 V$MAPPED_SQL
• 8.69 V$MEMORY_CURRENT_RESIZE_OPS
• 8.70 V$MEMORY_DYNAMIC_COMPONENTS
• 8.71 V$MEMORY_RESIZE_OPS
• 8.72 V$MEMORY_TARGET_ADVICE
• 8.73 V$METRIC
• 8.74 V$METRICGROUP
• 8.75 V$METRIC_HISTORY
• 8.76 V$METRICNAME
• 8.77 V$MTTR_TARGET_ADVICE
• 8.78 V$MUTEX_SLEEP
• 8.79 V$MUTEX_SLEEP_HISTORY
• 8.80 V$MVREFRESH
• 8.81 V$MYSTAT
• 8.82 V$NFS_CLIENTS
• 8.83 V$NFS_LOCKS
• 8.84 V$NFS_OPEN_FILES
• 8.85 V$NLS_PARAMETERS
• 8.86 V$NLS_VALID_VALUES
• 8.87 V$NONLOGGED_BLOCK
• 8.88 V$OBJECT_DEPENDENCY
• 8.89 V$OBJECT_PRIVILEGE
• 8.90 V$OBJECT_USAGE
• 8.91 V$OBSOLETE_BACKUP_FILES
• 8.92 V$OBSOLETE_PARAMETER
• 8.93 V$OFFLINE_RANGE
• 8.94 V$OPEN_CURSOR
• 8.95 V$OPTIMIZER_PROCESSING_RATE
• 8.96 V$OPTION
• 8.97 V$OSSTAT
• 8.98 V$PARALLEL_DEGREE_LIMIT_MTH
• 8.99 V$PARAMETER
• 8.100 V$PARAMETER_VALID_VALUES
• 8.101 V$PARAMETER2
• 8.102 V$PATCHES
• 8.103 V$PDB_INCARNATION
• 8.104 V$PDBS
• 8.105 V$PERSISTENT_PUBLISHERS
• 8.106 V$PERSISTENT_QMN_CACHE
• 8.107 V$PERSISTENT_QUEUES
• 8.108 V$PERSISTENT_SUBSCRIBERS
• 8.109 V$PGA_TARGET_ADVICE
• 8.110 V$PGA_TARGET_ADVICE_HISTOGRAM
• 8.111 V$PGASTAT
• 8.112 V$PQ_SESSTAT
• 8.113 V$PQ_SLAVE
• 8.114 V$PQ_SYSSTAT
• 8.115 V$PQ_TQSTAT
• 8.116 V$PROCESS
• 8.117 V$PROCESS_MEMORY
• 8.118 V$PROPAGATION_RECEIVER
• 8.119 V$PROPAGATION_SENDER
• 8.120 V$PROXY_ARCHIVEDLOG
• 8.121 V$PROXY_ARCHIVELOG_DETAILS
• 8.122 V$PROXY_ARCHIVELOG_SUMMARY
• 8.123 V$PROXY_COPY_DETAILS
• 8.124 V$PROXY_COPY_SUMMARY
• 8.125 V$PROXY_DATAFILE
• 8.126 V$PWFILE_USERS
• 8.127 V$PX_INSTANCE_GROUP
• 8.128 V$PX_PROCESS
• 8.129 V$PX_PROCESS_SYSSTAT
• 8.130 V$PX_SESSION
• 8.131 V$PX_SESSTAT
• 8.132 V$QMON_COORDINATOR_STATS
• 8.133 V$QMON_SERVER_STATS
• 8.134 V$QMON_TASK_STATS
• 8.135 V$QMON_TASKS
• 8.136 V$QUEUE
• 8.137 V$QUEUEING_MTH
• 8.138 V$RECOVER_FILE
• 8.139 V$RECOVERY_AREA_USAGE
• 8.140 V$RECOVERY_FILE_DEST
• 8.141 V$RECOVERY_FILE_STATUS
• 8.142 V$RECOVERY_LOG
• 8.143 V$RECOVERY_PROGRESS
• 8.144 V$RECOVERY_STATUS
• 8.145 V$REDO_DEST_RESP_HISTOGRAM
• 8.146 V$REPLPROP
• 8.147 V$REPLQUEUE
• 8.148 V$REQDIST
• 8.149 V$RESERVED_WORDS
• 8.150 V$RESOURCE
• 8.151 V$RESOURCE_LIMIT
• 8.152 V$RESTORE_POINT
• 8.153 V$RESULT_CACHE_DEPENDENCY
• 8.154 V$RESULT_CACHE_MEMORY
• 8.155 V$RESULT_CACHE_OBJECTS
• 8.156 V$RESULT_CACHE_STATISTICS
• 8.157 V$RMAN_BACKUP_JOB_DETAILS
• 8.158 V$RMAN_BACKUP_SUBJOB_DETAILS
• 8.159 V$RMAN_BACKUP_TYPE
• 8.160 V$RMAN_COMPRESSION_ALGORITHM
• 8.161 V$RMAN_CONFIGURATION
• 8.162 V$RMAN_ENCRYPTION_ALGORITHMS
• 8.163 V$RMAN_OUTPUT
• 8.164 V$RMAN_STATUS
• 8.165 V$RO_USER_ACCOUNT
• 8.166 V$ROLLNAME
• 8.167 V$ROLLSTAT
• 8.168 V$ROWCACHE
• 8.169 V$ROWCACHE_PARENT
• 8.170 V$ROWCACHE_SUBORDINATE
• 8.171 V$RSRC_CONS_GROUP_HISTORY
• 8.172 V$RSRC_CONSUMER_GROUP
• 8.173 V$RSRC_CONSUMER_GROUP_CPU_MTH
• 8.174 V$RSRC_PLAN
• 8.175 V$RSRC_PLAN_CPU_MTH
• 8.176 V$RSRC_PLAN_HISTORY
• 8.177 V$RSRC_SESSION_INFO
• 8.178 V$RSRCMGRMETRIC
• 8.179 V$RSRCMGRMETRIC_HISTORY
• 8.180 V$RULE
• 8.181 V$RULE_SET
• 8.182 V$RULE_SET_AGGREGATE_STATS

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

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

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 enqueue
  • C.3.51 flashback buf free by RVWR
  • C.3.52 flashback logfile sync
  • C.3.53 free buffer waits
  • C.3.54 free global transaction table entry
  • C.3.55 free process state object
  • C.3.56 gc recovery quiesce
  • C.3.57 GCS lock open S
  • C.3.58 GCS lock open X
  • C.3.59 gcs remastering wait for drop pkey
  • C.3.60 global cache busy
  • C.3.61 global cache lock cleanup
  • C.3.62 global cache freelist
  • C.3.63 inactive session
  • C.3.64 inactive transaction branch
  • C.3.65 index block split
  • C.3.66 instance state change
  • C.3.67 io done
  • C.3.68 kcl bg acks
  • C.3.69 ksxr wait for mount shared
  • C.3.70 ktm: instance recovery
  • C.3.71 latch activity
  • C.3.72 latch free
  • C.3.73 library cache load lock
  • C.3.74 library cache lock
  • C.3.75 library cache pin
  • C.3.76 library cache shutdown
  • C.3.77 LMON global data update
  • C.3.78 lock manager wait for remote message
  • C.3.79 Log archive I/O
  • C.3.80 log buffer space
  • C.3.81 log file parallel write
  • C.3.82 log file sequential read
  • C.3.83 log file single write
  • C.3.84 log file switch (archiving needed)
  • C.3.85 log file switch (checkpoint incomplete)
  • C.3.86 log file switch (clearing log file)
  • C.3.87 log file switch (private strand flush incomplete)
  • C.3.88 log file switch completion
  • C.3.89 log file sync
  • C.3.90 log switch/archive
  • C.3.91 optimizer stats update retry
  • C.3.92 parallel recovery change buffer free
  • C.3.93 parallel recovery control message reply
  • C.3.94 parallel recovery coord send blocked
  • C.3.95 parallel recovery coord wait for reply
  • C.3.96 parallel recovery coordinator waits for slave cleanup
  • C.3.97 parallel recovery read buffer free
  • C.3.98 parallel recovery slave next change
  • C.3.99 pending global transaction(s)
  • C.3.100 pipe get
  • C.3.101 pipe put
  • C.3.102 PL/SQL lock timer
  • C.3.103 pmon timer
  • C.3.104 prewarm transfer retry
  • C.3.105 prior process spawner to be cleaned up
  • C.3.106 process startup
  • C.3.107 PX Deque wait
  • C.3.108 PX qref latch
  • C.3.109 PX server shutdown
  • C.3.110 PX signal server
  • C.3.111 rdbms ipc message
  • C.3.112 rdbms ipc message block
  • C.3.113 rdbms ipc reply
  • C.3.114 read by other session
  • C.3.115 recovery read
  • C.3.116 Redo Transport Attach
  • C.3.117 Redo Transport Close
  • C.3.118 Redo Transport Detach
  • C.3.119 Redo Transport Open
  • C.3.120 Redo Transport Ping
  • C.3.121 Redo Transport Slave Shutdown
  • C.3.122 Redo Transport Slave Startup
  • C.3.123 Redo Writer Remote Sync Complete
  • C.3.124 Redo Write Remote Sync Notify
  • C.3.125 Remote Sync Ping
  • C.3.126 resmgr:become active
  • C.3.127 resmgr:cpu quantum
  • C.3.128 resmgr:pq queued
  • C.3.129 rolling migration: cluster quiesce
  • C.3.130 row cache lock
  • C.3.131 RVWR wait for flashback copy
  • C.3.132 sbtbufinfo
  • C.3.133 sbtgetbuf
  • C.3.134 sbtmapbuf
  • C.3.135 sbtrelbuf
  • C.3.136 scginq AST call
  • C.3.137 SGA: allocation forcing component growth
  • C.3.138 SGA: MMAN sleep for component shrink
  • C.3.139 SGA: sga_target resize
  • C.3.140 Shared IO Pool Memory
  • C.3.141 shared server idle wait
  • C.3.142 single-task message
  • C.3.143 smon timer
  • C.3.144 SQL*Net break/reset to client
  • C.3.145 SQL*Net break/reset to dblink
  • C.3.146 SQL*Net message from client
  • C.3.147 SQL*Net message from dblink
  • C.3.148 SQL*Net message to client
  • C.3.149 SQL*Net message to dblink
  • C.3.150 SQL*Net more data from client
  • C.3.151 SQL*Net more data from dblink
  • C.3.152 SQL*Net more data to client
  • C.3.153 SQL*Net more data to dblink
  • C.3.154 Streams AQ: waiting for messages in the queue
  • C.3.155 switch logfile command
  • C.3.156 SYNC Remote Write
  • C.3.157 TCP Socket (KGAS)
  • C.3.158 timer in sksawat
  • C.3.159 transaction
  • C.3.160 unbound tx
  • C.3.161 undo_retention publish retry
  • C.3.162 undo segment extension
  • C.3.163 undo segment recovery
  • C.3.164 undo segment tx slot
  • C.3.165 utl_file I/O
  • C.3.166 virtual circuit status
  • C.3.167 virtual circuit wait
  • C.3.168 WCR: replay client notify
  • C.3.169 WCR: replay clock
  • C.3.170 WCR: replay lock order
  • C.3.171 WCR: replay paused
  • C.3.172 WCR: Sync context busy
  • C.3.173 WMON goes to sleep
  • C.3.174 write complete waits
  • C.3.175 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