Index
A B C D E F G H I J L M N O P Q R S T U V W X
A
- ACTIVE_INSTANCE_COUNT initialization parameter, 1.7
- ALL_ALL_TABLES view, 2.3
- ALL_APPLY view, 2.4
- ALL_APPLY_CHANGE_HANDLERS view, 2.5
- ALL_APPLY_CONFLICT_COLUMNS view, 2.6
- ALL_APPLY_DML_HANDLERS view, 2.7
- ALL_APPLY_ENQUEUE view, 2.8
- ALL_APPLY_ERROR view, 2.9
- ALL_APPLY_ERROR_MESSAGES view, 2.10
- ALL_APPLY_EXECUTE view, 2.11
- ALL_APPLY_KEY_COLUMNS view, 2.12
- ALL_APPLY_PARAMETERS view, 2.13
- ALL_APPLY_PROGRESS view, 2.14
- ALL_APPLY_TABLE_COLUMNS view, 2.15
- ALL_ARGUMENTS view, 2.16
- ALL_ASSEMBLIES view, 2.17
- ALL_ASSOCIATIONS view, 2.18
- ALL_AUDIT_POLICIES view, 2.19
- ALL_AUDIT_POLICY_COLUMNS view, 2.20
- ALL_AW_PS view, 2.21
- ALL_AWS view, 2.22
- ALL_BASE_TABLE_MVIEWS view, 2.23
- ALL_CAPTURE view, 2.24
- ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.25
- ALL_CAPTURE_PARAMETERS view, 2.26
- ALL_CAPTURE_PREPARED_DATABASE view, 2.27
- ALL_CAPTURE_PREPARED_SCHEMAS view, 2.28
- ALL_CAPTURE_PREPARED_TABLES view, 2.29
- ALL_CATALOG view, 2.30
- ALL_CHANGE_PROPAGATION_SETS view, 2.31
-
- CHANGE_PROPAGATION_SETS synonym, 3.150
- ALL_CHANGE_PROPAGATIONS view, 2.32
-
- CHANGE_PROPAGATIONS synonym, 3.151
- ALL_CHANGE_SETS view, 2.33
-
- CHANGE_SETS synonym, 3.152
- ALL_CHANGE_SOURCES view, 2.34
-
- CHANGE_SOURCES synonym, 3.153
- ALL_CHANGE_TABLES view, 2.35
-
- CHANGE_TABLES synonym, 3.154
- ALL_CLUSTER_HASH_EXPRESSIONS view, 2.36
- ALL_CLUSTERS view, 2.37
- ALL_COL_COMMENTS view, 2.38
- ALL_COL_PENDING_STATS view, 2.39
- ALL_COL_PRIVS view, 2.40
- ALL_COL_PRIVS_MADE view, 2.41
- ALL_COL_PRIVS_RECD view, 2.42
- ALL_COLL_TYPES view, 2.43
- ALL_CONS_COLUMNS view, 2.44
- ALL_CONS_OBJ_COLUMNS view, 2.45
- ALL_CONSTRAINTS view, 2.46
- ALL_CONTEXT view, 2.47
- ALL_CUBE_ATTR_VISIBILITY view, 2.48
- ALL_CUBE_ATTRIBUTES view, 2.49
- ALL_CUBE_BUILD_PROCESSES view, 2.50
- ALL_CUBE_CALCULATED_MEMBERS view, 2.51
- ALL_CUBE_DIM_LEVELS view, 2.52
- ALL_CUBE_DIM_MODELS view, 2.53
- ALL_CUBE_DIM_VIEW_COLUMNS view, 2.54
- ALL_CUBE_DIM_VIEWS view, 2.55
- ALL_CUBE_DIMENSIONALITY view, 2.56
- ALL_CUBE_DIMENSIONS view, 2.57
- ALL_CUBE_HIER_LEVELS view, 2.58
- ALL_CUBE_HIER_VIEW_COLUMNS view, 2.59
- ALL_CUBE_HIER_VIEWS view, 2.60
- ALL_CUBE_HIERARCHIES view, 2.61
- ALL_CUBE_MEASURES view, 2.62
- ALL_CUBE_VIEW_COLUMNS view, 2.63
- ALL_CUBE_VIEWS view, 2.64
- ALL_CUBES view, 2.65
- ALL_DB_LINKS view, 2.66
- ALL_DEF_AUDIT_OPTS view, 2.67
- ALL_DEPENDENCIES view, 2.68
- ALL_DEQUEUE_QUEUES view, 2.69
- ALL_DIM_ATTRIBUTES view, 2.70
- ALL_DIM_CHILD_OF view, 2.71
- ALL_DIM_HIERARCHIES view, 2.72
- ALL_DIM_JOIN_KEY view, 2.73
- ALL_DIM_LEVEL_KEY view, 2.74
- ALL_DIM_LEVELS view, 2.75
- ALL_DIMENSIONS view, 2.76
- ALL_DIRECTORIES view, 2.77
- ALL_EDITION_COMMENTS view, 2.78
- ALL_EDITIONING_VIEW_COLS view, 2.79
- ALL_EDITIONING_VIEW_COLS_AE view, 2.80
- ALL_EDITIONING_VIEWS view, 2.81
- ALL_EDITIONING_VIEWS_AE view, 2.82
- ALL_EDITIONS view, 2.83
- ALL_ENCRYPTED_COLUMNS view, 2.84
- ALL_ERRORS view, 2.85
- ALL_ERRORS_AE view, 2.86
- ALL_EVALUATION_CONTEXT_TABLES view, 2.87
- ALL_EVALUATION_CONTEXT_VARS view, 2.88
- ALL_EVALUATION_CONTEXTS view, 2.89
- ALL_EXTERNAL_LOCATIONS view, 2.90
- ALL_EXTERNAL_TABLES view, 2.91
- ALL_FILE_GROUP_EXPORT_INFO view, 2.92
- ALL_FILE_GROUP_FILES view, 2.93
- ALL_FILE_GROUP_TABLES view, 2.94
- ALL_FILE_GROUP_TABLESPACES view, 2.95
- ALL_FILE_GROUP_VERSIONS view, 2.96
- ALL_FILE_GROUPS view, 2.97
- ALL_HISTOGRAMS synonym for ALL_TAB_HISTOGRAMS, 2.98
- ALL_IDENTIFIERS view, 2.99
- ALL_IND_COLUMNS view, 2.100
- ALL_IND_EXPRESSIONS view, 2.101
- ALL_IND_PARTITIONS view, 2.102
- ALL_IND_PENDING_STATS view, 2.103
- ALL_IND_STATISTICS view, 2.104
- ALL_IND_SUBPARTITIONS view, 2.105
- ALL_INDEXES view, 2.106
- ALL_INDEXTYPE_ARRAYTYPES view, 2.107
- ALL_INDEXTYPE_COMMENTS view, 2.108
- ALL_INDEXTYPE_OPERATORS view, 2.109
- ALL_INDEXTYPES view, 2.110
- ALL_INTERNAL_TRIGGERS view, 2.111
- ALL_JAVA_ARGUMENTS view, 2.112
- ALL_JAVA_CLASSES view, 2.113
- ALL_JAVA_COMPILER_OPTIONS view, 2.114
- ALL_JAVA_DERIVATIONS view, 2.115
- ALL_JAVA_FIELDS view, 2.116
- ALL_JAVA_IMPLEMENTS view, 2.117
- ALL_JAVA_INNERS view, 2.118
- ALL_JAVA_LAYOUTS view, 2.119
- ALL_JAVA_METHODS view, 2.120
- ALL_JAVA_NCOMPS view, 2.121
- ALL_JAVA_RESOLVERS view, 2.122
- ALL_JAVA_THROWS view, 2.123
- ALL_JOBS synonym for USER_JOBS view, 2.124
- ALL_JOIN_IND_COLUMNS view, 2.125
- ALL_LIBRARIES view, 2.126
- ALL_LOB_PARTITIONS view, 2.127
- ALL_LOB_SUBPARTITIONS view, 2.128
- ALL_LOB_TEMPLATES view, 2.129
- ALL_LOBS view, 2.130
- ALL_LOG_GROUP_COLUMNS view, 2.131
- ALL_LOG_GROUPS view, 2.132
- ALL_MEASURE_FOLDER_CONTENTS view, 2.133
- ALL_MEASURE_FOLDERS view, 2.134
- ALL_METHOD_PARAMS view, 2.135
- ALL_METHOD_RESULTS view, 2.136
- ALL_MINING_MODEL_ATTRIBUTES view, 2.137
- ALL_MINING_MODEL_SETTINGS view, 2.138
- ALL_MINING_MODELS view, 2.139
- ALL_MP_GRAPH_WORKSPACES view, 2.1.2
- ALL_MP_PARENT_WORKSPACES view, 2.1.2
- ALL_MVIEW_AGGREGATES view, 2.140
- ALL_MVIEW_ANALYSIS view, 2.141
- ALL_MVIEW_COMMENTS view, 2.142
- ALL_MVIEW_DETAIL_PARTITION view, 2.143
- ALL_MVIEW_DETAIL_RELATIONS view, 2.144
- ALL_MVIEW_DETAIL_SUBPARTITION view, 2.145
- ALL_MVIEW_JOINS view, 2.146
- ALL_MVIEW_KEYS view, 2.147
- ALL_MVIEW_LOGS view, 2.148
- ALL_MVIEW_REFRESH_TIMES view, 2.149
- ALL_MVIEWS view, 2.150
- ALL_NESTED_TABLE_COLS view, 2.151
- ALL_NESTED_TABLES view, 2.152
- ALL_OBJ_COLATTRS view, 2.153
- ALL_OBJECT_TABLES view, 2.154
- ALL_OBJECTS view, 2.155
- ALL_OBJECTS_AE view, 2.156
- ALL_OPANCILLARY view, 2.157
- ALL_OPARGUMENTS view, 2.158
- ALL_OPBINDINGS view, 2.159
- ALL_OPERATOR_COMMENTS view, 2.160
- ALL_OPERATORS view, 2.161
- ALL_OUTLINE_HINTS synonym for USER_OUTLINE_HINTS view, 2.162
- ALL_OUTLINES synonym for USER_OUTLINES view, 2.163
- ALL_PART_COL_STATISTICS view, 3.1
- ALL_PART_HISTOGRAMS view, 3.2
- ALL_PART_INDEXES view, 3.3
- ALL_PART_KEY_COLUMNS view, 3.4
- ALL_PART_LOBS view, 3.5
- ALL_PART_TABLES view, 3.6
- ALL_PARTIAL_DROP_TABS view, 3.7
- ALL_PENDING_CONV_TABLES view, 3.8
- ALL_PLSQL_OBJECT_SETTINGS view, 3.9
- ALL_POLICIES view, 3.10
- ALL_POLICY_CONTEXTS view, 3.11
- ALL_POLICY_GROUPS view, 3.12
- ALL_PROCEDURES view, 3.13
- ALL_PROPAGATION view, 3.14
- ALL_PUBLISHED_COLUMNS synonym for USER_PUBLISHED_COLUMNS view, 3.15
- ALL_QUEUE_SCHEDULES view, 3.16
- ALL_QUEUE_SUBSCRIBERS view, 3.17
- ALL_QUEUE_TABLES view, 3.18
- ALL_QUEUES view, 3.19
- ALL_REFRESH view, 3.20
- ALL_REFRESH_CHILDREN view, 3.21
- ALL_REFRESH_DEPENDENCIES view, 3.22
- ALL_REFS view, 3.23
- ALL_REGISTERED_MVIEWS view, 3.24
- ALL_REGISTRY_BANNERS view, 3.25
- ALL_REMOVED_WORKSPACES view, 2.1.2
- ALL_REPCAT view, 2.1.1
- ALL_REPCAT_REFRESH_TEMPLATES view, 2.1.1
- ALL_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
- ALL_REPCAT_TEMPLATE_PARMS view, 2.1.1
- ALL_REPCAT_TEMPLATE_SITES view, 2.1.1
- ALL_REPCAT_USER_AUTHORIZATIONS view, 2.1.1
- ALL_REPCAT_USER_PARM_VALUES view, 2.1.1
- ALL_REPCATLOG view, 2.1.1
- ALL_REPCOLUMN view, 2.1.1
- ALL_REPCOLUMN_GROUP view, 2.1.1
- ALL_REPCONFLICT view, 2.1.1
- ALL_REPDDL view, 2.1.1
- ALL_REPFLAVOR_COLUMNS view, 2.1.1
- ALL_REPFLAVOR_OBJECTS view, 2.1.1
- ALL_REPFLAVORS view, 2.1.1
- ALL_REPGENERATED view, 2.1.1
- ALL_REPGENOBJECTS view, 2.1.1
- ALL_REPGROUP view, 2.1.1
- ALL_REPGROUP_PRIVILEGES view, 2.1.1
- ALL_REPGROUPED_COLUMN view, 2.1.1
- ALL_REPKEY_COLUMNS view, 2.1.1
- ALL_REPOBJECT view, 2.1.1
- ALL_REPPARAMETER_COLUMN view, 2.1.1
- ALL_REPPRIORITY view, 2.1.1
- ALL_REPPRIORITY_GROUP view, 2.1.1
- ALL_REPPROP view, 2.1.1
- ALL_REPRESOL_STATS_CONTROL view, 2.1.1
- ALL_REPRESOLUTION view, 2.1.1
- ALL_REPRESOLUTION_METHOD view, 2.1.1
- ALL_REPRESOLUTION_STATISTICS view, 2.1.1
- ALL_REPSCHEMA view, 2.1.1
- ALL_REPSITES view, 2.1.1
- ALL_REWRITE_EQUIVALENCES view, 3.26
- ALL_RULE_SET_RULES view, 3.27
- ALL_RULE_SETS view, 3.28
- ALL_RULES view, 3.29
- ALL_SCHEDULER_CHAIN_RULES view, 3.30
- ALL_SCHEDULER_CHAIN_STEPS view, 3.31
- ALL_SCHEDULER_CHAINS view, 3.32
- ALL_SCHEDULER_CREDENTIALS view, 3.33
- ALL_SCHEDULER_DB_DESTS view, 3.34
- ALL_SCHEDULER_DESTS view, 3.35
- ALL_SCHEDULER_EXTERNAL_DESTS view, 3.36
- ALL_SCHEDULER_FILE_WATCHERS view, 3.37
- ALL_SCHEDULER_GLOBAL_ATTRIBUTE view, 3.38
- ALL_SCHEDULER_GROUP_MEMBERS view, 3.39
- ALL_SCHEDULER_GROUPS view, 3.40
- ALL_SCHEDULER_JOB_ARGS view, 3.41
- ALL_SCHEDULER_JOB_CLASSES view, 3.42
- ALL_SCHEDULER_JOB_DESTS view, 3.43
- ALL_SCHEDULER_JOB_LOG view, 3.44
- ALL_SCHEDULER_JOB_RUN_DETAILS view, 3.45
- ALL_SCHEDULER_JOBS view, 3.46
- ALL_SCHEDULER_NOTIFICATIONS view, 3.47
- ALL_SCHEDULER_PROGRAM_ARGS view, 3.48
- ALL_SCHEDULER_PROGRAMS view, 3.49
- ALL_SCHEDULER_REMOTE_DATABASES view, 3.50
- ALL_SCHEDULER_REMOTE_JOBSTATE view, 3.51
- ALL_SCHEDULER_RUNNING_CHAINS view, 3.52
- ALL_SCHEDULER_RUNNING_JOBS view, 3.53
- ALL_SCHEDULER_SCHEDULES view, 3.54
- ALL_SCHEDULER_WINDOW_DETAILS view, 3.55
- ALL_SCHEDULER_WINDOW_GROUPS view, 3.56
- ALL_SCHEDULER_WINDOW_LOG view, 3.57
- ALL_SCHEDULER_WINDOWS view, 3.58
- ALL_SCHEDULER_WINGROUP_MEMBERS view, 3.59
- ALL_SEC_RELEVANT_COLS view, 3.60
- ALL_SECONDARY_OBJECTS view, 3.61
- ALL_SEQUENCES view, 3.62
- ALL_SERVICES view, 3.63
- ALL_SOURCE view, 3.64
- ALL_SOURCE_AE view, 3.65
- ALL_SOURCE_TABLES synonym for USER_SOURCE_TABLES view, 3.66
- ALL_SQLJ_TYPE_ATTRS view, 3.67
- ALL_SQLJ_TYPE_METHODS view, 3.68
- ALL_SQLJ_TYPES view, 3.69
- ALL_SQLSET view, 3.70
- ALL_SQLSET_BINDS view, 3.71
- ALL_SQLSET_PLANS view, 3.72
- ALL_SQLSET_REFERENCES view, 3.73
- ALL_SQLSET_STATEMENTS view, 3.74
- ALL_STAT_EXTENSIONS view, 3.75
- ALL_STORED_SETTINGS view, 3.76
- ALL_STREAMS_COLUMNS view, 3.77
- ALL_STREAMS_GLOBAL_RULES view, 3.78
- ALL_STREAMS_MESSAGE_CONSUMERS view, 3.79
- ALL_STREAMS_MESSAGE_RULES view, 3.80
- ALL_STREAMS_NEWLY_SUPPORTED view, 3.81
- ALL_STREAMS_RULES view, 3.82
- ALL_STREAMS_SCHEMA_RULES view, 3.83
- ALL_STREAMS_STMT_HANDLERS view, 3.84
- ALL_STREAMS_STMTS view, 3.85
- ALL_STREAMS_TABLE_RULES view, 3.86
- ALL_STREAMS_TRANSFORM_FUNCTION view, 3.87
- ALL_STREAMS_UNSUPPORTED view, 3.88
- ALL_SUBPART_COL_STATISTICS view, 3.89
- ALL_SUBPART_HISTOGRAMS view, 3.90
- ALL_SUBPART_KEY_COLUMNS view, 3.91
- ALL_SUBPARTITION_TEMPLATES view, 3.92
- ALL_SUBSCRIBED_COLUMNS synonym for USER_SUBSCRIBED_COLUMNS view, 3.93
- ALL_SUBSCRIBED_TABLES synonym for USER_SUBSCRIBED_TABLES view, 3.94
- ALL_SUBSCRIPTIONS synonym for USER_SUBSCRIPTIONS view, 3.95
- ALL_SUMDELTA view, 3.96
- ALL_SYNC_CAPTURE view, 3.97
- ALL_SYNC_CAPTURE_PREPARED_TABS view, 3.98
- ALL_SYNC_CAPTURE_TABLES view, 3.99
- ALL_SYNONYMS view, 3.100
- ALL_TAB_COL_STATISTICS view, 3.101
- ALL_TAB_COLS view, 3.102
- ALL_TAB_COLUMNS view, 3.103
- ALL_TAB_COMMENTS view, 3.104
- ALL_TAB_HISTGRM_PENDING_STATS view, 3.105
- ALL_TAB_HISTOGRAMS view, 3.106
-
- ALL_HISTOGRAMS synonym, 2.98
- ALL_TAB_MODIFICATIONS view, 3.107
- ALL_TAB_PARTITIONS view, 3.108
- ALL_TAB_PENDING_STATS view, 3.109
- ALL_TAB_PRIVS view, 3.110
- ALL_TAB_PRIVS_MADE view, 3.111
- ALL_TAB_PRIVS_RECD view, 3.112
- ALL_TAB_STAT_PREFS view, 3.113
- ALL_TAB_STATISTICS view, 3.114
- ALL_TAB_STATS_HISTORY view, 3.115
- ALL_TAB_SUBPARTITIONS view, 3.116
- ALL_TABLES view, 3.117
- ALL_TRIGGER_COLS view, 3.118
- ALL_TRIGGER_ORDERING view, 3.119
- ALL_TRIGGERS view, 3.120
- ALL_TSTZ_TAB_COLS view, 3.121
- ALL_TSTZ_TABLES view, 3.122
- ALL_TYPE_ATTRS view, 3.123
- ALL_TYPE_METHODS view, 3.124
- ALL_TYPE_VERSIONS view, 3.125
- ALL_TYPES view, 3.126
- ALL_UNUSED_COL_TABS view, 3.127
- ALL_UPDATABLE_COLUMNS view, 3.128
- ALL_USERS view, 3.129
- ALL_USTATS view, 3.130
- ALL_VARRAYS view, 3.131
- ALL_VERSION_HVIEW view, 2.1.2
- ALL_VIEWS view, 3.132
- ALL_VIEWS_AE view, 3.133
- ALL_WARNING_SETTINGS view, 3.134
- ALL_WM_CONS_COLUMNS view, 2.1.2
- ALL_WM_CONSTRAINTS view, 2.1.2
- ALL_WM_IND_COLUMNS view, 2.1.2
- ALL_WM_IND_EXPRESSIONS view, 2.1.2
- ALL_WM_LOCKED_TABLES view, 2.1.2
- ALL_WM_MODIFIED_TABLES view, 2.1.2
- ALL_WM_RIC_INFO view, 2.1.2
- ALL_WM_TAB_TRIGGERS view, 2.1.2
- ALL_WM_VERSIONED_TABLES view, 2.1.2
- ALL_WM_VT_ERRORS view, 2.1.2
- ALL_WORKSPACE_PRIVS view, 2.1.2
- ALL_WORKSPACE_SAVEPOINTS view, 2.1.2
- ALL_WORKSPACES view, 2.1.2
- ALL_XML_INDEXES view, 3.135
- ALL_XML_SCHEMAS view, 3.136
- ALL_XML_TAB_COLS view, 3.137
- ALL_XML_TABLES view, 3.138
- ALL_XML_VIEW_COLS view, 3.139
- ALL_XML_VIEWS view, 3.140
- ALL_XSTREAM_INBOUND view, 3.141
- ALL_XSTREAM_INBOUND_PROGRESS view, 3.142
- ALL_XSTREAM_OUTBOUND view, 3.143
- ALL_XSTREAM_OUTBOUND_PROGRESS view, 3.144
- ALL_XSTREAM_RULES view, 3.145
- ALLOCATE EXTENT clause
-
- of ALTER TABLE
-
- instance number, 1.102
- ALTER DATABASE statement
-
- ADD LOGFILE, 1.252
- ENABLE THREAD, 1.252
- THREAD, 1.252
- ALTER TABLE statement
-
- allocating extents, 1.102
- ANALYZE statement, 2.106, 2.151, 3.102, 3.103, 3.117, 5.80, 5.148, 6.43, 6.44, 6.56, 6.359, 6.465, 6.466, 6.480
- AQ_TM_PROCESSES initialization parameter, 1.8
- ARCHIVE LOG START statement
-
- automatic archiving, 1.120
- ARCHIVE_LAG_TARGET initialization parameter, 1.9
- archived redo logs
-
- destination file, 1.120
- storage device, 1.120, 1.124
- ARCHIVELOG mode, 1.120
-
- archiving destination, 1.120, 1.124
- ASM_DISKGROUPS initialization parameter, 1.10
- ASM_DISKSTRING initialization parameter, 1.11
- ASM_POWER_LIMIT initialization parameter, 1.12
- ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 1.13
- AUDIT_ACTIONS table, 3.146
- AUDIT_FILE_DEST initialization parameter, 1.14
- AUDIT_SYS_OPERATIONS initialization parameter, 1.15
- AUDIT_SYSLOG_LEVEL initialization parameter, 1.16
- AUDIT_TRAIL initialization parameter, 1.17
- authenticating remote clients, 1.208
- authenticating users, 1.172
B
- BACKGROUND_CORE_DUMP initialization parameter, 1.18
- BACKGROUND_DUMP_DEST initialization parameter, 1.19
- BACKUP_TAPE_IO_SLAVES initialization parameter, 1.20
- BITMAP_MERGE_AREA_SIZE initialization parameter, 1.21
- BLANK_TRIMMING initialization parameter, 1.22
- blocks
-
- redo log, 1.130
- size, 1.44, 1.48, 1.60
C
- cache
-
- dictionary, 8.152, 8.153, 8.154
- statistics, 1.130
- CAT synonym for USER_CATALOG view, 3.147
- CATALOG view, 3.148
- CATALOG.SQL script, B.1
-
- creating V$ views, 7.1
- CATBLOCK.SQL script, B.2
- CATCLUST.SQL script, B.1
- CATDWGRD.SQL script, B.4
- CATEXP7.SQL script, B.2
- CATHS.SQL script, B.2
- CATIO.SQL script, B.2
- CATJAVA.SQL script, B.5
- CATNOADT.SQL script, B.3
- CATNOAUD.SQL script, B.3
- CATNOHS.SQL script, B.3
- CATNOPRT.SQL script, B.3
- CATNOSVM.SQL script, B.3
- CATNSNMP.SQL script, B.3
- CATOCTK.SQL script, B.2
- CATPROC.SQL script, B.1
- CATQUEUE.SQL script, B.2
- CATREP.SQL script, B.2
- CATUPGRD.SQL script, B.4
- CHAINED_ROWS table, 3.149
- CHANGE_PROPAGATION_SETS synonym for ALL_CHANGE_PROPAGATION_SETS view, 3.150
- CHANGE_PROPAGATIONS synonym for ALL_CHANGE_PROPAGATIONS view, 3.151
- CHANGE_SETS synonym for ALL_CHANGE_SETS view, 3.152
- CHANGE_SOURCES synonym for ALL_CHANGE_SOURCES view, 3.153
- CHANGE_TABLES synonym for ALL_CHANGE_TABLES view, 3.154
- characters
-
- numeric group separators, 1.150
- checkpoints
-
- checkpoint interval, 1.130
- statistics, 1.130
- CIRCUITS initialization parameter, 1.23
- CLIENT_RESULT_CACHE_LAG initialization parameter, 1.24
- CLIENT_RESULT_CACHE_SIZE initialization parameter, 1.25
- CLIENT_RESULT_CACHE_STATS$ view, 3.155
- CLU synonym for USER_CLUSTERS view, 3.156
- CLUSTER_DATABASE initialization parameter, 1.26
- CLUSTER_DATABASE_INSTANCES initialization parameter, 1.27
- CLUSTER_INTERCONNECTS initialization parameter, 1.28
- COL view, 3.157
- COLS synonym for USER_TAB_COLUMNS view, 3.158
- COMMIT_LOGGING initialization parameter, 1.29
- COMMIT_POINT_STRENGTH initialization parameter, 1.30
- COMMIT_WAIT initialization parameter, 1.31
- COMMIT_WRITE initialization parameter, 1.32
- COMPATIBLE initialization parameter, 1.33
- contention
-
- block-level, 9.125
- control files
-
- names, 1.35
- specifying, 1.35
- CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.34
- CONTROL_FILES initialization parameter, 1.35
- CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter, 1.36
- CORE_DUMP_DEST initialization parameter, 1.37
- cost-based optimization, 1.167
-
- favoring IN-list iterators, 1.165
- CPU_COUNT initialization parameter, 1.38
- CREATE TABLE statement
-
- FREELIST GROUPS clause, 1.102
- CREATE_BITMAP_AREA_SIZE initialization parameter, 1.39
- CREATE_STORED_OUTLINES initialization parameter, 1.40
- creating
-
- a database
-
- setting block size, 1.44, 1.48, 1.60
- currency, 1.141, 1.142
-
- international currency symbol, 1.146
- CURSOR_BIND_CAPTURE_DESTINATION initialization parameter, 1.41
- CURSOR_SHARING initialization parameter, 1.42
- CURSOR_SPACE_FOR_TIME initialization parameter, 1.43
- cursors
-
- OPEN_CURSORS initialization parameter, 1.159
- shared pool, 1.235
D
- data blocks
-
- reading multiple, 1.54
- size of, 1.44, 1.48, 1.60
- data dictionary, 2
-
- cache, 8.152, 8.153, 8.154
- scripts, B.2
- SQL scripts, B.1
- tables, 2.1
- views
-
- overview, 2.1
- user views, 2
- database writer process (DBWR)
-
- checkpoint, 1.130
- DATABASE_PROPERTIES view, 3.159
- databases
-
- database limits, A
- default language, 1.147
- resource limits, 1.211, 1.213
- datafiles
-
- maximum number, 1.56
- parameter, 1.56
- dates
-
- language used for, 1.144, 1.153, 1.154
- setting SYSDATE, 1.91
- TO_CHAR function, 1.143
- TO_DATE function, 1.143
- DB_BLOCK_BUFFERS initialization parameter, 1.45
- DB_BLOCK_CHECKING initialization parameter, 1.46
- DB_BLOCK_CHECKSUM initialization parameter, 1.47
- DB_BLOCK_SIZE initialization parameter, 1.48
- DB_CACHE_ADVICE initialization parameter, 1.49
- DB_CACHE_SIZE initialization parameter, 1.50
- DB_CREATE_FILE_DEST initialization parameter, 1.51
- DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.52
- DB_DOMAIN initialization parameter, 1.53
- DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.54
- DB_FILE_NAME_CONVERT initialization parameter, 1.55
- DB_FILES initialization parameter, 1.56
- DB_FLASH_CACHE_FILE initialization parameter, 1.57
- DB_FLASH_CACHE_SIZE initialization parameter, 1.58
- DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.59
- DB_KEEP_CACHE_SIZE initialization parameter, 1.60
- DB_LOST_WRITE_PROTECT initialization parameter, 1.61
- DB_NAME initialization parameter, 1.62
- DB_nK_CACHE_SIZE initialization parameter, 1.44
- DB_RECOVERY_FILE_DEST initialization parameter, 1.63
- DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.64
- DB_RECYCLE_CACHE_SIZE initialization parameter, 1.65
- DB_SECUREFILE initialization parameter, 1.66
- DB_ULTRA_SAFE initialization parameter, 1.67
- DB_UNIQUE_NAME initialization parameter, 1.68
- DB_UNRECOVERABLE_SCN_TRACKING initialization parameter, 1.69
- DB_WRITER_PROCESSES initialization parameter, 1.70
- DBA_2PC_NEIGHBORS view, 4.1
- DBA_2PC_PENDING view, 4.2
- DBA_ADDM_FDG_BREAKDOWN view, 4.3
- DBA_ADDM_FINDINGS view, 4.4
- DBA_ADDM_INSTANCES view, 4.5
- DBA_ADDM_SYSTEM_DIRECTIVES view, 4.6
- DBA_ADDM_TASK_DIRECTIVES view, 4.7
- DBA_ADDM_TASKS view, 4.8
- DBA_ADVISOR_ACTIONS view, 4.9
- DBA_ADVISOR_COMMANDS view, 4.10
- DBA_ADVISOR_DEF_PARAMETERS view, 4.11
- DBA_ADVISOR_DEFINITIONS view, 4.12
- DBA_ADVISOR_DIR_DEFINITIONS view, 4.13
- DBA_ADVISOR_DIR_INSTANCES view, 4.14
- DBA_ADVISOR_DIR_TASK_INST view, 4.15
- DBA_ADVISOR_EXEC_PARAMETERS view, 4.16
- DBA_ADVISOR_EXECUTION_TYPES view, 4.17
- DBA_ADVISOR_EXECUTIONS view, 4.18
- DBA_ADVISOR_FDG_BREAKDOWN view, 4.19
- DBA_ADVISOR_FINDING_NAMES view, 4.20
- DBA_ADVISOR_FINDINGS view, 4.21
- DBA_ADVISOR_JOURNAL view, 4.22
- DBA_ADVISOR_LOG view, 4.23
- DBA_ADVISOR_OBJECT_TYPES view, 4.24
- DBA_ADVISOR_OBJECTS view, 4.25
- DBA_ADVISOR_PARAMETERS view, 4.26
- DBA_ADVISOR_RATIONALE view, 4.27
- DBA_ADVISOR_RECOMMENDATIONS view, 4.28
- DBA_ADVISOR_SQLA_REC_SUM view, 4.29
- DBA_ADVISOR_SQLA_TABLES view, 4.30
- DBA_ADVISOR_SQLA_WK_MAP view, 4.31
- DBA_ADVISOR_SQLA_WK_STMTS view, 4.32
- DBA_ADVISOR_SQLPLANS view, 4.33
- DBA_ADVISOR_SQLSTATS view, 4.34
- DBA_ADVISOR_SQLW_JOURNAL view, 4.35
- DBA_ADVISOR_SQLW_PARAMETERS view, 4.36
- DBA_ADVISOR_SQLW_STMTS view, 4.37
- DBA_ADVISOR_SQLW_SUM view, 4.38
- DBA_ADVISOR_SQLW_TABLES view, 4.39
- DBA_ADVISOR_SQLW_TEMPLATES view, 4.40
- DBA_ADVISOR_TASKS view, 4.41
- DBA_ADVISOR_TEMPLATES view, 4.42
- DBA_ADVISOR_USAGE view, 4.43
- DBA_ALERT_HISTORY view, 4.44
- DBA_ALL_TABLES view, 4.45
- DBA_APPLICATION_ROLES view, 4.46
- DBA_APPLY view, 4.47
- DBA_APPLY_CHANGE_HANDLERS view, 4.48
- DBA_APPLY_CONFLICT_COLUMNS view, 4.49
- DBA_APPLY_DML_HANDLERS view, 4.50
- DBA_APPLY_ENQUEUE view, 4.51
- DBA_APPLY_ERROR view, 4.52
- DBA_APPLY_ERROR_MESSAGES view, 4.53
- DBA_APPLY_EXECUTE view, 4.54
- DBA_APPLY_INSTANTIATED_GLOBAL view, 4.55
- DBA_APPLY_INSTANTIATED_OBJECTS view, 4.56
- DBA_APPLY_INSTANTIATED_SCHEMAS view, 4.57
- DBA_APPLY_KEY_COLUMNS view, 4.58
- DBA_APPLY_OBJECT_DEPENDENCIES view, 4.59
- DBA_APPLY_PARAMETERS view, 4.60
- DBA_APPLY_PROGRESS view, 4.61
- DBA_APPLY_SPILL_TXN view, 4.62
- DBA_APPLY_TABLE_COLUMNS view, 4.63
- DBA_APPLY_VALUE_DEPENDENCIES view, 4.64
- DBA_AQ_AGENT_PRIVS view, 4.65
- DBA_AQ_AGENTS view, 4.66
- DBA_ARGUMENTS view, 4.67
- DBA_ASSEMBLIES view, 4.68
- DBA_ASSOCIATIONS view, 4.69
- DBA_ATTRIBUTE_TRANSFORMATIONS view, 4.70
- DBA_AUDIT_EXISTS view, 4.71
- DBA_AUDIT_MGMT_CLEAN_EVENTS view, 4.72
- DBA_AUDIT_MGMT_CLEANUP_JOBS view, 4.73
- DBA_AUDIT_MGMT_CONFIG_PARAMS view, 4.74
- DBA_AUDIT_MGMT_LAST_ARCH_TS view, 4.75
- DBA_AUDIT_OBJECT view, 4.76
- DBA_AUDIT_POLICIES view, 4.77
- DBA_AUDIT_POLICY_COLUMNS view, 4.78
- DBA_AUDIT_SESSION view, 4.79
- DBA_AUDIT_STATEMENT view, 4.80
- DBA_AUDIT_TRAIL view, 4.81
- DBA_AUTO_SEGADV_CTL view, 4.82
- DBA_AUTO_SEGADV_SUMMARY view, 4.83
- DBA_AUTOTASK_CLIENT view, 4.84
- DBA_AUTOTASK_CLIENT_HISTORY view, 4.85
- DBA_AUTOTASK_CLIENT_JOB view, 4.86
- DBA_AUTOTASK_JOB_HISTORY view, 4.87
- DBA_AUTOTASK_OPERATION view, 4.88
- DBA_AUTOTASK_SCHEDULE view, 4.89
- DBA_AUTOTASK_TASK view, 4.90
- DBA_AUTOTASK_WINDOW_CLIENTS view, 4.91
- DBA_AUTOTASK_WINDOW_HISTORY view, 4.92
- DBA_AW_PS view, 4.93
- DBA_AWS view, 4.94
- DBA_BASE_TABLE_MVIEWS view, 4.95
- DBA_BLOCKERS view, 4.96
- DBA_CAPTURE view, 4.97
- DBA_CAPTURE_EXTRA_ATTRIBUTES view, 4.98
- DBA_CAPTURE_PARAMETERS view, 4.99
- DBA_CAPTURE_PREPARED_DATABASE view, 4.100
- DBA_CAPTURE_PREPARED_SCHEMAS view, 4.101
- DBA_CAPTURE_PREPARED_TABLES view, 4.102
- DBA_CATALOG view, 4.103
- DBA_CHANGE_NOTIFICATION_REGS view, 4.104
- DBA_CLU_COLUMNS view, 4.105
- DBA_CLUSTER_HASH_EXPRESSIONS view, 4.106
- DBA_CLUSTERS view, 4.107
- DBA_COL_COMMENTS view, 4.108
- DBA_COL_PENDING_STATS view, 4.109
- DBA_COL_PRIVS view, 4.110
- DBA_COLL_TYPES view, 4.111
- DBA_COMMON_AUDIT_TRAIL view, 4.112
- DBA_COMPARISON view, 4.113
- DBA_COMPARISON_COLUMNS view, 4.114
- DBA_COMPARISON_ROW_DIF view, 4.115
- DBA_COMPARISON_SCAN view, 4.116
- DBA_COMPARISON_SCAN_VALUES view, 4.117
- DBA_CONNECT_ROLE_GRANTEES view, 4.118
- DBA_CONS_OBJ_COLUMNS view, 4.119
- DBA_CONSTRAINTS view, 4.120
- DBA_CONTEXT view, 4.121
- DBA_CPOOL_INFO view, 4.122
- DBA_CPU_USAGE_STATISTICS view, 4.123
- DBA_CQ_NOTIFICATION_QUERIES view, 4.124
- DBA_CUBE_ATTR_VISIBILITY view, 4.125
- DBA_CUBE_ATTRIBUTES view, 4.126
- DBA_CUBE_BUILD_PROCESSES view, 4.127
- DBA_CUBE_CALCULATED_MEMBERS view, 4.128
- DBA_CUBE_DIM_LEVELS view, 4.129
- DBA_CUBE_DIM_MODELS view, 4.130
- DBA_CUBE_DIM_VIEW_COLUMNS view, 4.131
- DBA_CUBE_DIM_VIEWS view, 4.132
- DBA_CUBE_DIMENSIONALITY view, 4.133
- DBA_CUBE_DIMENSIONS view, 4.134
- DBA_CUBE_HIER_LEVELS view, 4.135
- DBA_CUBE_HIER_VIEW_COLUMNS view, 4.136
- DBA_CUBE_HIER_VIEWS view, 4.137
- DBA_CUBE_HIERARCHIES view, 4.138
- DBA_CUBE_MEASURES view, 4.139
- DBA_CUBE_VIEW_COLUMNS view, 4.140
- DBA_CUBE_VIEWS view, 4.141
- DBA_CUBES view, 4.142
- DBA_DATA_FILES view, 4.143
- DBA_DATAPUMP_JOBS view, 4.144
- DBA_DATAPUMP_SESSIONS view, 4.145
- DBA_DB_LINKS view, 4.146
- DBA_DDL_LOCKS view, 4.147
- DBA_DEPENDENCIES view, 4.148
- DBA_DIM_ATTRIBUTES view, 4.149
- DBA_DIM_CHILD_OF view, 4.150
- DBA_DIM_HIERARCHIES view, 4.151
- DBA_DIM_JOIN_KEY view, 4.152
- DBA_DIM_LEVEL_KEY view, 4.153
- DBA_DIM_LEVELS view, 4.154
- DBA_DIMENSIONS view, 4.155
- DBA_DIRECTORIES view, 4.156
- DBA_DML_LOCKS view, 4.157
- DBA_DMT_FREE_SPACE view, 4.158
- DBA_DMT_USED_EXTENTS view, 4.159
- DBA_EDITION_COMMENTS view, 4.160
- DBA_EDITIONING_VIEW_COLS view, 4.161
- DBA_EDITIONING_VIEW_COLS_AE view, 4.162
- DBA_EDITIONING_VIEWS view, 4.163
- DBA_EDITIONING_VIEWS_AE view, 4.164
- DBA_EDITIONS view, 4.165
- DBA_ENABLED_AGGREGATIONS view, 4.166
- DBA_ENABLED_TRACES view, 4.167
- DBA_ENCRYPTED_COLUMNS view, 4.168
- DBA_EPG_DAD_AUTHORIZATION view, 4.169
- DBA_ERRORS view, 4.170
- DBA_ERRORS_AE view, 4.171
- DBA_EVALUATION_CONTEXT_TABLES view, 4.172
- DBA_EVALUATION_CONTEXT_VARS view, 4.173
- DBA_EVALUATION_CONTEXTS view, 4.174
- DBA_EXP_FILES view, 4.175
- DBA_EXP_OBJECTS view, 4.176
- DBA_EXP_VERSION view, 4.177
- DBA_EXTENTS view, 4.178
- DBA_EXTERNAL_LOCATIONS view, 4.179
- DBA_EXTERNAL_TABLES view, 4.180
- DBA_FEATURE_USAGE_STATISTICS view, 4.181
- DBA_FGA_AUDIT_TRAIL view, 4.182
- DBA_FILE_GROUP_EXPORT_INFO view, 4.183
- DBA_FILE_GROUP_FILES view, 4.184
- DBA_FILE_GROUP_TABLES view, 4.185
- DBA_FILE_GROUP_TABLESPACES view, 4.186
- DBA_FILE_GROUP_VERSIONS view, 4.187
- DBA_FILE_GROUPS view, 4.188
- DBA_FLASHBACK_ARCHIVE view, 4.189
- DBA_FLASHBACK_ARCHIVE_TABLES view, 4.190
- DBA_FLASHBACK_ARCHIVE_TS view, 4.191
- DBA_FLASHBACK_TXN_REPORT view, 4.192
- DBA_FLASHBACK_TXN_STATE view, 4.193
- DBA_FREE_SPACE view, 4.194
- DBA_FREE_SPACE_COALESCED view, 4.195
- DBA_HIGH_WATER_MARK_STATISTICS view, 4.196
- DBA_HIST_ACTIVE_SESS_HISTORY view, 4.197
- DBA_HIST_BASELINE view, 4.198
- DBA_HIST_BASELINE_DETAILS view, 4.199
- DBA_HIST_BASELINE_METADATA view, 4.200
- DBA_HIST_BASELINE_TEMPLATE view, 4.201
- DBA_HIST_BG_EVENT_SUMMARY view, 4.202
- DBA_HIST_BUFFER_POOL_STAT view, 4.203
- DBA_HIST_BUFFERED_QUEUES view, 4.204
- DBA_HIST_BUFFERED_SUBSCRIBERS view, 4.205
- DBA_HIST_CLUSTER_INTERCON view, 4.206
- DBA_HIST_COLORED_SQL view, 4.207
- DBA_HIST_COMP_IOSTAT view, 4.208
- DBA_HIST_CR_BLOCK_SERVER view, 4.209
- DBA_HIST_CURRENT_BLOCK_SERVER view, 4.210
- DBA_HIST_DATABASE_INSTANCE view, 4.211
- DBA_HIST_DATAFILE view, 4.212
- DBA_HIST_DB_CACHE_ADVICE view, 4.213
- DBA_HIST_DISPATCHER view, 4.214
- DBA_HIST_DLM_MISC view, 4.215
- DBA_HIST_DYN_REMASTER_STATS view, 4.216
- DBA_HIST_ENQUEUE_STAT view, 4.217
- DBA_HIST_EVENT_HISTOGRAM view, 4.218
- DBA_HIST_EVENT_NAME view, 4.219
- DBA_HIST_FILEMETRIC_HISTORY view, 4.220
- DBA_HIST_FILESTATXS view, 4.221
- DBA_HIST_IC_CLIENT_STATS view, 4.222
- DBA_HIST_IC_DEVICE_STATS view, 4.223
- DBA_HIST_INST_CACHE_TRANSFER view, 4.224
- DBA_HIST_INSTANCE_RECOVERY view, 4.225
- DBA_HIST_INTERCONNECT_PINGS view, 4.226
- DBA_HIST_IOSTAT_DETAIL view, 4.227
- DBA_HIST_IOSTAT_FILETYPE view, 4.228
- DBA_HIST_IOSTAT_FILETYPE_NAME view, 4.229
- DBA_HIST_IOSTAT_FUNCTION view, 4.230
- DBA_HIST_IOSTAT_FUNCTION_NAME view, 4.231
- DBA_HIST_JAVA_POOL_ADVICE view, 4.232
- DBA_HIST_LATCH view, 5.1
- DBA_HIST_LATCH_CHILDREN view, 5.2
- DBA_HIST_LATCH_MISSES_SUMMARY view, 5.3
- DBA_HIST_LATCH_NAME view, 5.4
- DBA_HIST_LATCH_PARENT view, 5.5
- DBA_HIST_LIBRARYCACHE view, 5.6
- DBA_HIST_LOG view, 5.7
- DBA_HIST_MEM_DYNAMIC_COMP view, 5.8
- DBA_HIST_MEMORY_RESIZE_OPS view, 5.9
- DBA_HIST_MEMORY_TARGET_ADVICE view, 5.10
- DBA_HIST_METRIC_NAME view, 5.11
- DBA_HIST_MTTR_TARGET_ADVICE view, 5.12
- DBA_HIST_MUTEX_SLEEP view, 5.13
- DBA_HIST_OPTIMIZER_ENV view, 5.14
- DBA_HIST_OSSTAT view, 5.15
- DBA_HIST_OSSTAT_NAME view, 5.16
- DBA_HIST_PARAMETER view, 5.17
- DBA_HIST_PARAMETER_NAME view, 5.18
- DBA_HIST_PERSISTENT_QMN_CACHE view, 5.19
- DBA_HIST_PERSISTENT_QUEUES view, 5.20
- DBA_HIST_PERSISTENT_SUBS view, 5.21
- DBA_HIST_PGA_TARGET_ADVICE view, 5.22
- DBA_HIST_PGASTAT view, 5.23
- DBA_HIST_PLAN_OPERATION_NAME view, 5.24
- DBA_HIST_PLAN_OPTION_NAME view, 5.25
- DBA_HIST_PROCESS_MEM_SUMMARY view, 5.26
- DBA_HIST_RESOURCE_LIMIT view, 5.27
- DBA_HIST_ROWCACHE_SUMMARY view, 5.28
- DBA_HIST_RSRC_CONSUMER_GROUP view, 5.29
- DBA_HIST_RSRC_PLAN view, 5.30
- DBA_HIST_RULE_SET view, 5.31
- DBA_HIST_SEG_STAT view, 5.32
- DBA_HIST_SEG_STAT_OBJ view, 5.33
- DBA_HIST_SERVICE_NAME view, 5.34
- DBA_HIST_SERVICE_STAT view, 5.35
- DBA_HIST_SERVICE_WAIT_CLASS view, 5.36
- DBA_HIST_SESS_TIME_STATS view, 5.37
- DBA_HIST_SESSMETRIC_HISTORY view, 5.38
- DBA_HIST_SGA view, 5.39
- DBA_HIST_SGA_TARGET_ADVICE view, 5.40
- DBA_HIST_SGASTAT view, 5.41
- DBA_HIST_SHARED_POOL_ADVICE view, 5.42
- DBA_HIST_SHARED_SERVER_SUMMARY view, 5.43
- DBA_HIST_SNAP_ERROR view, 5.44
- DBA_HIST_SNAPSHOT view, 5.45
- DBA_HIST_SQL_BIND_METADATA view, 5.46
- DBA_HIST_SQL_PLAN view, 5.47
- DBA_HIST_SQL_SUMMARY view, 5.48
- DBA_HIST_SQL_WORKAREA_HSTGRM view, 5.49
- DBA_HIST_SQLBIND view, 5.50
- DBA_HIST_SQLCOMMAND_NAME view, 5.51
- DBA_HIST_SQLSTAT view, 5.52
- DBA_HIST_SQLTEXT view, 5.53
- DBA_HIST_STAT_NAME view, 5.54
- DBA_HIST_STREAMS_APPLY_SUM view, 5.55
- DBA_HIST_STREAMS_CAPTURE view, 5.56
- DBA_HIST_STREAMS_POOL_ADVICE view, 5.57
- DBA_HIST_SYS_TIME_MODEL view, 5.58
- DBA_HIST_SYSMETRIC_HISTORY view, 5.59
- DBA_HIST_SYSMETRIC_SUMMARY view, 5.60
- DBA_HIST_SYSSTAT view, 5.61
- DBA_HIST_SYSTEM_EVENT view, 5.62
- DBA_HIST_TABLESPACE_STAT view, 5.63
- DBA_HIST_TBSPC_SPACE_USAGE view, 5.64
- DBA_HIST_TEMPFILE view, 5.65
- DBA_HIST_TEMPSTATXS view, 5.66
- DBA_HIST_THREAD view, 5.67
- DBA_HIST_TOPLEVELCALL_NAME view, 5.68
- DBA_HIST_UNDOSTAT view, 5.69
- DBA_HIST_WAITCLASSMET_HISTORY view, 5.70
- DBA_HIST_WAITSTAT view, 5.71
- DBA_HIST_WR_CONTROL view, 5.72
- DBA_HISTOGRAMS synonym for DBA_TAB_HISTOGRAMS, 5.73
- DBA_IDENTIFIERS view, 5.74
- DBA_IND_COLUMNS view, 5.75
- DBA_IND_EXPRESSIONS view, 5.76
- DBA_IND_PARTITIONS view, 5.77
- DBA_IND_PENDING_STATS view, 5.78
- DBA_IND_STATISTICS view, 5.79
- DBA_IND_SUBPARTITIONS view, 5.80
- DBA_INDEXES view, 5.81
-
- collecting statistics for, 5.80
- DBA_INDEXTYPE_ARRAYTYPES view, 5.82
- DBA_INDEXTYPE_COMMENTS view, 5.83
- DBA_INDEXTYPE_OPERATORS view, 5.84
- DBA_INDEXTYPES view, 5.85
- DBA_INTERNAL_TRIGGERS view, 5.86
- DBA_JAVA_ARGUMENTS view, 5.87
- DBA_JAVA_CLASSES view, 5.88
- DBA_JAVA_COMPILER_OPTIONS view, 5.89
- DBA_JAVA_DERIVATIONS view, 5.90
- DBA_JAVA_FIELDS view, 5.91
- DBA_JAVA_IMPLEMENTS view, 5.92
- DBA_JAVA_INNERS view, 5.93
- DBA_JAVA_LAYOUTS view, 5.94
- DBA_JAVA_METHODS view, 5.95
- DBA_JAVA_NCOMPS view, 5.96
- DBA_JAVA_POLICY view, 5.97
- DBA_JAVA_RESOLVERS view, 5.98
- DBA_JAVA_THROWS view, 5.99
- DBA_JOBS view, 5.100
- DBA_JOBS_RUNNING view, 5.101
- DBA_JOIN_IND_COLUMNS view, 5.102
- DBA_KGLLOCK view, 5.103
- DBA_LIBRARIES view, 5.104
- DBA_LMT_FREE_SPACE view, 5.105
- DBA_LMT_USED_EXTENTS view, 5.106
- DBA_LOB_PARTITIONS view, 5.107
- DBA_LOB_SUBPARTITIONS view, 5.108
- DBA_LOB_TEMPLATES view, 5.109
- DBA_LOBS view, 5.110
- DBA_LOCK view, 5.111
-
- DBA_LOCKS synonym, 5.113
- DBA_LOCK_INTERNAL view, 5.112
- DBA_LOCKS synonym for DBA_LOCK view, 5.113
- DBA_LOG_GROUP_COLUMNS view, 5.114
- DBA_LOG_GROUPS view, 5.115
- DBA_LOGMNR_LOG view, 5.116
- DBA_LOGMNR_PURGED_LOG view, 5.117
- DBA_LOGMNR_SESSION view, 5.118
- DBA_LOGSTDBY_EVENTS view, 5.119
- DBA_LOGSTDBY_HISTORY view, 5.120
- DBA_LOGSTDBY_LOG view, 5.121
- DBA_LOGSTDBY_NOT_UNIQUE view, 5.122
- DBA_LOGSTDBY_PARAMETERS view, 5.123
- DBA_LOGSTDBY_PROGRESS view, 5.124
- DBA_LOGSTDBY_SKIP view, 5.125
- DBA_LOGSTDBY_SKIP_TRANSACTION view, 5.126
- DBA_LOGSTDBY_UNSUPPORTED view, 5.127
- DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 5.128
-
- LOGSTDBY_UNSUPPORTED_TABLES synonym, 6.139
- DBA_MEASURE_FOLDER_CONTENTS view, 5.129
- DBA_MEASURE_FOLDERS view, 5.130
- DBA_METHOD_PARAMS view, 5.131
- DBA_METHOD_RESULTS view, 5.132
- DBA_MINING_MODEL_ATTRIBUTES view, 5.133
- DBA_MINING_MODEL_SETTINGS view, 5.134
- DBA_MINING_MODELS view, 5.135
- DBA_MVIEW_AGGREGATES view, 5.136
- DBA_MVIEW_ANALYSIS view, 5.137
- DBA_MVIEW_COMMENTS view, 5.138
- DBA_MVIEW_DETAIL_PARTITION view, 5.139
- DBA_MVIEW_DETAIL_RELATIONS view, 5.140
- DBA_MVIEW_DETAIL_SUBPARTITION view, 5.141
- DBA_MVIEW_JOINS view, 5.142
- DBA_MVIEW_KEYS view, 5.143
- DBA_MVIEW_LOG_FILTER_COLS view, 5.144
- DBA_MVIEW_LOGS view, 5.145
- DBA_MVIEW_REFRESH_TIMES view, 5.146
- DBA_MVIEWS view, 5.147
- DBA_NESTED_TABLE_COLS view, 5.148
- DBA_NESTED_TABLES view, 5.149
- DBA_NETWORK_ACL_PRIVILEGES view, 5.150
- DBA_NETWORK_ACLS view, 5.151
- DBA_OBJ_AUDIT_OPTS view, 5.152
- DBA_OBJ_COLATTRS view, 5.153
- DBA_OBJECT_SIZE view, 5.154
- DBA_OBJECT_TABLES view, 5.155
- DBA_OBJECTS view, 5.156
- DBA_OBJECTS_AE view, 5.157
- DBA_OPANCILLARY view, 5.158
- DBA_OPARGUMENTS view, 5.159
- DBA_OPBINDINGS view, 5.160
- DBA_OPERATOR_COMMENTS view, 5.161
- DBA_OPERATORS view, 5.162
- DBA_OPTSTAT_OPERATIONS view, 5.163
- DBA_ORPHAN_KEY_TABLE view, 5.164
- DBA_OUTLINE_HINTS view, 5.165
- DBA_OUTLINES view, 5.166
- DBA_OUTSTANDING_ALERTS view, 5.167
- DBA_PARALLEL_EXECUTE_CHUNKS view, 5.168
- DBA_PARALLEL_EXECUTE_TASKS view, 5.169
- DBA_PART_COL_STATISTICS view, 5.170
- DBA_PART_HISTOGRAMS view, 5.171
- DBA_PART_INDEXES view, 5.172
- DBA_PART_KEY_COLUMNS view, 5.173
- DBA_PART_LOBS view, 5.174
- DBA_PART_TABLES view, 5.175
- DBA_PARTIAL_DROP_TABS view, 5.176
- DBA_PENDING_CONV_TABLES view, 5.177
- DBA_PENDING_TRANSACTIONS view, 5.178
- DBA_PLSQL_OBJECT_SETTINGS view, 5.179
- DBA_POLICIES view, 5.180
- DBA_POLICY_CONTEXTS view, 5.181
- DBA_POLICY_GROUPS view, 5.182
- DBA_PRIV_AUDIT_OPTS view, 5.183
- DBA_PROCEDURES view, 5.184
- DBA_PROFILES view, 5.185
- DBA_PROPAGATION view, 5.186
- DBA_PROXIES view, 5.187
- DBA_PUBLISHED_COLUMNS view, 5.188
- DBA_QUEUE_SCHEDULES view, 5.189
- DBA_QUEUE_SUBSCRIBERS view, 5.190
- DBA_QUEUE_TABLES view, 5.191
- DBA_QUEUES view, 5.192
- DBA_RCHILD view, 5.193
- DBA_RECOVERABLE_SCRIPT view, 5.194
- DBA_RECOVERABLE_SCRIPT_BLOCKS view, 5.195
- DBA_RECOVERABLE_SCRIPT_ERRORS view, 5.196
- DBA_RECOVERABLE_SCRIPT_HIST view, 5.197
- DBA_RECOVERABLE_SCRIPT_PARAMS view, 5.198
- DBA_RECYCLEBIN view, 5.199
- DBA_REDEFINITION_ERRORS view, 5.200
- DBA_REDEFINITION_OBJECTS view, 5.201
- DBA_REFRESH view, 5.202
- DBA_REFRESH_CHILDREN view, 5.203
- DBA_REFS view, 5.204
- DBA_REGISTERED_ARCHIVED_LOG view, 5.205
- DBA_REGISTERED_MVIEW_GROUPS view, 5.206
- DBA_REGISTERED_MVIEWS view, 5.207
- DBA_REGISTRY view, 5.208
- DBA_REGISTRY_HIERARCHY view, 5.209
- DBA_REGISTRY_HISTORY view, 5.210
- DBA_REGISTRY_LOG view, 5.211
- DBA_REPAIR_TABLE view, 5.212
- DBA_REPCAT view, 2.1.1
- DBA_REPCAT_EXCEPTIONS view, 2.1.1
- DBA_REPCAT_REFRESH_TEMPLATES view, 2.1.1
- DBA_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
- DBA_REPCAT_TEMPLATE_PARMS view, 2.1.1
- DBA_REPCAT_TEMPLATE_SITES view, 2.1.1
- DBA_REPCAT_USER_AUTHORIZATIONS view, 2.1.1
- DBA_REPCAT_USER_PARM_VALUES view, 2.1.1
- DBA_REPCATLOG view, 2.1.1
- DBA_REPCOLUMN view, 2.1.1
- DBA_REPCOLUMN_GROUP view, 2.1.1
- DBA_REPCONFLICT view, 2.1.1
- DBA_REPDDL view, 2.1.1
- DBA_REPEXTENSIONS view, 2.1.1
- DBA_REPFLAVOR_COLUMNS view, 2.1.1
- DBA_REPFLAVOR_OBJECTS view, 2.1.1
- DBA_REPFLAVORS view, 2.1.1
- DBA_REPGENERATED view, 2.1.1
- DBA_REPGENOBJECTS view, 2.1.1
- DBA_REPGROUP view, 2.1.1
- DBA_REPGROUP_PRIVILEGES view, 2.1.1
- DBA_REPGROUPED_COLUMN view, 2.1.1
- DBA_REPKEY_COLUMNS view, 2.1.1
- DBA_REPOBJECT view, 2.1.1
- DBA_REPPARAMETER_COLUMN view, 2.1.1
- DBA_REPPRIORITY view, 2.1.1
- DBA_REPPRIORITY_GROUP view, 2.1.1
- DBA_REPPROP view, 2.1.1
- DBA_REPRESOL_STATS_CONTROL view, 2.1.1
- DBA_REPRESOLUTION view, 2.1.1
- DBA_REPRESOLUTION_METHOD view, 2.1.1
- DBA_REPRESOLUTION_STATISTICS view, 2.1.1
- DBA_REPSCHEMA view, 2.1.1
- DBA_REPSITES view, 2.1.1
- DBA_REPSITES_NEW view, 2.1.1
- DBA_RESOURCE_INCARNATIONS view, 5.213
- DBA_RESUMABLE view, 5.214
- DBA_REWRITE_EQUIVALENCES view, 5.215
- DBA_RGROUP view, 5.216
- DBA_ROLE_PRIVS view, 5.217
- DBA_ROLES view, 5.218
- DBA_ROLLBACK_SEGS view, 5.219
- DBA_RSRC_CATEGORIES view, 5.220
- DBA_RSRC_CONSUMER_GROUP_PRIVS view, 5.221
- DBA_RSRC_CONSUMER_GROUPS view, 5.222
- DBA_RSRC_GROUP_MAPPINGS view, 5.223
- DBA_RSRC_IO_CALIBRATE view, 5.224
- DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 5.225
- DBA_RSRC_MAPPING_PRIORITY view, 5.226
- DBA_RSRC_PLAN_DIRECTIVES view, 5.227
- DBA_RSRC_PLANS view, 5.228
- DBA_RULE_SET_RULES view, 5.229
- DBA_RULE_SETS view, 5.230
- DBA_RULES view, 5.231
- DBA_SCHEDULER_CHAIN_RULES view, 5.232
- DBA_SCHEDULER_CHAIN_STEPS view, 5.233
- DBA_SCHEDULER_CHAINS view, 5.234
- DBA_SCHEDULER_CREDENTIALS view, 5.235
- DBA_SCHEDULER_DB_DESTS view, 5.236
- DBA_SCHEDULER_DESTS view, 5.237
- DBA_SCHEDULER_EXTERNAL_DESTS view, 5.238
- DBA_SCHEDULER_FILE_WATCHERS view, 5.239
- DBA_SCHEDULER_GLOBAL_ATTRIBUTE view, 5.240
- DBA_SCHEDULER_GROUP_MEMBERS view, 5.241
- DBA_SCHEDULER_GROUPS view, 5.242
- DBA_SCHEDULER_JOB_ARGS view, 5.243
- DBA_SCHEDULER_JOB_CLASSES view, 5.244
- DBA_SCHEDULER_JOB_DESTS view, 5.245
- DBA_SCHEDULER_JOB_LOG view, 5.246
- DBA_SCHEDULER_JOB_ROLES view, 5.247
- DBA_SCHEDULER_JOB_RUN_DETAILS view, 5.248
- DBA_SCHEDULER_JOBS view, 5.249
- DBA_SCHEDULER_NOTIFICATIONS view, 5.250
- DBA_SCHEDULER_PROGRAM_ARGS view, 5.251
- DBA_SCHEDULER_PROGRAMS view, 5.252
- DBA_SCHEDULER_REMOTE_DATABASES view, 5.253
- DBA_SCHEDULER_REMOTE_JOBSTATE view, 5.254
- DBA_SCHEDULER_RUNNING_CHAINS view, 5.255
- DBA_SCHEDULER_RUNNING_JOBS view, 5.256
- DBA_SCHEDULER_SCHEDULES view, 5.257
- DBA_SCHEDULER_WINDOW_DETAILS view, 5.258
- DBA_SCHEDULER_WINDOW_GROUPS view, 5.259
- DBA_SCHEDULER_WINDOW_LOG view, 5.260
- DBA_SCHEDULER_WINDOWS view, 5.261
- DBA_SCHEDULER_WINGROUP_MEMBERS view, 5.262
- DBA_SEC_RELEVANT_COLS view, 5.263
- DBA_SECONDARY_OBJECTS view, 5.264
- DBA_SEGMENTS view, 5.265
- DBA_SEGMENTS_OLD view, 5.266
- DBA_SEQUENCES view, 5.267
- DBA_SERVER_REGISTRY view, 5.268
- DBA_SERVICES view, 5.269
- DBA_SOURCE view, 5.270
- DBA_SOURCE_AE view, 5.271
- DBA_SOURCE_TABLES view, 5.272
- DBA_SQL_MANAGEMENT_CONFIG view, 5.273
- DBA_SQL_PATCHES view, 5.274
- DBA_SQL_PLAN_BASELINES view, 5.275
- DBA_SQL_PROFILES view, 5.276
- DBA_SQLJ_TYPE_ATTRS view, 5.277
- DBA_SQLJ_TYPE_METHODS view, 5.278
- DBA_SQLJ_TYPES view, 5.279
- DBA_SQLSET view, 5.280
- DBA_SQLSET_BINDS view, 5.281
- DBA_SQLSET_PLANS view, 5.282
- DBA_SQLSET_REFERENCES view, 5.283
- DBA_SQLSET_STATEMENTS view, 5.284
- DBA_SQLTUNE_BINDS view, 5.285
- DBA_SQLTUNE_PLANS view, 5.286
- DBA_SQLTUNE_RATIONALE_PLAN view, 5.287
- DBA_SQLTUNE_STATISTICS view, 5.288
- DBA_SSCR_CAPTURE view, 5.289
- DBA_SSCR_RESTORE view, 5.290
- DBA_STAT_EXTENSIONS view, 5.291
- DBA_STMT_AUDIT_OPTS view, 5.292
- DBA_STORED_SETTINGS view, 5.293
- DBA_STREAMS_ADD_COLUMN view, 6.1
- DBA_STREAMS_ADMINISTRATOR view, 6.2
- DBA_STREAMS_COLUMNS view, 6.3
- DBA_STREAMS_DELETE_COLUMN view, 6.4
- DBA_STREAMS_GLOBAL_RULES view, 6.5
- DBA_STREAMS_KEEP_COLUMNS view, 6.6
- DBA_STREAMS_MESSAGE_CONSUMERS view, 6.7
- DBA_STREAMS_MESSAGE_RULES view, 6.8
- DBA_STREAMS_NEWLY_SUPPORTED view, 6.9
- DBA_STREAMS_RENAME_COLUMN view, 6.10
- DBA_STREAMS_RENAME_SCHEMA view, 6.11
- DBA_STREAMS_RENAME_TABLE view, 6.12
- DBA_STREAMS_RULES view, 6.13
- DBA_STREAMS_SCHEMA_RULES view, 6.14
- DBA_STREAMS_SPLIT_MERGE view, 6.15
- DBA_STREAMS_SPLIT_MERGE_HIST view, 6.16
- DBA_STREAMS_STMT_HANDLERS view, 6.17
- DBA_STREAMS_STMTS view, 6.18
- DBA_STREAMS_TABLE_RULES view, 6.19
- DBA_STREAMS_TP_COMPONENT view, 6.20
- DBA_STREAMS_TP_COMPONENT_LINK view, 6.21
- DBA_STREAMS_TP_COMPONENT_STAT view, 6.22
- DBA_STREAMS_TP_DATABASE view, 6.23
- DBA_STREAMS_TP_PATH_BOTTLENECK view, 6.24
- DBA_STREAMS_TP_PATH_STAT view, 6.25
- DBA_STREAMS_TRANSFORM_FUNCTION view, 6.26
- DBA_STREAMS_TRANSFORMATIONS view, 6.27
- DBA_STREAMS_UNSUPPORTED view, 6.28
- DBA_SUBPART_COL_STATISTICS view, 6.29
- DBA_SUBPART_HISTOGRAMS view, 6.30
- DBA_SUBPART_KEY_COLUMNS view, 6.31
- DBA_SUBPARTITION_TEMPLATES view, 6.32
- DBA_SUBSCR_REGISTRATIONS view, 6.33
- DBA_SUBSCRIBED_COLUMNS view, 6.34
- DBA_SUBSCRIBED_TABLES view, 6.35
- DBA_SUBSCRIPTIONS view, 6.36
- DBA_SYNC_CAPTURE view, 6.37
- DBA_SYNC_CAPTURE_PREPARED_TABS view, 6.38
- DBA_SYNC_CAPTURE_TABLES view, 6.39
- DBA_SYNONYMS view, 6.40
- DBA_SYS_PRIVS view, 6.41
- DBA_TAB_COL_STATISTICS view, 6.42
- DBA_TAB_COLS view, 6.43
- DBA_TAB_COLUMNS view, 6.44
- DBA_TAB_COMMENTS view, 6.45
- DBA_TAB_HISTGRM_PENDING_STATS view, 6.46
- DBA_TAB_HISTOGRAMS view, 6.47
-
- DBA_HISTOGRAMS synonym, 5.73
- DBA_TAB_MODIFICATIONS view, 6.48
- DBA_TAB_PARTITIONS view, 6.49
- DBA_TAB_PENDING_STATS view, 6.50
- DBA_TAB_PRIVS view, 6.51
- DBA_TAB_STAT_PREFS view, 6.53
- DBA_TAB_STATISTICS view, 6.52
- DBA_TAB_STATS_HISTORY view, 6.54
- DBA_TAB_SUBPARTITIONS view, 6.55
- DBA_TABLES view, 6.56
- DBA_TABLESPACE_GROUPS view, 6.57
- DBA_TABLESPACE_THRESHOLDS view, 6.58
- DBA_TABLESPACE_USAGE_METRICS view, 6.59
- DBA_TABLESPACES view, 6.60
- DBA_TEMP_FILES view, 6.61
- DBA_TEMP_FREE_SPACE view, 6.62
- DBA_THRESHOLDS view, 6.63
- DBA_TRANSFORMATIONS view, 6.64
- DBA_TRIGGER_COLS view, 6.65
- DBA_TRIGGER_ORDERING view, 6.66
- DBA_TRIGGERS view, 6.67
- DBA_TS_QUOTAS view, 6.68
- DBA_TSM_DESTINATION view, 6.69
- DBA_TSM_SOURCE view, 6.70
- DBA_TSTZ_TAB_COLS view, 6.71
- DBA_TSTZ_TABLES view, 6.72
- DBA_TUNE_MVIEW view, 6.73
- DBA_TYPE_ATTRS view, 6.74
- DBA_TYPE_METHODS view, 6.75
- DBA_TYPE_VERSIONS view, 6.76
- DBA_TYPES view, 6.77
- DBA_UNDO_EXTENTS view, 6.78
- DBA_UNUSED_COL_TABS view, 6.79
- DBA_UPDATABLE_COLUMNS view, 6.80
- DBA_USERS view, 6.81
- DBA_USERS_WITH_DEFPWD view, 6.82
- DBA_USTATS view, 6.83
- DBA_VARRAYS view, 6.84
- DBA_VIEWS view, 6.85
- DBA_VIEWS_AE view, 6.86
- DBA_WAITERS view, 6.87
- DBA_WALLET_ACLS view, 6.88
- DBA_WARNING_SETTINGS view, 6.89
- DBA_WM_SYS_PRIVS view, 2.1.2
- DBA_WM_VT_ERRORS view, 2.1.2
- DBA_WORKLOAD_CAPTURES view, 6.90
- DBA_WORKLOAD_CONNECTION_MAP view, 6.91
- DBA_WORKLOAD_FILTERS view, 6.92
- DBA_WORKLOAD_REPLAY_DIVERGENCE view, 6.93
- DBA_WORKLOAD_REPLAYS view, 6.94
- DBA_WORKSPACE_SESSIONS view, 2.1.2
- DBA_WORKSPACES view, 2.1.2
- DBA_XML_INDEXES view, 6.95
- DBA_XML_SCHEMAS view, 6.96
- DBA_XML_TAB_COLS view, 6.97
- DBA_XML_TABLES view, 6.98
- DBA_XML_VIEW_COLS view, 6.99
- DBA_XML_VIEWS view, 6.100
- DBA_XSTREAM_ADMINISTRATOR view, 6.101
- DBA_XSTREAM_INBOUND view, 6.102
- DBA_XSTREAM_INBOUND_PROGRESS view, 6.103
- DBA_XSTREAM_OUT_SUPPORT_MODE view, 6.104
- DBA_XSTREAM_OUTBOUND view, 6.105
- DBA_XSTREAM_OUTBOUND_PROGRESS view, 6.106
- DBA_XSTREAM_RULES view, 6.107
- DBFS_CONTENT view, 6.108
- DBFS_CONTENT_PROPERTIES view, 6.109
- DBMS_ALERT_INFO view, 6.110
- DBMS_LOCK_ALLOCATED view, 6.111
- DBMSIOTC.SQL script, B.2
- DBMSPOOL.SQL script, B.2
- DBWR_IO_SLAVES initialization parameter, 1.71
- DDL_LOCK_TIMEOUT initialization parameter, 1.72
- DEFCALL view, 2.1.1
- DEFCALLDEST view, 2.1.1
- DEFDEFAULTDEST view, 2.1.1
- DEFERRCOUNT view, 2.1.1
- DEFERRED_SEGMENT_CREATION initialization parameter, 1.73
- DEFERROR view, 2.1.1
- DEFLOB view, 2.1.1
- DEFPROPAGATOR view, 2.1.1
- DEFSCHEDULE view, 2.1.1
- DEFTRAN view, 2.1.1
- DEFTRANDEST view, 2.1.1
- DEPTREE view, 6.112
- destination
-
- archiving redo log files, 1.120
- overriding default, 1.120
- USER_DUMP_DEST, 1.263
- DG_BROKER_CONFIG_FILEn initialization parameter, 1.74
- DG_BROKER_START initialization parameter, 1.75
- DIAGNOSTIC_DEST initialization parameter, 1.76
- DICT synonym for DICTIONARY, 6.113
- DICT_COLUMNS view, 6.114
- DICTIONARY view, 6.115
-
- DICT synonym, 6.113
- disk drives
-
- archiving destination, 1.120
- DISK_ASYNCH_IO initialization parameter, 1.77
- dispatcher processes
-
- maximum number, 1.134
- DISPATCHERS initialization parameter, 1.78
- distinguished name, 1.200
- DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.79
- DM_USER_MODELS view, 6.116
- DML_LOCKS initialization parameter, 1.80
- DOCUMENT_LINKS view, 6.117
- downgrading
-
- scripts, B.4
- DST_UPGRADE_INSERT_CONV initialization parameter, 1.81
- dump files, 1.135
- dynamic performance tables
-
- CATALOG.SQL script, 7.1
- public synonyms (V$), 7.1.1
- views (V_$), 7.1.1
E
- embedded initialization parameter files, 1.99
- ENABLE_DDL_LOGGING initialization parameter, 1.82
- enqueues
-
- AJV snapshot refresh, D
- ALTER SYSTEM SET PARAMETER = VALUE, D
- backup/restore, D
- being written redo log, D
- bind, D
- buffer cache management, D
- controlfile transaction, D
- cross-instance call invocation, D
- database mount, D
- datafile, D
- direct loader index creation, D
- disabling, 1.80
- distributed recovery process, D
- distributed transaction, D
- DML, D
- extend table, D
- file set, D
- high-water lock, D
- instance attribute lock, D
- instance number, D
- instance recovery, D
- instance registration lock, D
- instance state, D
- job queue, D
- library cache invalidation, D
- library cache lock, D
- library cache pin, D
- log start or switch, D
- media recovery, D
- mount definition, D
- object reuse, D
- parallel slave synchronization, D
- parallel slaves, D
- password file, D
- process startup, D
- redo log "kick", D
- redo thread, D
- row cache, D
- row wait, D
- sequence number, D, D
- sequence number value, D
- SMON, D
- sort segment, D
- space management transaction, D
- synchronized replication, D
- system commit number, D
- temporary segment, D
- temporary table, D
- temporary table object, D
- thread checkpoint, D
- transaction, D
- transaction recovery, D
- undo segment, serialization, D
- user name, D
- user-defined locks, D
- enterprise roles, 1.200
- ERROR_SIZE view, 6.118
- EVENT initialization parameter, 1.83
- EXCEPTIONS table, 6.119
- extent
-
- allocating to instance, 1.102
F
- FAL_CLIENT initialization parameter, 1.84
- FAL_SERVER initialization parameter, 1.85
- FAST_START_MTTR_TARGET initialization parameter, 1.86
- FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.87
- FILE_MAPPING initialization parameter, 1.88
- FILEIO_NETWORK_ADAPTERS initialization parameter, 1.89
- filenames
-
- case significance, 1.3.2.1.1
- FILESYSTEMIO_OPTIONS initialization parameter, 1.90
- FIXED_DATE initialization parameter, 1.91
- FLASHBACK_TRANSACTION_QUERY view, 6.120
- free space list
-
- locating space, 1.102
- FREELIST GROUPS clause, 1.102
G
- GCS_SERVER_PROCESSES initialization parameter, 1.92
- GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.93
- GLOBAL_NAME view, 6.121
- GLOBAL_NAMES initialization parameter, 1.94
- GLOBAL_TXN_PROCESSES initialization parameter, 1.95
- GV$ views
-
- for Real Application Clusters, 7.1.2
H
- HASH_AREA_SIZE initialization parameter, 1.96
- Heterogeneous Services
-
- agents, 1.98
- HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.97
- hints
-
- precedence over initialization parameter settings, 1.238
- HS_ALL_CAPS view, 6.122
- HS_ALL_DD view, 6.123
- HS_ALL_INITS view, 6.124
- HS_AUTOREGISTER initialization parameter, 1.98
- HS_BASE_CAPS view, 6.125
- HS_BASE_DD view, 6.126
- HS_CLASS_CAPS view, 6.127
- HS_CLASS_DD view, 6.128
- HS_CLASS_INIT view, 6.129
- HS_FDS_CLASS view, 6.130
- HS_FDS_INST view, 6.131
- HS_INST_CAPS view, 6.132
- HS_INST_DD view, 6.133
- HS_INST_INIT view, 6.134
I
- IDEPTREE view, 6.135
- IFILE initialization parameter, 1.3.2.1.1, 1.99
- IND synonym for USER_INDEXES view, 6.136
- INDEX_HISTOGRAM view, 6.137
- INDEX_STATS view, 6.138
- initialization parameter file
-
- common file, 1.99
- embedded, 1.99
- INITDW.ORA
- line continuation character, 1.3.2.1.1
- overview, 1.3
- initialization parameters
-
- ACTIVE_INSTANCE_COUNT, 1.7
- altering, 1.4
- AQ_TM_PROCESSES, 1.8
- ARCHIVE_LAG_TARGET, 1.9
- ASM_DISKGROUPS, 1.10
- ASM_DISKSTRING, 1.11
- ASM_POWER_LIMIT, 1.12
- ASM_PREFERRED_READ_FAILURE_GROUPS, 1.13
- AUDIT_FILE_DEST, 1.14
- AUDIT_SYS_OPERATIONS, 1.15
- AUDIT_SYSLOG_LEVEL, 1.16
- AUDIT_TRAIL, 1.17
- BACKGROUND_CORE_DUMP, 1.18
- BACKGROUND_DUMP_DEST, 1.19
- BACKUP_TAPE_IO_SLAVES, 1.20
- basic, 1.2
- BITMAP_MERGE_AREA_SIZE, 1.21
- BLANK_TRIMMING, 1.22
- case significance in filenames, 1.3.2.1.1
- CIRCUITS, 1.23
- CLIENT_RESULT_CACHE_LAG, 1.24
- CLIENT_RESULT_CACHE_SIZE, 1.25
- CLUSTER_DATABASE, 1.26
- CLUSTER_DATABASE_INSTANCES, 1.27
- CLUSTER_INTERCONNECTS, 1.28
- COMMIT_LOGGING, 1.29
- COMMIT_POINT_STRENGTH, 1.30
- COMMIT_WAIT, 1.31
- COMMIT_WRITE, 1.32
- COMPATIBLE, 1.33
- CONTROL_FILE_RECORD_KEEP_TIME, 1.34
- CONTROL_FILES, 1.35
- CONTROL_MANAGEMENT_PACK_ACCESS, 1.36
- CORE_DUMP_DEST, 1.37
- CPU_COUNT, 1.38
- CREATE_BITMAP_AREA_SIZE, 1.39
- CREATE_STORED_OUTLINES, 1.40
- CURSOR_BIND_CAPTURE_DESTINATION, 1.41
- CURSOR_SHARING, 1.42
- CURSOR_SPACE_FOR_TIME, 1.43
- DB_BLOCK_BUFFERS, 1.45
- DB_BLOCK_CHECKING, 1.46
- DB_BLOCK_CHECKSUM, 1.47
- DB_BLOCK_SIZE, 1.48
- DB_CACHE_ADVICE, 1.49
- DB_CACHE_SIZE, 1.50
- DB_CREATE_FILE_DEST, 1.51
- DB_CREATE_ONLINE_LOG_DEST_n, 1.52
- DB_DOMAIN, 1.53
- DB_FILE_MULTIBLOCK_READ_COUNT, 1.54
- DB_FILE_NAME_CONVERT, 1.55
- DB_FILES, 1.56
- DB_FLASH_CACHE_FILE, 1.57
- DB_FLASH_CACHE_SIZE, 1.58
- DB_FLASHBACK_RETENTION_TARGET, 1.59
- DB_KEEP_CACHE_SIZE, 1.60
- DB_LOST_WRITE_PROTECT, 1.61
- DB_NAME, 1.62
- DB_nK_CACHE_SIZE, 1.44
- DB_RECOVERY_FILE_DEST, 1.63
- DB_RECOVERY_FILE_DEST_SIZE, 1.64
- DB_RECYCLE_CACHE_SIZE, 1.65
- DB_SECUREFILE, 1.66
- DB_ULTRA_SAFE, 1.67
- DB_UNIQUE_NAME, 1.68
- DB_UNRECOVERABLE_SCN_TRACKING, 1.69
- DB_WRITER_PROCESSES, 1.70
- DBWR_IO_SLAVES, 1.71
- DDL_LOCK_TIMEOUT, 1.72
- DEFERRED_SEGMENT_CREATION, 1.73
- derived, 1.1.1.1
- DG_BROKER_CONFIG_FILEn, 1.74
- DG_BROKER_START, 1.75
- DIAGNOSTIC_DEST, 1.76
- DISK_ASYNCH_IO, 1.77
- DISPATCHERS, 1.78
- display current settings, 1.4.3
- DISTRIBUTED_LOCK_TIMEOUT, 1.79
- DML_LOCKS, 1.80
- DST_UPGRADE_INSERT_CONV, 1.81
- embedded initialization parameter files, 1.3.2.1.1
- ENABLE_DDL_LOGGING, 1.82
- EVENT, 1.83
- FAL_CLIENT, 1.84
- FAL_SERVER, 1.85
- FAST_START_MTTR_TARGET, 1.86
- FAST_START_PARALLEL_ROLLBACK, 1.87
- FILE_MAPPING, 1.88
- FILEIO_NETWORK_ADAPTERS, 1.89
- FILESYSTEMIO_OPTIONS, 1.90
- FIXED_DATE, 1.91
- functional category, 1.4.1
- GCS_SERVER_PROCESSES, 1.92
- GLOBAL_CONTEXT_POOL_SIZE, 1.93
- GLOBAL_NAMES, 1.94
- GLOBAL_TXN_PROCESSES, 1.95
- HASH_AREA_SIZE, 1.96
- HI_SHARED_MEMORY_ADDRESS, 1.97
- HS_AUTOREGISTER, 1.98
- IFILE, 1.3.2.1.1, 1.99
- INSTANCE_GROUPS, 1.100
- INSTANCE_NAME, 1.101
- INSTANCE_NUMBER, 1.102
- INSTANCE_TYPE, 1.103
- JAVA_JIT_ENABLED, 1.104
- JAVA_MAX_SESSIONSPACE_SIZE, 1.105
- JAVA_POOL_SIZE, 1.106
- JAVA_SOFT_SESSIONSPACE_LIMIT, 1.107
- JOB_QUEUE_PROCESSES, 1.108
- LARGE_POOL_SIZE, 1.109
- LDAP_DIRECTORY_ACCESS, 1.110
- LDAP_DIRECTORY_SYSAUTH, 1.111
- LICENSE_MAX_SESSIONS, 1.112
- LICENSE_MAX_USERS, 1.113
- LICENSE_SESSIONS_WARNING, 1.114
- LISTENER_NETWORKS, 1.115
- LOCAL_LISTENER, 1.116
- LOCK_NAME_SPACE, 1.117
- LOCK_SGA, 1.118
- LOG_ARCHIVE_CONFIG, 1.119
- LOG_ARCHIVE_DEST, 1.120
- LOG_ARCHIVE_DEST_n, 1.121
- LOG_ARCHIVE_DEST_STATE_n, 1.122
- LOG_ARCHIVE_DUPLEX_DEST, 1.123
- LOG_ARCHIVE_FORMAT, 1.124
- LOG_ARCHIVE_LOCAL_FIRST, 1.125
- LOG_ARCHIVE_MAX_PROCESSES, 1.126
- LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.127
- LOG_ARCHIVE_TRACE, 1.128
- LOG_BUFFER, 1.129
- LOG_CHECKPOINT_INTERVAL, 1.130
- LOG_CHECKPOINT_TIMEOUT, 1.131
- LOG_CHECKPOINTS_TO_ALERT, 1.132
- LOG_FILE_NAME_CONVERT, 1.133
- MAX_DISPATCHERS, 1.134
- MAX_DUMP_FILE_SIZE, 1.135
- MAX_ENABLED_ROLES, 1.136
- MAX_SHARED_SERVERS, 1.137
- MEMORY_MAX_TARGET, 1.138
- MEMORY_TARGET, 1.139
- modifiable, 1.4.2
- NLS_CALENDAR, 1.140
- NLS_COMP, 1.141
- NLS_CURRENCY, 1.142
- NLS_DATE_FORMAT, 1.143
- NLS_DATE_LANGUAGE, 1.144
- NLS_DUAL_CURRENCY, 1.145
- NLS_ISO_CURRENCY, 1.146
- NLS_LANGUAGE, 1.147
- NLS_LENGTH_SEMANTICS, 1.148
- NLS_NCHAR_CONV_EXCP, 1.149
- NLS_NUMERIC_CHARACTERS, 1.150
- NLS_SORT, 1.151
- NLS_TERRITORY, 1.152
- NLS_TIMESTAMP_FORMAT, 1.153
- NLS_TIMESTAMP_TZ_FORMAT, 1.154
- O7_DICTIONARY_ACCESSIBILITY, 1.155
- OBJECT_CACHE_MAX_SIZE_PERCENT, 1.156
- OBJECT_CACHE_OPTIMAL_SIZE, 1.157
- OLAP_PAGE_POOL_SIZE, 1.158
- OPEN_CURSORS, 1.159
- OPEN_LINKS, 1.160
- OPEN_LINKS_PER_INSTANCE, 1.161
- operating system-dependent values, 1.1.1.2
- OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, 1.162
- OPTIMIZER_DYNAMIC_SAMPLING, 1.163
- OPTIMIZER_FEATURES_ENABLE, 1.164
- OPTIMIZER_INDEX_CACHING, 1.165
- OPTIMIZER_INDEX_COST_ADJ, 1.166
- OPTIMIZER_MODE, 1.167
- OPTIMIZER_SECURE_VIEW_MERGING, 1.168
- OPTIMIZER_USE_INVISIBLE_INDEXES, 1.169
- OPTIMIZER_USE_PENDING_STATISTICS, 1.170
- OPTIMIZER_USE_SQL_PLAN_BASELINES, 1.171
- OS_AUTHENT_PREFIX, 1.172
- OS_ROLES, 1.173
- PARALLEL_ADAPTIVE_MULTI_USER, 1.174
- PARALLEL_AUTOMATIC_TUNING, 1.175
- PARALLEL_DEGREE_LIMIT, 1.176
- PARALLEL_DEGREE_POLICY, 1.177
- PARALLEL_EXECUTION_MESSAGE_SIZE, 1.178
- PARALLEL_FORCE_LOCAL, 1.179
- PARALLEL_INSTANCE_GROUP, 1.180
- PARALLEL_IO_CAP_ENABLED, 1.181
- PARALLEL_MAX_SERVERS, 1.182
- PARALLEL_MIN_PERCENT, 1.183
- PARALLEL_MIN_SERVERS, 1.184
- PARALLEL_MIN_TIME_THRESHOLD, 1.185
- PARALLEL_SERVERS_TARGET, 1.186
- PARALLEL_THREADS_PER_CPU, 1.187
- parameter files, 1.3
- performance tuning, 1.1.1.3
- PGA_AGGREGATE_TARGET, 1.188
- PLSCOPE_SETTINGS, 1.189
- PLSQL_CCFLAGS, 1.190
- PLSQL_CODE_TYPE, 1.191
- PLSQL_DEBUG, 1.192
- PLSQL_OPTIMIZE_LEVEL, 1.193
- PLSQL_V2_COMPATIBILITY, 1.194
- PLSQL_WARNINGS, 1.195
- PRE_PAGE_SGA, 1.196
- PROCESSES, 1.197
- QUERY_REWRITE_ENABLED, 1.198
- QUERY_REWRITE_INTEGRITY, 1.199
- RDBMS_SERVER_DN, 1.200
- READ_ONLY_OPEN_DELAYED, 1.201
- RECOVERY_PARALLELISM, 1.202
- RECYCLEBIN, 1.203
- REDO_TRANSPORT_USER, 1.204
- REMOTE_DEPENDENCIES_MODE, 1.205
- REMOTE_LISTENER, 1.206
- REMOTE_LOGIN_PASSWORDFILE, 1.207
- REMOTE_OS_AUTHENT, 1.208
- REMOTE_OS_ROLES, 1.209
- REPLICATION_DEPENDENCY_TRACKING, 1.210
- RESOURCE_LIMIT, 1.211
- RESOURCE_MANAGER_CPU_ALLOCATION, 1.212
- RESOURCE_MANAGER_PLAN, 1.213
- RESULT_CACHE_MAX_RESULT, 1.214
- RESULT_CACHE_MAX_SIZE, 1.215
- RESULT_CACHE_MODE, 1.216
- RESULT_CACHE_REMOTE_EXPIRATION, 1.217
- RESUMABLE_TIMEOUT, 1.218
- ROLLBACK_SEGMENTS, 1.219
- SEC_CASE_SENSITIVE_LOGON, 1.220
- SEC_MAX_FAILED_LOGIN_ATTEMPTS, 1.221
- SEC_PROTOCOL_ERROR_FURTHER_ACTION, 1.222
- SEC_PROTOCOL_ERROR_TRACE_ACTION, 1.223
- SEC_RETURN_SERVER_RELEASE_BANNER, 1.224
- SERIAL_REUSE, 1.225
- SERVICE_NAMES, 1.226
- SESSION_CACHED_CURSORS, 1.227
- SESSION_MAX_OPEN_FILES, 1.228
- SESSIONS, 1.229
- SGA_MAX_SIZE, 1.230
- SGA_TARGET, 1.231
- SHADOW_CORE_DUMP, 1.232
- SHARED_MEMORY_ADDRESS, 1.233
- SHARED_POOL_RESERVED_SIZE, 1.234
- SHARED_POOL_SIZE, 1.235
- SHARED_SERVER_SESSIONS, 1.236
- SHARED_SERVERS, 1.237
- SKIP_UNUSABLE_INDEXES, 1.238
- SMTP_OUT_SERVER, 1.239
- SORT_AREA_RETAINED_SIZE, 1.240
- SORT_AREA_SIZE, 1.241
- specifying in initialization parameter files, 1.3.2.1
- SPFILE, 1.242
- SQL_TRACE, 1.243
- SQL92_SECURITY, 1.244
- SQLTUNE_CATEGORY, 1.245
- STANDBY_ARCHIVE_DEST, 1.246
- STANDBY_FILE_MANAGEMENT, 1.247
- STAR_TRANSFORMATION_ENABLED, 1.248
- STATISTICS_LEVEL, 1.249
- STREAMS_POOL_SIZE, 1.250
- TAPE_ASYNCH_IO, 1.251
- THREAD, 1.252
- TIMED_OS_STATISTICS, 1.253
- TIMED_STATISTICS, 1.254
- TRACE_ENABLED, 1.255
- TRACEFILE_IDENTIFIER, 1.256
- TRANSACTIONS, 1.257
- TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.258
- UNDO_MANAGEMENT, 1.259
- UNDO_RETENTION, 1.260
- UNDO_TABLESPACE, 1.261
- USE_INDIRECT_DATA_BUFFERS, 1.262
- USER_DUMP_DEST, 1.263
- UTL_FILE_DIR, 1.264
- variable, 1.1.1.3
- WORKAREA_SIZE_POLICY, 1.265
- XML_DB_EVENTS, 1.266
- INITJVM.SQL script, B.5
- INIT.ORA file. See initialization parameter file
- IN-list iterators
-
- optimizer use of, 1.165
- inserts
-
- locating free space, 1.102
- INST_ID column, 7.1.2
- INSTANCE clause
-
- of ALTER TABLE
-
- allocating extents, 1.102
- INSTANCE_GROUPS initialization parameter, 1.100
- INSTANCE_NAME initialization parameter, 1.101
- INSTANCE_NUMBER initialization parameter, 1.102
- INSTANCE_TYPE initialization parameter, 1.103
- instances
-
- checkpoint, 1.130
- startup order, 1.102
- I/O
-
- reading multiple blocks, 1.54
- redo log files, 1.129
J
- Java initialization parameters
-
- JAVA_MAX_SESSIONSPACE_SIZE, 1.105
- JAVA_POOL_SIZE, 1.106
- JAVA_SOFT_SESSIONSPACE_LIMIT, 1.107
- Java scripts, B.5
- JAVA_JIT_ENABLED initialization parameter, 1.104
- JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.105
- JAVA_POOL_SIZE initialization parameter, 1.106
- JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.107
- JOB_QUEUE_PROCESSES initialization parameter, 1.108
L
- language
-
- database default language, 1.147
- LARGE_POOL_SIZE initialization parameter, 1.109
- LDAP_DIRECTORY_ACCESS initialization parameter, 1.110
- LDAP_DIRECTORY_SYSAUTH initialization parameter, 1.111
- LICENSE_MAX_SESSIONS initialization parameter, 1.112
- LICENSE_MAX_USERS initialization parameter, 1.113
- LICENSE_SESSIONS_WARNING initialization parameter, 1.114
- licenses
-
- maximum sessions, 1.112
- maximum users, 1.113
- warning for concurrent user sessions, 1.114
- limits on the database, A
- linguistic sorts, 1.151
- LISTENER_NETWORKS initialization parameter, 1.115
- local currency, 1.141, 1.142
- LOCAL_LISTENER initialization parameter, 1.116
- LOCK_NAME_SPACE initialization parameter, 1.117
- LOCK_SGA initialization parameter, 1.118
- locks
-
- names, C.2
- LOG_ARCHIVE_CONFIG initialization parameter, 1.119
- LOG_ARCHIVE_DEST initialization parameter, 1.120
- LOG_ARCHIVE_DEST_n initialization parameter, 1.121
- LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.122
- LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.123
- LOG_ARCHIVE_FORMAT initialization parameter, 1.124
- LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.125
- LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.126
- LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.127
- LOG_ARCHIVE_TRACE initialization parameter, 1.128
- LOG_BUFFER initialization parameter, 1.129
- LOG_CHECKPOINT_INTERVAL initialization parameter, 1.130
- LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.131
- LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.132
- LOG_FILE_NAME_CONVERT initialization parameter, 1.133
- LOGSTDBY_UNSUPPORTED_TABLES synonym for DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 6.139
- lowercase significance, 1.3.2.1.1
M
- MAP_OBJECT table, 6.140
- MAX_DISPATCHERS initialization parameter, 1.134
- MAX_DUMP_FILE_SIZE initialization parameter, 1.135
- MAX_ENABLED_ROLES initialization parameter, 1.136
- MAX_SHARED_SERVERS initialization parameter, 1.137
- memory
-
- amount used for sorting, 1.240
- virtual, 1.1.1.3
- MEMORY_MAX_TARGET initialization parameter, 1.138
- MEMORY_TARGET initialization parameter, 1.139
- monitor
-
- performance, 1.130
- multiple-process systems
-
- number of processes, 1.197
N
- NLS_CALENDAR initialization parameter, 1.140
- NLS_COMP initialization parameter, 1.141
- NLS_CURRENCY initialization parameter, 1.142
-
- defined by NLS_TERRITORY, 1.152
- NLS_DATABASE_PARAMETERS view, 6.141
- NLS_DATE_FORMAT initialization parameter, 1.143
-
- defined by NLS_NUMERIC_CHARACTERS, 1.150
- defined by NLS_TERRITORY, 1.152
- NLS_DATE_LANGUAGE initialization parameter, 1.144
- NLS_DUAL_CURRENCY initialization parameter, 1.145
- NLS_INSTANCE_PARAMETERS view, 6.142
- NLS_ISO_CURRENCY initialization parameter, 1.146
-
- defined by NLS_TERRITORY, 1.152
- NLS_LANGUAGE initialization parameter, 1.147
- NLS_LENGTH_SEMANTICS initialization parameter, 1.148
- NLS_NCHAR_CONV_EXCP initialization parameter, 1.149
- NLS_NUMERIC_CHARACTERS initialization parameter, 1.150
- NLS_SESSION_PARAMETERS view, 6.143
- NLS_SORT initialization parameter, 1.151
- NLS_TERRITORY initialization parameter, 1.152
- NLS_TIME_FORMAT, 8.75
- NLS_TIME_TZ_FORMAT, 8.75
- NLS_TIMESTAMP_FORMAT initialization parameter, 1.153
- NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.154
- numeric group separators, 1.150
O
- O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.155
- OBJ synonym for USER_OBJECTS view, 6.144
- OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.156
- OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.157
- objects
-
- data dictionary, 2.1
- OLAP_PAGE_POOL_SIZE initialization parameter, 1.158
- online redo log
-
- archiving mode, 1.120
- block, 1.130
- file size, 1.130
- setting checkpoint interval, 1.130
- OPEN_CURSORS initialization parameter, 1.159
- OPEN_LINKS initialization parameter, 1.160
- OPEN_LINKS_PER_INSTANCE initialization parameter, 1.161
- operating system
-
- authenticating remote clients, 1.208
- authenticating users and passwords, 1.172
- dependent parameters, 1.1.1.2
- roles for remote clients, 1.209
- optimization
-
- trading cursor space for time, 1.43
- OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES initialization parameter, 1.162
- OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.163
- OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.164
- OPTIMIZER_INDEX_CACHING initialization parameter, 1.165
- OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.166
- OPTIMIZER_MODE initialization parameter, 1.167
- OPTIMIZER_SECURE_VIEW_MERGING initialization parameter, 1.168
- OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter, 1.169
- OPTIMIZER_USE_PENDING_STATISTICS initialization parameter, 1.170
- OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter, 1.171
- ORPHAN_KEY_TABLE table. See DBA_ORPHAN_KEY_TABLE view
- OS_AUTHENT_PREFIX initialization parameter, 1.172
- OS_ROLES initialization parameter, 1.173
P
- parallel query
-
- maximum number of instances, 1.178
- maximum number of servers, 1.182
- minimum number of queries, 1.184
- PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.174
- PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.175
- PARALLEL_DEGREE_LIMIT initialization parameter, 1.176
- PARALLEL_DEGREE_POLICY initialization parameter, 1.177
- PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.178
- PARALLEL_FORCE_LOCAL initialization parameter, 1.179
- PARALLEL_INSTANCE_GROUP initialization parameter, 1.180
- PARALLEL_IO_CAP_ENABLED initialization parameter, 1.181
- PARALLEL_MAX_SERVERS initialization parameter, 1.182
- PARALLEL_MIN_PERCENT initialization parameter, 1.183
- PARALLEL_MIN_SERVERS initialization parameter, 1.184
- PARALLEL_MIN_TIME_THRESHOLD initialization parameter, 1.185
- PARALLEL_SERVERS_TARGET initialization parameter, 1.186
- PARALLEL_THREADS_PER_CPU initialization parameter, 1.187
- passwords
-
- authenticating, 1.172, 1.208
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.207
- PATH_VIEW view, 6.145
- performance, 1.1.1.3
-
- shared pool, 1.235
- PGA_AGGREGATE_TARGET initialization parameter, 1.188
- PLAN_TABLE table, 6.146
- PLSCOPE_SETTINGS initialization parameter, 1.189
- PLSQL_CCFLAGS initialization parameter, 1.190
- PLSQL_CODE_TYPE initialization parameter, 1.191
- PLSQL_DEBUG initialization parameter, 1.192
- PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.193
- PLSQL_V2_COMPATIBILITY initialization parameter, 1.194
- PLSQL_WARNINGS initialization parameter, 1.195
- PLUGGABLE_SET_CHECK view, 6.147
- PRE_PAGE_SGA initialization parameter, 1.196
- privileges
-
- remote login, 1.207
- RESTRICTED_SESSION privilege, 1.112, 1.114
- table-level select privileges, 1.244
- procedures
-
- shared pool, 1.235
- processes
-
- dispatcher process maximum number, 1.134
- maximum shared server processes, 1.137
- number of server processes, 1.105, 1.107, 1.236, 1.237
- recovery, 1.202
- trace files, 1.263
- user processes, 1.197
- PROCESSES initialization parameter, 1.197
- PRODUCT_COMPONENT_VERSION view, 6.148
- profiles
-
- resource limits, 1.211, 1.213
- PROXY_USERS view, 6.149
- PSTUBTBL table, 6.150
- PUBLIC clause
-
- of ALTER DATABASE
-
- thread of redo, 1.252
- PUBLIC_DEPENDENCY view, 6.151
- PUBLICSYN view, 6.152
Q
- queries
-
- hints, 1.167
- QUERY_REWRITE_ENABLED initialization parameter, 1.198
- QUERY_REWRITE_INTEGRITY initialization parameter, 1.199
- QUEUE_PRIVILEGES view, 6.153
R
- RC_ARCHIVED_LOG view, 2.1.3
- RC_BACKUP_ARCHIVELOG_DETAILS view, 2.1.3
- RC_BACKUP_ARCHIVELOG_SUMMARY view, 2.1.3
- RC_BACKUP_CONTROLFILE view, 2.1.3
- RC_BACKUP_CONTROLFILE_DETAILS view, 2.1.3
- RC_BACKUP_CONTROLFILE_SUMMARY view, 2.1.3
- RC_BACKUP_COPY_DETAILS view, 2.1.3
- RC_BACKUP_COPY_SUMMARY view, 2.1.3
- RC_BACKUP_CORRUPTION view, 2.1.3
- RC_BACKUP_DATAFILE view, 2.1.3
- RC_BACKUP_DATAFILE_DETAILS view, 2.1.3
- RC_BACKUP_DATAFILE_SUMMARY view, 2.1.3
- RC_BACKUP_FILES view, 2.1.3
- RC_BACKUP_PIECE view, 2.1.3
- RC_BACKUP_PIECE_DETAILS view, 2.1.3
- RC_BACKUP_REDOLOG view, 2.1.3
- RC_BACKUP_SET view, 2.1.3
- RC_BACKUP_SET_DETAILS view, 2.1.3
- RC_BACKUP_SET_SUMMARY view, 2.1.3
- RC_BACKUP_SPFILE view, 2.1.3
- RC_BACKUP_SPFILE_DETAILS view, 2.1.3
- RC_BACKUP_SPFILE_SUMMARY view, 2.1.3
- RC_CHECKPOINT view, 2.1.3
- RC_CONTROLFILE_COPY view, 2.1.3
- RC_COPY_CORRUPTION view, 2.1.3
- RC_DATABASE view, 2.1.3
- RC_DATABASE_BLOCK_CORRUPTION view, 2.1.3
- RC_DATABASE_INCARNATION view, 2.1.3
- RC_DATAFILE view, 2.1.3
- RC_DATAFILE_COPY view, 2.1.3
- RC_LOG_HISTORY view, 2.1.3
- RC_OFFLINE_RANGE view, 2.1.3
- RC_PROXY_ARCHIVEDLOG view, 2.1.3
- RC_PROXY_ARCHIVELOG_DETAILS view, 2.1.3
- RC_PROXY_ARCHIVELOG_SUMMARY view, 2.1.3
- RC_PROXY_CONTROLFILE view, 2.1.3
- RC_PROXY_COPY_DETAILS view, 2.1.3
- RC_PROXY_COPY_SUMMARY view, 2.1.3
- RC_PROXY_DATAFILE view, 2.1.3
- RC_REDO_LOG view, 2.1.3
- RC_REDO_THREAD view, 2.1.3
- RC_RESTORE_POINT view, 2.1.3
- RC_RESYNC view, 2.1.3
- RC_RMAN_BACKUP_JOB_DETAILS view, 2.1.3
- RC_RMAN_BACKUP_SUBJOB_DETAILS view, 2.1.3
- RC_RMAN_BACKUP_TYPE view, 2.1.3
- RC_RMAN_CONFIGURATION view, 2.1.3
- RC_RMAN_OUTPUT view, 2.1.3
- RC_RMAN_STATUS view, 2.1.3
- RC_SITE view, 2.1.3
- RC_STORED_SCRIPT view, 2.1.3
- RC_STORED_SCRIPT_LINE view, 2.1.3
- RC_TABLESPACE view, 2.1.3
- RC_TEMPFILE view, 2.1.3
- RC_UNUSABLE_BACKUPFILE_DETAILS view, 2.1.3
- RDBMS_SERVER_DN initialization parameter, 1.200
- READ_ONLY_OPEN_DELAYED initialization parameter, 1.201
- Real Application Clusters
-
- dynamic performance views, 7.1.2
- initialization parameters
-
- CIRCUITS, 1.23
- CLUSTER_DATABASE, 1.26
- CLUSTER_DATABASE_INSTANCES, 1.27
- CLUSTER_INTERCONNECTS, 1.28
- DISPATCHERS, 1.78
- FAST_START_PARALLEL_ROLLBACK, 1.87
- PARALLEL_ADAPTIVE_MULTI_USER, 1.174
- PARALLEL_AUTOMATIC_TUNING, 1.175
- PARALLEL_EXECUTION_MESSAGE_SIZE, 1.178
- PARALLEL_INSTANCE_GROUP, 1.180
- PARALLEL_MAX_SERVERS, 1.182
- PARALLEL_MIN_PERCENT, 1.183
- PARALLEL_MIN_SERVERS, 1.184
- PARALLEL_THREADS_PER_CPU, 1.187
- recovery
-
- number of required processes, 1.202
- RECOVERY_PARALLELISM initialization parameter, 1.202
- RECYCLEBIN initialization parameter, 1.203
- RECYCLEBIN synonym for USER_RECYCLEBIN view, 6.154
- redo logs
-
- buffer size, 1.129
- redo thread, 1.252
- REDO_TRANSPORT_USER initialization parameter, 1.204
- remote clients
-
- authenticating, 1.208
- remote logins, 1.207
- REMOTE_DEPENDENCIES_MODE initialization parameter, 1.205
- REMOTE_LISTENER initialization parameter, 1.206
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.207
- REMOTE_OS_AUTHENT initialization parameter, 1.208
- REMOTE_OS_ROLES initialization parameter, 1.209
- REPAIR_TABLE table. See DBA_REPAIR_TABLE view
- REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.210
- REPORT_COMPONENTS view, 6.155
- REPORT_FILES view, 6.156
- REPORT_FORMATS view, 6.157
- resource limits for profiles, 1.211, 1.213
- RESOURCE_COST view, 6.158
- RESOURCE_LIMIT initialization parameter, 1.211
- RESOURCE_MANAGER_CPU_ALLOCATION initialization parameter, 1.212
- RESOURCE_MANAGER_PLAN initialization parameter, 1.213
- RESOURCE_MAP table, 6.159
- RESOURCE_VIEW view, 6.160
- RESULT_CACHE_MAX_RESULT initialization parameter, 1.214
- RESULT_CACHE_MAX_SIZE initialization parameter, 1.215
- RESULT_CACHE_MODE initialization parameter, 1.216
- RESULT_CACHE_REMOTE_EXPIRATION initialization parameter, 1.217
- RESUMABLE_TIMEOUT initialization parameter, 1.218
- RMJVM.SQL script, B.5
- ROLE_ROLE_PRIVS view, 6.161
- ROLE_SYS_PRIVS view, 6.162
- ROLE_TAB_PRIVS view, 6.163
- ROLE_WM_PRIVS view, 2.1.2
- roles, 1.173
-
- remote clients, 1.209
- ROLLBACK_SEGMENTS initialization parameter, 1.219
S
- SCHEDULER_BATCH_ERRORS view, 6.164
- scripts
-
- CATALOG.SQL, B.1
- CATBLOCK.SQL, B.2
- CATCLUST.SQL, B.1
- CATDWGRD.SQL, B.4
- CATEXP7.SQL, B.2
- CATHS.SQL, B.2
- CATIO.SQL, B.2
- CATJAVA.SQL, B.5
- CATNOADT.SQL, B.3
- CATNOAUD.SQL, B.3
- CATNOHS.SQL, B.3
- CATNOPRT.SQL, B.3
- CATNOSVM.SQL, B.3
- CATNSNMP.SQL, B.3
- CATOCTK.SQL, B.2
- CATPROC.SQL, B.1
- CATQUEUE.SQL, B.2
- CATREP.SQL, B.2
- CATUPGRD.SQL, B.4
- data dictionary, B.2
- DBMSIOTC.SQL, B.2
- DBMSPOOL.SQL, B.2
- downgrading, B.4
- INITJVM.SQL, B.5
- Java, B.5
- RMJVM.SQL, B.5
- SQL scripts, B.1
- upgrading, B.4
- USERLOCK.SQL, B.2
- UTLBSTAT.SQL, B.2
- UTLCHN1.SQL, B.2
- UTLCONST.SQL, B.2
- UTLDTREE.SQL, B.2
- UTLESTAT.SQL, B.2
- UTLEXPT1.SQL, B.2
- UTLIP.SQL, B.2
- UTLIRP.SQL, B.2
- UTLLOCKT.SQL, B.2
- UTLPWDMG.SQL, B.2
- UTLRP.SQL, B.2
- UTLSAMPL.SQL, B.2
- UTLSCLN.SQL, B.2
- UTLTKPRF.SQL, B.2
- UTLU111I.SQL, B.4
- UTLU111S.SQL, B.4
- UTLVALID.SQL, B.2
- UTLXPLAN.SQL, B.2
- SEC_CASE_SENSITIVE_LOGON initialization parameter, 1.220
- SEC_MAX_FAILED_LOGIN_ATTEMPTS initialization parameter, 1.221
- SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter, 1.222
- SEC_PROTOCOL_ERROR_TRACE_ACTION initialization parameter, 1.223
- SEC_RETURN_SERVER_RELEASE_BANNER initialization parameter, 1.224
- SEQ synonym for USER_SEQUENCES view, 6.165
- SERIAL_REUSE initialization parameter, 1.225
- server parameter file
-
- overview, 1.3
- server processes
-
- number, 1.105, 1.107, 1.236, 1.237
- SERVICE_NAMES initialization parameter, 1.226
- SESSION_CACHED_CURSORS initialization parameter, 1.227
- SESSION_CONTEXT view, 6.166
- SESSION_MAX_OPEN_FILES initialization parameter, 1.228
- SESSION_PRIVS view, 6.167
- SESSION_ROLES view, 6.168
- SESSIONS initialization parameter, 1.229
- SGA_MAX_SIZE initialization parameter, 1.230
- SGA_TARGET initialization parameter, 1.231
- SHADOW_CORE_DUMP initialization parameter, 1.232
- shared server
-
- SESSIONS initialization parameter, 1.229
- shared server processes
-
- maximum number, 1.137
- SHARED_MEMORY_ADDRESS initialization parameter, 1.233
- SHARED_POOL_RESERVED_SIZE initialization parameter, 1.234
- SHARED_POOL_SIZE initialization parameter, 1.235
- SHARED_SERVER_SESSIONS initialization parameter, 1.236
- SHARED_SERVERS initialization parameter, 1.237
- SHOW PARAMETERS command, 1.4.3
- SKIP_UNUSABLE_INDEXES initialization parameter, 1.238
- SMTP_OUT_SERVER initialization parameter, 1.239
- SORT_AREA_RETAINED_SIZE initialization parameter, 1.240
- SORT_AREA_SIZE initialization parameter, 1.241
- sorting
-
- maximum memory, 1.240
- ORDER BY queries, 1.151
- SOURCE_SIZE view, 6.169
- SPFILE initialization parameter, 1.242
- SQL scripts
-
- creating the data dictionary, B.1
- optional, B.2
- required, B.1
- SQL_TRACE initialization parameter, 1.243
- SQL92_SECURITY initialization parameter, 1.244
- SQLTUNE_CATEGORY initialization parameter, 1.245
- STANDBY_ARCHIVE_DEST initialization parameter, 1.246
- STANDBY_FILE_MANAGEMENT initialization parameter, 1.247
- STAR_TRANSFORMATION_ENABLED initialization parameter, 1.248
- starting up
-
- instance number, 1.102
- startup order, 1.102
- statistics
-
- background checkpoints completed, E.2
- background checkpoints started, E.2
- background timeouts, E.2
- branch node splits, E.2
- buffer is not pinned count, E.2
- buffer is pinned count, E.2
- bytes received via SQL*Net from client, E.2
- bytes received via SQL*Net from dblink, E.2
- bytes sent via SQL*Net to client, E.2
- bytes sent via SQL*Net to dblink, E.2
- Cached Commit SCN referenced, E.2
- calls to get snapshot scn
-
- kcmgss, E.2
- calls to kcmgas, E.2
- calls to kcmgcs, E.2
- calls to kcmgrs, E.2
- change write time, E.2
- cleanouts and rollbacks - consistent read gets, E.2
- cleanouts only - consistent read gets, E.2
- cluster key scan block gets, E.2
- cluster key scans, E.2
- cold recycle reads, E.2
- commit cleanout failures
-
- block lost, E.2
- buffer being written, E.2
- callback failure, E.2
- cannot pin, E.2
- hot backup in progress, E.2
- write disabled, E.2
- commit cleanouts, E.2
- commit cleanouts successfully completed, E.2
- Commit SCN cached, E.2
- consistent changes, E.2
- consistent gets, E.2
- consistent gets direct, E.2
- consistent gets from cache, E.2
- CPU used by this session, E.2
- CPU used when call started, E.2
- CR blocks created, E.2
- current blocks converted for CR, E.2
- cursor authentications, E.2
- data blocks consistent reads - undo records applied, E.2
- db block changes, E.2
- db block gets, E.2
- db block gets direct, E.2
- db block gets from cache, E.2
- DBWR buffers scanned, E.2
- DBWR checkpoint buffers written, E.2
- DBWR checkpoints, 1.130, E.2
- DBWR cross instance writes, E.2
- DBWR free buffers found, E.2
- DBWR lru scans, E.2
- DBWR make free requests, E.2
- DBWR revisited being-written buffer, E.2
- DBWR summed scan depth, E.2
- DBWR transaction table writes, E.2
- DBWR undo block writes, E.2
- DDL statements parallelized, E.2
- deferred (CURRENT) block cleanout applications, E.2
- DFO trees parallelized, E.2
- dirty buffers inspected, E.2
- DML statements parallelized, E.2
- enqueue conversions, E.2
- enqueue deadlocks, E.2
- enqueue releases, E.2
- enqueue requests, E.2
- enqueue timeouts, E.2
- enqueue waits, E.2
- exchange deadlocks, E.2
- execute count, E.2
- flash cache eviction: aged out, E.2
- flash cache eviction: buffer pinned, E.2
- flash cache eviction: invalidated, E.2
- flash cache insert skip: corrupt, E.2
- flash cache insert skip: DBWR overloaded, E.2
- flash cache insert skip: exists, E.2
- flash cache insert skip: modification, E.2
- flash cache insert skip: not current, E.2
- flash cache insert skip: not useful, E.2
- flash cache inserts, E.2
- flashback log write bytes, E.2
- flashback log writes, E.2
- free buffer inspected, E.2
- free buffer requested, E.2
- global cache blocks corrupt, E.2
- global cache convert time, E.2
- global cache convert timeouts, E.2
- global cache converts, E.2
- global cache cr block log flush time, E.2, E.2
- global cache cr block receive time, E.2
- global cache cr block send time, E.2
- global cache cr block serve time, E.2, E.2
- global cache cr blocks served, E.2
- global cache cr requests blocked, E.2
- global cache cr timeouts, E.2
- global cache defers, E.2
- global cache freelist waits, E.2
- global cache get time, E.2
- global cache gets, E.2
- global cache prepare failures, E.2
- global lock async converts, E.2
- global lock async gets, E.2
- global lock convert time, E.2
- global lock get time, E.2
- global lock releases, E.2
- global lock sync converts, E.2
- global lock sync gets, E.2
- hot buffers moved to head of LRU, E.2
- immediate (CR) block cleanout applications, E.2
- immediate (CURRENT) block cleanout applications, E.2
- index fast full scans (direct read), E.2
- index fast full scans (full), E.2
- index fast full scans (rowid ranges), E.2
- instance recovery database freeze count, E.2
- kcmccs called get current scn, E.2
- kcmccs read scn without going to DLM, E.2
- kcmggs waited for batching, E.2
- leaf node splits, E.2
- lob reads, E.2
- lob writes, E.2
- lob writes unaligned, E.2
- logons cumulative, E.2
- logons current, E.2
- messages received, E.2
- messages sent, E.2
- native hash arithmetic execute, E.2
- native hash arithmetic fail, E.2
- next scns gotten without going to DLM, E.2
- no buffer to keep pinned count, E.2
- no work - consistent read gets, E.2
- opened cursors cumulative, E.2
- opened cursors current, E.2
- opens of replaced files, E.2
- opens requiring cache replacement, E.2
- operating system
-
- OS All other sleep time, E.2
- OS Chars read and written, E.2
- OS Data page fault sleep time, E.2
- OS Input blocks, E.2
- OS Involuntary context switches, E.2
- OS Kernel page fault sleep time, E.2
- OS Major page faults, E.2
- OS Messages received, E.2
- OS Messages sent, E.2
- OS Minor page faults, E.2
- OS Other system trap CPU time, E.2
- OS Output blocks, E.2
- OS Process heap time, E.2
- OS Signals received, E.2
- OS Swaps, E.2
- OS System call CPU time, E.2
- OS System calls, E.2
- OS Text page fault sleep time, E.2
- OS User level CPU time, E.2
- OS User lock wait sleep time, E.2
- OS Voluntary context switches, E.2
- OS Wait-cpu (latency) time, E.2
- Process stack size, E.2
- Parallel operations downgraded 1 to 25 pct, E.2
- Parallel operations downgraded 25 to 50 pct, E.2
- Parallel operations downgraded 50 to 75 pct, E.2
- Parallel operations downgraded 75 to 99 pct, E.2
- Parallel operations downgraded to serial, E.2
- Parallel operations not downgraded, E.2
- parse count (describe), E.2
- parse count (hard), E.2
- parse count (total), E.2
- parse time cpu, E.2
- parse time elapsed, E.2
- physical read bytes, E.2
- physical read flash cache hits, E.2
- physical read IO requests, E.2
- physical read requests optimized, E.2
- physical read total bytes, E.2
- physical read total IO requests, E.2
- physical read total multi block requests, E.2
- physical reads, E.2
- physical reads cache, E.2
- physical reads cache prefetch, E.2
- physical reads direct, E.2
- physical reads direct (lob), E.2
- physical reads direct temporary tablespace, E.2
- physical reads for flashback new, E.2
- physical reads prefetch warmup, E.2
- physical write bytes, E.2
- physical write IO requests, E.2
- physical write total bytes, E.2
- physical write total IO requests, E.2
- physical write total multi block requests, E.2
- physical writes, E.2
- physical writes direct, E.2
- physical writes direct (lob), E.2
- physical writes direct temporary tablespace, E.2
- physical writes from cache, E.2
- physical writes non checkpoint, E.2
- pinned buffers inspected, E.2
- prefetched blocks aged out before use, E.2
- process last non-idle time, E.2
- PX local messages recv'd, E.2
- PX local messages sent, E.2
- PX remote messages recv'd, E.2
- PX remote messages sent, E.2
- queries parallelized, E.2
- recovery array read time, E.2
- recovery array reads, E.2
- recovery blocks read, E.2
- recovery blocks read for lost write detection, E.2
- recovery blocks skipped lost write checks, E.2
- recursive calls, E.2
- recursive cpu usage, E.2
- redo blocks checksummed by FG (exclusive), E.2
- redo blocks checksummed by LGWR, E.2
- redo blocks written, E.2
- redo buffer allocation retries, E.2
- redo entries, E.2
- redo entries for lost write detection, E.2
- redo log space requests, E.2
- redo log space wait time, E.2
- redo ordering marks, E.2
- redo size, E.2
- redo size for lost write detection, E.2
- redo synch time, E.2
- redo synch writes, E.2
- redo wastage, E.2
- redo write time, E.2
- redo writer latching time, E.2, E.2
- redo writes, E.2
- remote instance undo block writes, E.2
- remote instance undo header writes, E.2
- rollback changes - undo records applied, E.2
- rollbacks only - consistent read gets, E.2
- rows fetched via callback, E.2
- serializable aborts, E.2
- session connect time, E.2
- session cursor cache count, E.2
- session cursor cache hits, E.2
- session logical reads, E.2
- session pga memory, E.2
- session pga memory max, E.2
- session stored procedure space, E.2
- session uga memory, E.2
- session uga memory max, E.2
- shared io pool buffer get failure, E.2
- shared io pool buffer get success, E.2
- sorts (disk), E.2
- sorts (memory), E.2
- sorts (rows), E.2
- SQL*Net roundtrips to/from client, E.2
- SQL*Net roundtrips to/from dblink, E.2
- summed dirty queue length, E.2
- switch current to new buffer, E.2
- table fetch by rowid, E.2
- table fetch continued row, E.2
- table scan blocks gotten, E.2
- table scan rows gotten, E.2
- table scans (cache partitions), E.2
- table scans (direct read), E.2
- table scans (long tables), E.2
- table scans (rowid ranges), E.2
- table scans (short tables), E.2
- timed, 1.254
- total file opens, E.2
- transaction lock background get time, E.2
- transaction lock background gets, E.2
- transaction lock foreground requests, E.2
- transaction lock foreground wait time, E.2
- transaction rollbacks, E.2
- transaction tables consistent read rollbacks, E.2
- transaction tables consistent reads - undo records applied, E.2
- Unnecessary process cleanup for SCN batching, E.2
- user calls, E.2
- user commits, E.2
- user rollbacks, E.2
- write clones created in background, E.2
- write clones created in foreground, E.2
- STATISTICS_LEVEL initialization parameter, 1.249
- STMT_AUDIT_OPTION_MAP table, 6.170
- STREAMS_POOL_SIZE initialization parameter, 1.250
- switch redo log file, 1.130
- SYN synonym for USER_SYNONYMS view, 6.171
- SYNONYMS view, 6.172
- SYS_OBJECTS view, 6.173
- SYSCATALOG view, 6.174
- SYSFILES view, 6.175
- SYSSEGOBJ view, 6.176
- system global area, 1.1.1.3
-
- buffer areas, 1.129
- system performance, 1.1.1.3
- SYSTEM_PRIVILEGE_MAP table, 6.177
T
- TAB view, 6.178
- TABLE_PRIVILEGE_MAP table, 6.179
- tables
-
- data dictionary, 2.1
- DML locks, 1.80
- locating free space, 1.102
- TABQUOTAS view, 6.180
- TABS synonym for USER_TABLES view, 6.181
- tape archiving destination, 1.120
- TAPE_ASYNCH_IO initialization parameter, 1.251
- territory, 1.145, 1.152
- THREAD initialization parameter, 1.252
- TIMED_OS_STATISTICS initialization parameter, 1.253
- TIMED_STATISTICS initialization parameter, 1.254
-
- file read/write statistics, 7.139, 9.108
- TO_CHAR function, 1.143
- TO_DATE function, 1.143
- trace files
-
- destination, 1.263
- maximum size, 1.135
- TRACE_ENABLED initialization parameter, 1.255
- TRACEFILE_IDENTIFIER initialization parameter, 1.256
- transactions
-
- data locking, 1.80
- TRANSACTIONS initialization parameter, 1.257
-
- DML locks, 1.80
- TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.258
- TRUSTED_SERVERS view, 6.182
- TS_PITR_CHECK view, 6.183
- TS_PITR_OBJECTS TO_BE_DROPPED view, 6.184
U
- UNDO_MANAGEMENT initialization parameter, 1.259
- UNDO_RETENTION initialization parameter, 1.260
- UNDO_TABLESPACE initialization parameter, 1.261
- UNI_PLUGGABLE_SET_CHECK view, 6.185
- updates
-
- locating free space, 1.102
- upgrading
-
- scripts, B.4
- uppercase characters, 1.3.2.1.1
- USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.262
- user processes
-
- trace files, 1.263
- USER_ADDM_FDG_BREAKDOWN view, 6.186
- USER_ADDM_FINDINGS view, 6.187
- USER_ADDM_INSTANCES view, 6.188
- USER_ADDM_TASKS view, 6.189
- USER_ADVISOR_ACTIONS view, 6.190
- USER_ADVISOR_DIR_TASK_INST view, 6.191
- USER_ADVISOR_EXEC_PARAMETERS view, 6.192
- USER_ADVISOR_EXECUTIONS view, 6.193
- USER_ADVISOR_FDG_BREAKDOWN view, 6.194
- USER_ADVISOR_FINDINGS view, 6.195
- USER_ADVISOR_JOURNAL view, 6.196
- USER_ADVISOR_LOG view, 6.197
- USER_ADVISOR_OBJECTS view, 6.198
- USER_ADVISOR_PARAMETERS view, 6.199
- USER_ADVISOR_RATIONALE view, 6.200
- USER_ADVISOR_RECOMMENDATIONS view, 6.201
- USER_ADVISOR_SQLA_REC_SUM view, 6.202
- USER_ADVISOR_SQLA_TABLES view, 6.203
- USER_ADVISOR_SQLA_WK_MAP view, 6.204
- USER_ADVISOR_SQLA_WK_STMTS view, 6.205
- USER_ADVISOR_SQLPLANS view, 6.206
- USER_ADVISOR_SQLSTATS view, 6.207
- USER_ADVISOR_SQLW_JOURNAL view, 6.208
- USER_ADVISOR_SQLW_PARAMETERS view, 6.209
- USER_ADVISOR_SQLW_STMTS view, 6.210
- USER_ADVISOR_SQLW_SUM view, 6.211
- USER_ADVISOR_SQLW_TABLES view, 6.212
- USER_ADVISOR_SQLW_TEMPLATES view, 6.213
- USER_ADVISOR_TASKS view, 6.214
- USER_ADVISOR_TEMPLATES view, 6.215
- USER_ALL_TABLES view, 6.216
- USER_AQ_AGENT_PRIVS view, 6.217
- USER_ARGUMENTS view, 6.218
- USER_ASSEMBLIES view, 6.219
- USER_ASSOCIATIONS view, 6.220
- USER_ATTRIBUTE_TRANSFORMATIONS view, 6.221
- USER_AUDIT_OBJECT view, 6.222
- USER_AUDIT_POLICIES view, 6.223
- USER_AUDIT_POLICY_COLUMNS view, 6.224
- USER_AUDIT_SESSION view, 6.225
- USER_AUDIT_STATEMENT view, 6.226
- USER_AUDIT_TRAIL view, 6.227
- USER_AW_PS view, 6.228
- USER_AWS view, 6.229
- USER_BASE_TABLE_MVIEWS view, 6.230
- USER_CATALOG view, 6.231
-
- CAT synonym, 3.147
- USER_CHANGE_NOTIFICATION_REGS view, 6.232
- USER_CLU_COLUMNS view, 6.233
- USER_CLUSTER_HASH_EXPRESSIONS view, 6.234
- USER_CLUSTERS view, 6.235
-
- CLU synonym, 3.156
- USER_COL_COMMENTS view, 6.236
- USER_COL_PENDING_STATS view, 6.237
- USER_COL_PRIVS view, 6.238
- USER_COL_PRIVS_MADE view, 6.239
- USER_COL_PRIVS_RECD view, 6.240
- USER_COLL_TYPES view, 6.241
- USER_COMPARISON view, 6.242
- USER_COMPARISON_COLUMNS view, 6.243
- USER_COMPARISON_ROW_DIF view, 6.244
- USER_COMPARISON_SCAN view, 6.245
- USER_COMPARISON_SCAN_VALUES view, 6.246
- USER_CONS_COLUMNS view, 6.247
- USER_CONS_OBJ_COLUMNS view, 6.248
- USER_CONSTRAINTS view, 6.249
- USER_CQ_NOTIFICATION_QUERIES view, 6.250
- USER_CUBE_ATTR_VISIBILITY view, 6.251
- USER_CUBE_ATTRIBUTES view, 6.252
- USER_CUBE_BUILD_PROCESSES view, 6.253
- USER_CUBE_CALCULATED_MEMBERS view, 6.254
- USER_CUBE_DIM_LEVELS view, 6.255
- USER_CUBE_DIM_MODELS view, 6.256
- USER_CUBE_DIM_VIEW_COLUMNS view, 6.257
- USER_CUBE_DIM_VIEWS view, 6.258
- USER_CUBE_DIMENSIONALITY view, 6.259
- USER_CUBE_DIMENSIONS view, 6.260
- USER_CUBE_HIER_LEVELS view, 6.261
- USER_CUBE_HIER_VIEW_COLUMNS view, 6.262
- USER_CUBE_HIER_VIEWS view, 6.263
- USER_CUBE_HIERARCHIES view, 6.264
- USER_CUBE_MEASURES view, 6.265
- USER_CUBE_VIEW_COLUMNS view, 6.266
- USER_CUBE_VIEWS view, 6.267
- USER_CUBES view, 6.268
- USER_DATAPUMP_JOBS view, 6.269
- USER_DB_LINKS view, 6.270
- USER_DBFS_HS_FILES view, 6.271
- USER_DEPENDENCIES view, 6.272
- USER_DIM_ATTRIBUTES view, 6.273
- USER_DIM_CHILD_OF view, 6.274
- USER_DIM_HIERARCHIES view, 6.275
- USER_DIM_JOIN_KEY view, 6.276
- USER_DIM_LEVEL_KEY view, 6.277
- USER_DIM_LEVELS view, 6.278
- USER_DIMENSIONS view, 6.279
- USER_DUMP_DEST initialization parameter, 1.263
- USER_EDITIONING_VIEW_COLS view, 6.280
- USER_EDITIONING_VIEW_COLS_AE view, 6.281
- USER_EDITIONING_VIEWS view, 6.282
- USER_EDITIONING_VIEWS_AE view, 6.283
- USER_ENCRYPTED_COLUMNS view, 6.284
- USER_EPG_DAD_AUTHORIZATION view, 6.285
- USER_ERRORS view, 6.286
- USER_ERRORS_AE view, 6.287
- USER_EVALUATION_CONTEXT_TABLES view, 6.288
- USER_EVALUATION_CONTEXT_VARS view, 6.289
- USER_EVALUATION_CONTEXTS view, 6.290
- USER_EXTENTS view, 6.291
- USER_EXTERNAL_LOCATIONS view, 6.292
- USER_EXTERNAL_TABLES view, 6.293
- USER_FILE_GROUP_EXPORT_INFO view, 6.294
- USER_FILE_GROUP_FILES view, 6.295
- USER_FILE_GROUP_TABLES view, 6.296
- USER_FILE_GROUP_TABLESPACES view, 6.297
- USER_FILE_GROUP_VERSIONS view, 6.298
- USER_FILE_GROUPS view, 6.299
- USER_FLASHBACK_ARCHIVE view, 6.300
- USER_FLASHBACK_ARCHIVE_TABLES view, 6.301
- USER_FLASHBACK_TXN_REPORT view, 6.302
- USER_FLASHBACK_TXN_STATE view, 6.303
- USER_FREE_SPACE view, 6.304
- USER_HISTOGRAMS synonym for USER_TAB_HISTOGRAMS, 6.305
- USER_IDENTIFIERS view, 6.306
- USER_IND_COLUMNS view, 6.307
- USER_IND_EXPRESSIONS view, 6.308
- USER_IND_PARTITIONS view, 6.309
- USER_IND_PENDING_STATS view, 6.310
- USER_IND_STATISTICS view, 6.311
- USER_IND_SUBPARTITIONS view, 6.312
- USER_INDEXES view, 6.313
-
- IND synonym, 6.136
- USER_INDEXTYPE_ARRAYTYPES view, 6.314
- USER_INDEXTYPE_COMMENTS view, 6.315
- USER_INDEXTYPE_OPERATORS view, 6.316
- USER_INDEXTYPES view, 6.317
- USER_INTERNAL_TRIGGERS view, 6.318
- USER_JAVA_ARGUMENTS view, 6.319
- USER_JAVA_CLASSES view, 6.320
- USER_JAVA_COMPILER_OPTIONS view, 6.321
- USER_JAVA_DERIVATIONS view, 6.322
- USER_JAVA_FIELDS view, 6.323
- USER_JAVA_IMPLEMENTS view, 6.324
- USER_JAVA_INNERS view, 6.325
- USER_JAVA_LAYOUTS view, 6.326
- USER_JAVA_METHODS view, 6.327
- USER_JAVA_NCOMPS view, 6.328
- USER_JAVA_POLICY view, 6.329
- USER_JAVA_RESOLVERS view, 6.330
- USER_JAVA_THROWS view, 6.331
- USER_JOBS view, 6.332
-
- ALL_JOBS synonym, 2.124
- USER_JOIN_IND_COLUMNS view, 6.333
- USER_LIBRARIES view, 6.334
- USER_LOB_PARTITIONS view, 6.335
- USER_LOB_SUBPARTITIONS view, 6.336
- USER_LOB_TEMPLATES view, 6.337
- USER_LOBS view, 6.338
- USER_LOG_GROUP_COLUMNS view, 6.339
- USER_LOG_GROUPS view, 6.340
- USER_MEASURE_FOLDER_CONTENTS view, 6.341
- USER_MEASURE_FOLDERS view, 6.342
- USER_METHOD_PARAMS view, 6.343
- USER_METHOD_RESULTS view, 6.344
- USER_MINING_MODEL_ATTRIBUTES view, 6.345
- USER_MINING_MODEL_SETTINGS view, 6.346
- USER_MINING_MODELS view, 6.347
- USER_MP_GRAPH_WORKSPACES view, 2.1.2
- USER_MP_PARENT_WORKSPACES view, 2.1.2
- USER_MVIEW_AGGREGATES view, 6.348
- USER_MVIEW_ANALYSIS view, 6.349
- USER_MVIEW_COMMENTS view, 6.350
- USER_MVIEW_DETAIL_PARTITION view, 6.351
- USER_MVIEW_DETAIL_RELATIONS view, 6.352
- USER_MVIEW_DETAIL_SUBPARTITION view, 6.353
- USER_MVIEW_JOINS view, 6.354
- USER_MVIEW_KEYS view, 6.355
- USER_MVIEW_LOGS view, 6.356
- USER_MVIEW_REFRESH_TIMES view, 6.357
- USER_MVIEWS view, 6.358
- USER_NESTED_TABLE_COLS view, 6.359
- USER_NESTED_TABLES view, 6.360
- USER_NETWORK_ACL_PRIVILEGES view, 6.361
- USER_OBJ_AUDIT_OPTS view, 6.362
- USER_OBJ_COLATTRS view, 6.363
- USER_OBJECT_SIZE view, 6.364
- USER_OBJECT_TABLES view, 6.365
- USER_OBJECTS view, 6.366
-
- OBJ synonym, 6.144
- USER_OBJECTS_AE view, 6.367
- USER_OPANCILLARY view, 6.368
- USER_OPARGUMENTS view, 6.369
- USER_OPBINDINGS view, 6.370
- USER_OPERATOR_COMMENTS view, 6.371
- USER_OPERATORS view, 6.372
- USER_OUTLINE_HINTS view, 6.373
-
- ALL_OUTLINE_HINTS synonym, 2.162
- USER_OUTLINES view, 6.374
-
- ALL_OUTLINES synonym, 2.163
- USER_PARALLEL_EXECUTE_CHUNKS view, 6.375
- USER_PARALLEL_EXECUTE_TASKS view, 6.376
- USER_PART_COL_STATISTICS view, 6.377
- USER_PART_HISTOGRAMS view, 6.378
- USER_PART_INDEXES view, 6.379
- USER_PART_KEY_COLUMNS view, 6.380
- USER_PART_LOBS view, 6.381
- USER_PART_TABLES view, 6.382
- USER_PARTIAL_DROP_TABS view, 6.383
- USER_PASSWORD_LIMITS view, 6.384
- USER_PENDING_CONV_TABLES view, 6.385
- USER_PLSQL_OBJECT_SETTINGS view, 6.386
- USER_POLICIES view, 6.387
- USER_POLICY_CONTEXTS view, 6.388
- USER_POLICY_GROUPS view, 6.389
- USER_PROCEDURES view, 6.390
- USER_PROXIES view, 6.391
- USER_PUBLISHED_COLUMNS view, 6.392
-
- ALL_PUBLISHED_COLUMNS synonym, 3.15
- USER_QUEUE_SCHEDULES view, 6.393
- USER_QUEUE_SUBSCRIBERS view, 6.394
- USER_QUEUE_TABLES view, 6.395
- USER_QUEUES view, 6.396
- USER_RECYCLEBIN view, 6.397
-
- RECYCLEBIN synonym, 6.154
- USER_REFRESH view, 6.398
- USER_REFRESH_CHILDREN view, 6.399
- USER_REFS view, 6.400
- USER_REGISTERED_MVIEWS view, 6.401
- USER_REGISTRY view, 6.402
- USER_REMOVED_WORKSPACES view, 2.1.2
- USER_REPCAT view, 2.1.1
- USER_REPCAT_REFRESH_TEMPLATES view, 2.1.1
- USER_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
- USER_REPCAT_TEMPLATE_PARMS view, 2.1.1
- USER_REPCAT_TEMPLATE_SITES view, 2.1.1
- USER_REPCAT_USER_AUTHORIZATION view, 2.1.1
- USER_REPCAT_USER_PARM_VALUES view, 2.1.1
- USER_REPCATLOG view, 2.1.1
- USER_REPCOLUMN view, 2.1.1
- USER_REPCOLUMN_GROUP view, 2.1.1
- USER_REPCONFLICT view, 2.1.1
- USER_REPDDL view, 2.1.1
- USER_REPFLAVOR_COLUMNS view, 2.1.1
- USER_REPFLAVOR_OBJECTS view, 2.1.1
- USER_REPFLAVORS view, 2.1.1
- USER_REPGENERATED view, 2.1.1
- USER_REPGENOBJECTS view, 2.1.1
- USER_REPGROUP view, 2.1.1
- USER_REPGROUP_PRIVILEGES view, 2.1.1
- USER_REPGROUPED_COLUMN view, 2.1.1
- USER_REPKEY_COLUMNS view, 2.1.1
- USER_REPOBJECT view, 2.1.1
- USER_REPPARAMETER_COLUMN view, 2.1.1
- USER_REPPRIORITY view, 2.1.1
- USER_REPPRIORITY_GROUP view, 2.1.1
- USER_REPPROP view, 2.1.1
- USER_REPRESOL_STATS_CONTROL view, 2.1.1
- USER_REPRESOLUTION view, 2.1.1
- USER_REPRESOLUTION_METHOD view, 2.1.1
- USER_REPRESOLUTION_STATISTICS view, 2.1.1
- USER_REPSCHEMA view, 2.1.1
- USER_REPSITES view, 2.1.1
- USER_RESOURCE_LIMITS view, 6.403
- USER_RESUMABLE view, 6.404
- USER_REWRITE_EQUIVALENCES view, 6.405
- USER_ROLE_PRIVS view, 6.406
- USER_RSRC_CONSUMER_GROUP_PRIVS view, 6.407
- USER_RSRC_MANAGER_SYSTEM_PRIVS view, 6.408
- USER_RULE_SET_RULES view, 6.409
- USER_RULE_SETS view, 6.410
- USER_RULES view, 6.411
- USER_SCHEDULER_CHAIN_RULES view, 6.412
- USER_SCHEDULER_CHAIN_STEPS view, 6.413
- USER_SCHEDULER_CHAINS view, 6.414
- USER_SCHEDULER_CREDENTIALS view, 6.415
- USER_SCHEDULER_DB_DESTS view, 6.416
- USER_SCHEDULER_DESTS view, 6.417
- USER_SCHEDULER_FILE_WATCHERS view, 6.418
- USER_SCHEDULER_GROUP_MEMBERS view, 6.419
- USER_SCHEDULER_GROUPS view, 6.420
- USER_SCHEDULER_JOB_ARGS view, 6.421
- USER_SCHEDULER_JOB_DESTS view, 6.422
- USER_SCHEDULER_JOB_LOG view, 6.423
- USER_SCHEDULER_JOB_RUN_DETAILS view, 6.424
- USER_SCHEDULER_JOBS view, 6.425
- USER_SCHEDULER_NOTIFICATIONS view, 6.426
- USER_SCHEDULER_PROGRAM_ARGS view, 6.427
- USER_SCHEDULER_PROGRAMS view, 6.428
- USER_SCHEDULER_REMOTE_JOBSTATE view, 6.429
- USER_SCHEDULER_RUNNING_CHAINS view, 6.430
- USER_SCHEDULER_RUNNING_JOBS view, 6.431
- USER_SCHEDULER_SCHEDULES view, 6.432
- USER_SEC_RELEVANT_COLS view, 6.433
- USER_SECONDARY_OBJECTS view, 6.434
- USER_SEGMENTS view, 6.435
- USER_SEQUENCES view, 6.436
-
- SEQ synonym, 6.165
- USER_SOURCE view, 6.437
- USER_SOURCE_AE view, 6.438
- USER_SOURCE_TABLES view, 6.439
-
- ALL_SOURCE_TABLES synonym, 3.66
- USER_SQLJ_TYPE_ATTRS view, 6.440
- USER_SQLJ_TYPE_METHODS view, 6.441
- USER_SQLJ_TYPES view, 6.442
- USER_SQLSET view, 6.443
- USER_SQLSET_BINDS view, 6.444
- USER_SQLSET_PLANS view, 6.445
- USER_SQLSET_REFERENCES view, 6.446
- USER_SQLSET_STATEMENTS view, 6.447
- USER_SQLTUNE_BINDS view, 6.448
- USER_SQLTUNE_PLANS view, 6.449
- USER_SQLTUNE_RATIONALE_PLAN view, 6.450
- USER_SQLTUNE_STATISTICS view, 6.451
- USER_STAT_EXTENSIONS view, 6.452
- USER_STORED_SETTINGS view, 6.453
- USER_SUBPART_COL_STATISTICS view, 6.454
- USER_SUBPART_HISTOGRAMS view, 6.455
- USER_SUBPART_KEY_COLUMNS view, 6.456
- USER_SUBPARTITION_TEMPLATES view, 6.457
- USER_SUBSCR_REGISTRATIONS view, 6.458
- USER_SUBSCRIBED_COLUMNS view, 6.459
-
- ALL_SUBSCRIBED_COLUMNS synonym, 3.93
- USER_SUBSCRIBED_TABLES view, 6.460
-
- ALL_SUBSCRIBED_TABLES synonym, 3.94
- USER_SUBSCRIPTIONS view, 6.461
-
- ALL_SUBSCRIPTIONS synonym, 3.95
- USER_SYNONYMS view, 6.462
-
- SYN synonym, 6.171
- USER_SYS_PRIVS view, 6.463
- USER_TAB_COL_STATISTICS view, 6.464
- USER_TAB_COLS view, 6.465
- USER_TAB_COLUMNS view, 6.466
-
- COLS synonym, 3.158
- USER_TAB_COMMENTS view, 6.467
- USER_TAB_HISTGRM_PENDING_STATS view, 6.468
- USER_TAB_HISTOGRAMS view, 6.469
-
- USER_HISTOGRAMS synonym, 6.305
- USER_TAB_MODIFICATIONS view, 6.470
- USER_TAB_PARTITIONS view, 6.471
- USER_TAB_PENDING_STATS view, 6.472
- USER_TAB_PRIVS view, 6.473
- USER_TAB_PRIVS_MADE view, 6.474
- USER_TAB_PRIVS_RECD view, 6.475
- USER_TAB_STAT_PREFS view, 6.476
- USER_TAB_STATISTICS view, 6.477
- USER_TAB_STATS_HISTORY view, 6.478
- USER_TAB_SUBPARTITIONS view, 6.479
- USER_TABLES view, 6.480
-
- TABS synonym, 6.181
- USER_TABLESPACES view, 6.481
- USER_TRANSFORMATIONS view, 6.482
- USER_TRIGGER_COLS view, 6.483
- USER_TRIGGER_ORDERING view, 6.484
- USER_TRIGGERS view, 6.485
- USER_TS_QUOTAS view, 6.486
- USER_TSTZ_TAB_COLS view, 6.487
- USER_TSTZ_TABLES view, 6.488
- USER_TUNE_MVIEW view, 6.489
- USER_TYPE_ATTRS view, 6.490
- USER_TYPE_METHODS view, 6.491
- USER_TYPE_VERSIONS view, 6.492
- USER_TYPES view, 6.493
- USER_UNUSED_COL_TABS view, 6.494
- USER_UPDATABLE_COLUMNS view, 6.495
- USER_USERS view, 6.496
- USER_USTATS view, 6.497
- USER_VARRAYS view, 6.498
- USER_VIEWS view, 6.499
- USER_VIEWS_AE view, 6.500
- USER_WARNING_SETTINGS view, 6.501
- USER_WM_CONS_COLUMNS view, 2.1.2
- USER_WM_CONSTRAINTS view, 2.1.2
- USER_WM_IND_COLUMNS view, 2.1.2
- USER_WM_IND_EXPRESSIONS view, 2.1.2
- USER_WM_LOCKED_TABLES view, 2.1.2
- USER_WM_MODIFIED_TABLES view, 2.1.2
- USER_WM_PRIVS view, 2.1.2
- USER_WM_RIC_INFO view, 2.1.2
- USER_WM_TAB_TRIGGERS view, 2.1.2
- USER_WM_VERSIONED_TABLES view, 2.1.2
- USER_WM_VT_ERRORS view, 2.1.2
- USER_WORKSPACE_PRIVS view, 2.1.2
- USER_WORKSPACE_SAVEPOINTS view, 2.1.2
- USER_WORKSPACES view, 2.1.2
- USER_XML_INDEXES view, 6.502
- USER_XML_SCHEMAS view, 6.503
- USER_XML_TAB_COLS view, 6.504
- USER_XML_TABLES view, 6.505
- USER_XML_VIEW_COLS view, 6.506
- USER_XML_VIEWS view, 6.507
- USERLOCK.SQL script, B.2
- users
-
- authenticating, 1.172
- multiple, 1.80
- UTL_FILE_DIR initialization parameter, 1.264
- UTLBSTAT.SQL script, B.2
- UTLCHN1.SQL script, B.2
- UTLCONST.SQL script, B.2
- UTLDTREE.SQL script, 6.112, 6.135, B.2
- UTLESTAT.SQL script, B.2
- UTLEXPT1.SQL script, B.2
- UTLIP.SQL script, B.2
- UTLIRP.SQL script, B.2
- UTLLOCKT.SQL script, B.2
- UTLPWDMG.SQL script, B.2
- UTLRP.SQL script, B.2
- UTLSAMPL.SQL script, B.2
- UTLSCLN.SQL script, B.2
- UTLTKPRF.SQL script, B.2
- UTLU111I.SQL script, B.4
- UTLU111S.SQL script, B.4
- UTLVALID.SQL script, B.2
- UTLXPLAN.SQL script, B.2
V
- V$ACCESS view, 7.3
- V$ACTIVE_INSTANCES view, 7.4
- V$ACTIVE_SERVICES view, 7.5
- V$ACTIVE_SESS_POOL_MTH view, 7.6
- V$ACTIVE_SESSION_HISTORY view, 7.7
- V$ADVISOR_PROGRESS view, 7.8
- V$ALERT_TYPES view, 7.9
- V$AQ view, 7.10
- V$ARCHIVE view, 7.11
- V$ARCHIVE_DEST view, 7.12
- V$ARCHIVE_DEST_STATUS view, 7.13
- V$ARCHIVE_GAP view, 7.14
- V$ARCHIVE_PROCESSES view, 7.15
- V$ARCHIVED_LOG view, 7.16
- V$ASM_ACFS_ENCRYPTION_INFO view, 7.17
- V$ASM_ACFS_SECURITY_INFO view, 7.18
- V$ASM_ACFSSNAPSHOTS view, 7.19
- V$ASM_ACFSVOLUMES view, 7.20
- V$ASM_ALIAS view, 7.21
- V$ASM_ATTRIBUTE view, 7.22
- V$ASM_CLIENT view, 7.23
- V$ASM_DISK view, 7.24
- V$ASM_DISK_IOSTAT view, 7.25
- V$ASM_DISK_STAT view, 7.26
- V$ASM_DISKGROUP view, 7.27
- V$ASM_DISKGROUP_STAT view, 7.28
- V$ASM_FILE view, 7.29
- V$ASM_FILESYSTEM view, 7.30
- V$ASM_OPERATION view, 7.31
- V$ASM_TEMPLATE view, 7.32
- V$ASM_USER view, 7.33
- V$ASM_USERGROUP view, 7.34
- V$ASM_USERGROUP_MEMBER view, 7.35
- V$ASM_VOLUME view, 7.36
- V$ASM_VOLUME_STAT view, 7.37
- V$AW_AGGREGATE_OP view, 7.38
- V$AW_ALLOCATE_OP view, 7.39
- V$AW_CALC view, 7.40
- V$AW_LONGOPS view, 7.41
- V$AW_OLAP view, 7.42
- V$AW_SESSION_INFO view, 7.43
- V$BACKUP view, 7.44
- V$BACKUP_ARCHIVELOG_DETAILS view, 7.45
- V$BACKUP_ARCHIVELOG_SUMMARY view, 7.46
- V$BACKUP_ASYNC_IO view, 7.47
- V$BACKUP_CONTROLFILE_DETAILS view, 7.48
- V$BACKUP_CONTROLFILE_SUMMARY view, 7.49
- V$BACKUP_COPY_DETAILS view, 7.50
- V$BACKUP_COPY_SUMMARY view, 7.51
- V$BACKUP_CORRUPTION view, 7.52
- V$BACKUP_DATAFILE view, 7.53
- V$BACKUP_DATAFILE_DETAILS view, 7.54
- V$BACKUP_DATAFILE_SUMMARY view, 7.55
- V$BACKUP_DEVICE view, 7.56
- V$BACKUP_FILES view, 7.57
- V$BACKUP_PIECE view, 7.58
- V$BACKUP_PIECE_DETAILS view, 7.59
- V$BACKUP_REDOLOG view, 7.60
- V$BACKUP_SET view, 7.61
- V$BACKUP_SET_DETAILS view, 7.62
- V$BACKUP_SET_SUMMARY view, 7.63
- V$BACKUP_SPFILE view, 7.64
- V$BACKUP_SPFILE_DETAILS view, 7.65
- V$BACKUP_SPFILE_SUMMARY view, 7.66
- V$BACKUP_SYNC_IO view, 7.67
- V$BGPROCESS view, 7.68
- V$BH view, 7.69
- V$BLOCK_CHANGE_TRACKING view, 7.70
- V$BLOCKING_QUIESCE view, 7.71
- V$BUFFER_POOL view, 7.72
- V$BUFFER_POOL_STATISTICS view, 7.73
- V$BUFFERED_PUBLISHERS view, 7.74
- V$BUFFERED_QUEUES view, 7.75
- V$BUFFERED_SUBSCRIBERS view, 7.76
- V$CACHE view, 7.77
- V$CACHE_LOCK view, 7.78
- V$CACHE_TRANSFER view, 7.79
- V$CIRCUIT view, 7.80
- V$CLASS_CACHE_TRANSFER view, 7.81
- V$CLIENT_STATS view, 7.82
- V$CLUSTER_INTERCONNECTS view, 7.83
- V$CONFIGURED_INTERCONNECTS view, 7.84
- V$CONTEXT view, 7.85
- V$CONTROLFILE view, 7.86
- V$CONTROLFILE_RECORD_SECTION view, 7.87
- V$COPY_CORRUPTION view, 7.88
- V$CORRUPT_XID_LIST view, 7.89
- V$CPOOL_CC_INFO view, 7.90
- V$CPOOL_CC_STATS view, 7.91
- V$CPOOL_CONN_INFO view, 7.92
- V$CPOOL_STATS view, 7.93
- V$CR_BLOCK_SERVER view, 7.94
- V$CURRENT_BLOCK_SERVER view, 7.95
- V$DATABASE view, 7.96
- V$DATABASE_BLOCK_CORRUPTION view, 7.97
- V$DATABASE_INCARNATION view, 7.98
- V$DATAFILE view, 7.99
- V$DATAFILE_COPY view, 7.100
- V$DATAFILE_HEADER view, 7.101
- V$DATAGUARD_CONFIG view, 7.102
- V$DATAGUARD_STATS view, 7.103
- V$DATAGUARD_STATUS view, 7.104
- V$DB_CACHE_ADVICE view, 7.105
- V$DB_OBJECT_CACHE view, 7.106
- V$DB_PIPES view, 7.107
- V$DB_TRANSPORTABLE_PLATFORM view, 7.108
- V$DBFILE view, 7.109
- V$DBLINK view, 7.110
- V$DELETED_OBJECT view, 7.111
- V$DISPATCHER view, 7.112
- V$DISPATCHER_CONFIG view, 7.113
- V$DISPATCHER_RATE view, 7.114
- V$DNFS_CHANNELS view, 7.115
- V$DNFS_FILES view, 7.116
- V$DNFS_SERVERS view, 7.117
- V$DNFS_STATS view, 7.118
- V$DYNAMIC_REMASTER_STATS view, 7.119
- V$EMON view, 7.120
- V$ENABLEDPRIVS view, 7.121
- V$ENCRYPTED_TABLESPACES view, 7.122
- V$ENCRYPTION_WALLET view, 7.123
- V$ENQUEUE_LOCK view, 7.124
- V$ENQUEUE_STAT view, 7.125
- V$ENQUEUE_STATISTICS view, 7.126
- V$EVENT_HISTOGRAM view, 7.127
- V$EVENT_NAME view, 7.128
- V$EVENTMETRIC view, 7.129
- V$EXECUTION view, 7.130
- V$FALSE_PING view, 7.131
- V$FAST_START_SERVERS view, 7.132
- V$FAST_START_TRANSACTIONS view, 7.133
- V$FILE_CACHE_TRANSFER view, 7.134
- V$FILE_HISTOGRAM view, 7.135
- V$FILEMETRIC view, 7.136
- V$FILEMETRIC_HISTORY view, 7.137
- V$FILESPACE_USAGE view, 7.138
- V$FILESTAT view, 7.139
- V$FIXED_TABLE view, 7.140
- V$FIXED_VIEW_DEFINITION view, 7.141
- V$FLASHBACK_DATABASE_LOG view, 7.142
- V$FLASHBACK_DATABASE_LOGFILE view, 7.143
- V$FLASHBACK_DATABASE_STAT view, 7.144
- V$FLASHBACK_TXN_GRAPH view, 7.145
- V$FLASHBACK_TXN_MODS view, 7.146
- V$FOREIGN_ARCHIVED_LOG view, 7.147
- V$FS_FAILOVER_STATS view, 7.148
- V$GC_ELEMENT view, 7.149
- V$GC_ELEMENTS_WITH_COLLISIONS view, 7.150
- V$GCSHVMASTER_INFO view, 7.151
- V$GCSPFMASTER_INFO view, 7.152
- V$GES_BLOCKING_ENQUEUE view, 7.153
- V$GES_CONVERT_LOCAL view, 7.154
- V$GES_CONVERT_REMOTE view, 7.155
- V$GES_ENQUEUE view, 7.156
- V$GES_LATCH view, 7.157
- V$GES_RESOURCE view, 7.158
- V$GES_STATISTICS view, 7.159
- V$GLOBAL_BLOCKED_LOCKS view, 7.160
- V$GLOBAL_TRANSACTION view, 7.161
- V$HM_CHECK view, 7.162
- V$HM_CHECK_PARAM view, 7.163
- V$HM_FINDING view, 7.164
- V$HM_INFO view, 7.165
- V$HM_RECOMMENDATION view, 7.166
- V$HM_RUN view, 7.167
- V$HS_AGENT view, 7.168
- V$HS_PARAMETER view, 7.169
- V$HS_SESSION view, 7.170
- V$HVMASTER_INFO view, 7.171
- V$INDEXED_FIXED_COLUMN view, 8.1
- V$INSTANCE view, 8.2
- V$INSTANCE_CACHE_TRANSFER view, 8.3
- V$INSTANCE_RECOVERY view, 8.4
- V$IO_CALIBRATION_STATUS view, 8.5
- V$IOFUNCMETRIC view, 8.6
- V$IOFUNCMETRIC_HISTORY view, 8.7
- V$IOSTAT_CONSUMER_GROUP view, 8.8
- V$IOSTAT_FILE view, 8.9
- V$IOSTAT_FUNCTION view, 8.10
- V$IOSTAT_FUNCTION_DETAIL view, 8.11
- V$IOSTAT_NETWORK view, 8.12
- V$JAVA_LIBRARY_CACHE_MEMORY view, 8.13
- V$JAVA_POOL_ADVICE view, 8.14
- V$LATCH view, 8.15
- V$LATCH_CHILDREN view, 8.16
- V$LATCH_MISSES view, 8.17
- V$LATCH_PARENT view, 8.18
- V$LATCHHOLDER view, 8.19
- V$LATCHNAME view, 8.20
- V$LIBCACHE_LOCKS view, 8.21
- V$LIBRARY_CACHE_MEMORY view, 8.22
- V$LIBRARYCACHE view, 8.23
- V$LICENSE view, 8.24
- V$LOADISTAT view, 8.25
- V$LOADPSTAT view, 8.26
- V$LOCK view, 8.27
- V$LOCK_ACTIVITY view, 8.28
- V$LOCK_TYPE view, 8.29
- V$LOCKED_OBJECT view, 8.30
- V$LOG view, 8.31
- V$LOG_HISTORY view, 8.32
- V$LOGFILE view, 8.33
- V$LOGHIST view, 8.34
- V$LOGMNR_CONTENTS view, 8.35
- V$LOGMNR_DICTIONARY view, 8.36
- V$LOGMNR_DICTIONARY_LOAD view, 8.37
- V$LOGMNR_LATCH view, 8.38
- V$LOGMNR_LOGS view, 8.39
- V$LOGMNR_PARAMETERS view, 8.40
- V$LOGMNR_PROCESS view, 8.41
- V$LOGMNR_SESSION view, 8.42
- V$LOGMNR_STATS view, 8.43
- V$LOGSTDBY view, 8.44
- V$LOGSTDBY_PROCESS view, 8.45
- V$LOGSTDBY_PROGRESS view, 8.46
- V$LOGSTDBY_STATE view, 8.47
- V$LOGSTDBY_STATS view, 8.48
- V$LOGSTDBY_TRANSACTION view, 8.49
- V$MANAGED_STANDBY view, 8.50
- V$MAP_COMP_LIST view, 8.51
- V$MAP_ELEMENT view, 8.52
- V$MAP_EXT_ELEMENT view, 8.53
- V$MAP_FILE view, 8.54
- V$MAP_FILE_EXTENT view, 8.55
- V$MAP_FILE_IO_STACK view, 8.56
- V$MAP_LIBRARY view, 8.57
- V$MAP_SUBELEMENT view, 8.58
- V$MEMORY_CURRENT_RESIZE_OPS view, 8.59
- V$MEMORY_DYNAMIC_COMPONENTS view, 8.60
- V$MEMORY_RESIZE_OPS view, 8.61
- V$MEMORY_TARGET_ADVICE view, 8.62
- V$METRIC view, 8.63
- V$METRIC_HISTORY view, 8.65
- V$METRICGROUP view, 8.64
- V$METRICNAME view, 8.66
- V$MTTR_TARGET_ADVICE view, 8.67
- V$MUTEX_SLEEP view, 8.68
- V$MUTEX_SLEEP_HISTORY view, 8.69
- V$MVREFRESH view, 8.70
- V$MYSTAT view, 8.71
- V$NFS_CLIENTS view, 8.72
- V$NFS_LOCKS view, 8.73
- V$NFS_OPEN_FILES view, 8.74
- V$NLS_PARAMETERS view, 8.75
- V$NLS_VALID_VALUES view, 8.76
- V$OBJECT_DEPENDENCY view, 8.77
- V$OBJECT_PRIVILEGE view, 8.78
- V$OBJECT_USAGE view, 8.79
- V$OBSOLETE_BACKUP_FILES view, 8.80
- V$OBSOLETE_PARAMETER view, 8.81
- V$OFFLINE_RANGE view, 8.82
- V$OPEN_CURSOR view, 8.83
- V$OPTION view, 8.84
- V$OSSTAT view, 8.85
- V$PARALLEL_DEGREE_LIMIT_MTH view, 8.86
- V$PARAMETER view, 8.87
- V$PARAMETER_VALID_VALUES view, 8.88
- V$PARAMETER2 view, 8.89
- V$PERSISTENT_PUBLISHERS view, 8.90
- V$PERSISTENT_QMN_CACHE view, 8.91
- V$PERSISTENT_QUEUES view, 8.92
- V$PERSISTENT_SUBSCRIBERS view, 8.93
- V$PGA_TARGET_ADVICE view, 8.94
- V$PGA_TARGET_ADVICE_HISTOGRAM view, 8.95
- V$PGASTAT view, 8.96
- V$PQ_SESSTAT view, 8.97
- V$PQ_SLAVE view, 8.98
- V$PQ_SYSSTAT view, 8.99
- V$PQ_TQSTAT view, 8.100
- V$PROCESS view, 8.101
- V$PROCESS_MEMORY view, 8.102
- V$PROPAGATION_RECEIVER view, 8.103
- V$PROPAGATION_SENDER view, 8.104
- V$PROXY_ARCHIVEDLOG view, 8.105
- V$PROXY_ARCHIVELOG_DETAILS view, 8.106
- V$PROXY_ARCHIVELOG_SUMMARY view, 8.107
- V$PROXY_COPY_DETAILS view, 8.108
- V$PROXY_COPY_SUMMARY view, 8.109
- V$PROXY_DATAFILE view, 8.110
- V$PWFILE_USERS view, 8.111
- V$PX_INSTANCE_GROUP view, 8.112
- V$PX_PROCESS view, 8.113
- V$PX_PROCESS_SYSSTAT view, 8.114
- V$PX_SESSION view, 8.115
- V$PX_SESSTAT view, 8.116
- V$QMON_COORDINATOR_STATS view, 8.117
- V$QMON_SERVER_STATS view, 8.118
- V$QMON_TASK_STATS view, 8.119
- V$QMON_TASKS view, 8.120
- V$QUEUE view, 8.121
- V$QUEUEING_MTH view, 8.122
- V$RECOVER_FILE view, 8.123
- V$RECOVERY_AREA_USAGE view, 8.124
- V$RECOVERY_FILE_DEST view, 8.125
- V$RECOVERY_FILE_STATUS view, 8.126
- V$RECOVERY_LOG view, 8.127
- V$RECOVERY_PROGRESS view, 8.128
- V$RECOVERY_STATUS view, 8.129
- V$REDO_DEST_RESP_HISTOGRAM view, 8.130
- V$REPLPROP view, 8.131
- V$REPLQUEUE view, 8.132
- V$REQDIST view, 8.133
- V$RESERVED_WORDS view, 8.134
- V$RESOURCE view, 8.135
- V$RESOURCE_LIMIT view, 8.136
- V$RESTORE_POINT view, 8.137
- V$RESULT_CACHE_DEPENDENCY view, 8.138
- V$RESULT_CACHE_MEMORY view, 8.139
- V$RESULT_CACHE_OBJECTS view, 8.140
- V$RESULT_CACHE_STATISTICS view, 8.141
- V$RMAN_BACKUP_JOB_DETAILS view, 8.142
- V$RMAN_BACKUP_SUBJOB_DETAILS view, 8.143
- V$RMAN_BACKUP_TYPE view, 8.144
- V$RMAN_COMPRESSION_ALGORITHM view, 8.145
- V$RMAN_CONFIGURATION view, 8.146
- V$RMAN_ENCRYPTION_ALGORITHMS view, 8.147
- V$RMAN_OUTPUT view, 8.148
- V$RMAN_STATUS view, 8.149
- V$ROLLNAME view, 8.150
- V$ROLLSTAT view, 8.151
- V$ROWCACHE view, 8.152
- V$ROWCACHE_PARENT view, 8.153
- V$ROWCACHE_SUBORDINATE view, 8.154
- V$RSRC_CONS_GROUP_HISTORY view, 8.155
- V$RSRC_CONSUMER_GROUP view, 8.156
- V$RSRC_CONSUMER_GROUP_CPU_MTH view, 8.157
- V$RSRC_PLAN view, 8.158
- V$RSRC_PLAN_CPU_MTH view, 8.159
- V$RSRC_PLAN_HISTORY view, 8.160
- V$RSRC_SESSION_INFO view, 8.161
- V$RSRCMGRMETRIC view, 8.162
- V$RSRCMGRMETRIC_HISTORY view, 8.163
- V$RULE view, 8.164
- V$RULE_SET view, 8.165
- V$RULE_SET_AGGREGATE_STATS view, 8.166
- V$SCHEDULER_RUNNING_JOBS view, 9.1
- V$SECUREFILE_TIMER view, 9.2
- V$SEGMENT_STATISTICS view, 9.3
- V$SEGSTAT view, 9.4
- V$SEGSTAT_NAME view, 9.5
- V$SERV_MOD_ACT_STATS view, 9.6
- V$SERVICE_EVENT view, 9.7
- V$SERVICE_STATS view, 9.8
- V$SERVICE_WAIT_CLASS view, 9.9
- V$SERVICEMETRIC view, 9.10
- V$SERVICEMETRIC_HISTORY view, 9.11
- V$SERVICES view, 9.12
- V$SES_OPTIMIZER_ENV view, 9.13
- V$SESS_IO view, 9.14
- V$SESS_TIME_MODEL view, 9.15
- V$SESSION view, 9.16
- V$SESSION_BLOCKERS view, 9.17
- V$SESSION_CONNECT_INFO view, 9.18
- V$SESSION_CURSOR_CACHE view, 9.19
- V$SESSION_EVENT view, 9.20, C
- V$SESSION_FIX_CONTROL view, 9.21
- V$SESSION_LONGOPS view, 9.22
- V$SESSION_OBJECT_CACHE view, 9.23
- V$SESSION_WAIT view, 9.24, C
- V$SESSION_WAIT_CLASS view, 9.25
- V$SESSION_WAIT_HISTORY view, 9.26
- V$SESSMETRIC view, 9.27
- V$SESSTAT view, 9.28, E, E.1
- V$SGA view, 9.29
- V$SGA_CURRENT_RESIZE_OPS view, 9.30
- V$SGA_DYNAMIC_COMPONENTS view, 9.31
- V$SGA_DYNAMIC_FREE_MEMORY view, 9.32
- V$SGA_RESIZE_OPS view, 9.33
- V$SGA_TARGET_ADVICE view, 9.34
- V$SGAINFO view, 9.35
- V$SGASTAT view, 9.36
- V$SHARED_POOL_ADVICE view, 9.37
- V$SHARED_POOL_RESERVED view, 9.38
- V$SHARED_SERVER view, 9.39
- V$SHARED_SERVER_MONITOR view, 9.40
- V$SORT_SEGMENT view, 9.41
- V$SPPARAMETER view, 9.42
- V$SQL view, 9.43
- V$SQL_BIND_CAPTURE view, 9.44
- V$SQL_BIND_DATA view, 9.45
- V$SQL_BIND_METADATA view, 9.46
- V$SQL_CS_HISTOGRAM view, 9.47
- V$SQL_CS_SELECTIVITY view, 9.48
- V$SQL_CS_STATISTICS view, 9.49
- V$SQL_CURSOR view, 9.50
- V$SQL_JOIN_FILTER view, 9.51
- V$SQL_MONITOR view, 9.52
- V$SQL_OPTIMIZER_ENV view, 9.53
- V$SQL_PLAN view, 9.54
- V$SQL_PLAN_MONITOR view, 9.55
- V$SQL_PLAN_STATISTICS view, 9.56
- V$SQL_PLAN_STATISTICS_ALL view, 9.57
- V$SQL_REDIRECTION view, 9.58
- V$SQL_SHARED_CURSOR view, 9.59
- V$SQL_SHARED_MEMORY view, 9.60
- V$SQL_WORKAREA view, 9.61
- V$SQL_WORKAREA_ACTIVE view, 9.62
- V$SQL_WORKAREA_HISTOGRAM view, 9.63
- V$SQLAREA view, 9.64
- V$SQLAREA_PLAN_HASH view, 9.65
- V$SQLCOMMAND view, 9.66
- V$SQLFN_ARG_METADATA view, 9.67
- V$SQLFN_METADATA view, 9.68
- V$SQLSTATS view, 9.69
- V$SQLSTATS_PLAN_HASH view, 9.70
- V$SQLTEXT view, 9.71
- V$SQLTEXT_WITH_NEWLINES view, 9.72
- V$STANDBY_EVENT_HISTOGRAM view, 9.73
- V$STANDBY_LOG view, 9.74
- V$STATISTICS_LEVEL view, 9.75
- V$STATNAME view, 9.76, E.1
- V$STREAMS_APPLY_COORDINATOR view, 9.77
- V$STREAMS_APPLY_READER view, 9.78
- V$STREAMS_APPLY_SERVER view, 9.79
- V$STREAMS_CAPTURE view, 9.80
- V$STREAMS_MESSAGE_TRACKING view, 9.81
- V$STREAMS_POOL_ADVICE view, 9.82
- V$STREAMS_POOL_STATISTICS view, 9.83
- V$STREAMS_TRANSACTION view, 9.84
- V$SUBCACHE view, 9.85
- V$SUBSCR_REGISTRATION_STATS view, 9.86
- V$SYS_OPTIMIZER_ENV view, 9.87
- V$SYS_TIME_MODEL view, 9.88
- V$SYSAUX_OCCUPANTS view, 9.89
- V$SYSMETRIC view, 9.90
- V$SYSMETRIC_HISTORY view, 9.91
- V$SYSMETRIC_SUMMARY view, 9.92
- V$SYSSTAT view, 9.93, E
- V$SYSTEM_CURSOR_CACHE view, 9.94
- V$SYSTEM_EVENT view, 9.95, C
- V$SYSTEM_FIX_CONTROL view, 9.96
- V$SYSTEM_PARAMETER view, 9.97
- V$SYSTEM_PARAMETER2 view, 9.98
- V$SYSTEM_WAIT_CLASS view, 9.99
- V$TABLESPACE view, 9.100
- V$TEMP_CACHE_TRANSFER view, 9.101
- V$TEMP_EXTENT_MAP view, 9.102
- V$TEMP_EXTENT_POOL view, 9.103
- V$TEMP_SPACE_HEADER view, 9.104
- V$TEMPFILE view, 9.105
- V$TEMPORARY_LOBS view, 9.106
- V$TEMPSEG_USAGE view, 9.107
- V$TEMPSTAT view, 9.108
- V$THREAD view, 9.109
- V$THRESHOLD_TYPES view, 9.110
- V$TIMER view, 9.111
- V$TIMEZONE_NAMES view, 9.112
- V$TOPLEVELCALL view, 9.113
- V$TRANSACTION view, 9.114
- V$TRANSACTION_ENQUEUE view, 9.115
- V$TRANSPORTABLE_PLATFORM view, 9.116
- V$TYPE_SIZE view, 9.117
- V$UNDOSTAT view, 9.118
- V$UNUSABLE_BACKUPFILE_DETAILS view, 9.119
- V$VERSION view, 9.120
- V$VPD_POLICY view, 9.121
- V$WAIT_CHAINS view, 9.122
- V$WAITCLASSMETRIC view, 9.123
- V$WAITCLASSMETRIC_HISTORY view, 9.124
- V$WAITSTAT view, 9.125
- V$WALLET view, 9.126
- V$WORKLOAD_REPLAY_THREAD view, 9.127
- V$XML_AUDIT_TRAIL view, 9.128
- V$XSTREAM_CAPTURE view, 9.129
- V$XSTREAM_MESSAGE_TRACKING view, 9.130
- V$XSTREAM_OUTBOUND_SERVER view, 9.131
- V$XSTREAM_TRANSACTION view, 9.132
- views
-
- data dictionary views, 2
W
- wait events
-
- alter system set dispatcher, C.3.1
- batched allocate scn lock request, C.3.2
- BFILE check if exists, C.3.3
- BFILE check if open, C.3.4
- BFILE closure, C.3.5
- BFILE get length, C.3.6
- BFILE get name object, C.3.7
- BFILE get path object, C.3.8
- BFILE internal seek, C.3.9
- BFILE open, C.3.10
- BFILE read, C.3.11
- broadcast mesg queue transition, C.3.12
- broadcast mesg recovery queue transition, C.3.13
- buffer busy waits, C.3.14
- buffer deadlock, C.3.15
- buffer latch, C.3.16
- buffer read retry, C.3.17
- checkpoint completed, C.3.18
- cleanup of aborted processes, C.3.19
- controlfile parallel write, C.3.20
- controlfile sequential read, C.3.21
- controlfile single write, C.3.22
- cursor: mutex S, C.3.23
- cursor: mutex X, C.3.24
- cursor: pin S, C.3.25
- cursor: pin S wait on X, C.3.26
- cursor: pin X, C.3.27
- Data Guard Broker: single instance, C.3.30
- Data Guard: process cleanup, C.3.28
- Data Guard: process exit, C.3.29
- db file parallel read, C.3.31
- db file parallel write, C.3.32
- db file scattered read, C.3.33
- db file sequential read, C.3.34
- db file single write, C.3.35
- DFS db file lock, C.3.36
- DFS lock handle, C.3.37
- direct path read, C.3.38
- direct path sync, C.3.39
- direct path write, C.3.40
- Disk file operations I/O, C.3.41
- dispatcher shutdown, C.3.42
- dispatcher timer, C.3.43
- duplicate cluster key, C.3.44
- enq: OW - initialization, C.3.45
- enq: OW - termination, C.3.46
- enqueue, C.3.47
- flashback buf free by RVWR, C.3.48
- flashback logfile sync, C.3.49
- free buffer waits, C.3.50
- free global transaction table entry, C.3.51
- free process state object, C.3.52
- gc recovery quiesce, C.3.53
- GCS lock open S, C.3.54
- GCS lock open X, C.3.55
- gcs remastering wait for drop pkey, C.3.56
- global cache busy, C.3.57
- global cache freelist, C.3.59
- global cache lock cleanup, C.3.58
- inactive session, C.3.60
- inactive transaction branch, C.3.61
- index block split, C.3.62
- instance state change, C.3.63
- io done, C.3.64
- kcl bg acks, C.3.65
- ksxr wait for mount shared, C.3.66
- ktm: instance recovery, C.3.67
- latch activity, C.3.68
- latch free, C.3.69
- library cache load lock, C.3.70
- library cache lock, C.3.71
- library cache pin, C.3.72
- LMON global data update, C.3.74
- lock manager wait for remote message, C.3.75
- Log archive I/O, C.3.76
- log buffer space, C.3.77
- log file parallel write, C.3.78
- log file sequential read, C.3.79
- log file single write, C.3.80
- log file switch (archiving needed), C.3.81
- log file switch (checkpoint incomplete), C.3.82
- log file switch (clearing log file), C.3.83
- log file switch (private strand flush incomplete), C.3.84
- log file switch completion, C.3.85
- log file sync, C.3.86
- log switch/archive, C.3.87
- optimizer stats update retry, C.3.88
- parallel recovery change buffer free, C.3.89
- parallel recovery control message reply, C.3.90
- parallel recovery coord send blocked, C.3.91
- parallel recovery coord wait for reply, C.3.92
- parallel recovery coordinator waits for slave cleanup, C.3.93
- parallel recovery read buffer free, C.3.94
- parallel recovery slave next change, C.3.95
- pending global transaction(s), C.3.96
- pipe get, C.3.97
- pipe put, C.3.98
- PL/SQL lock timer, C.3.99
- pmon timer, C.3.100
- prewarm transfer retry, C.3.101
- prior process spawner to be cleaned up, C.3.102
- process startup, C.3.103
- PX dequeue wait, C.3.104
- PX qref latch, C.3.105
- PX server shutdown, C.3.106
- PX signal server, C.3.107
- rdbms ipc message, C.3.108
- rdbms ipc message block, C.3.109
- rdbms ipc reply, C.3.110
- read by other session, C.3.111
- recovery read, C.3.112
- resmgr:become active, C.3.113
- resmgr:cpu quantum, C.3.114
- resmgr:pq queued, C.3.115
- rolling migration: cluster quiesce, C.3.116
- row cache lock, C.3.117
- RVWR wait for flashback copy, C.3.118
- sbtbufinfo, C.3.119
- sbtgetbuf, C.3.120
- sbtmapbuf, C.3.121
- sbtrelbuf, C.3.122
- scginq AST call, C.3.123
- SGA: allocation forcing component growth, C.3.124
- SGA: MMAN sleep for component shrink, C.3.125
- SGA: sga_target resize, C.3.126
- Shared IO Pool Memory, C.3.127
- shared server idle event, C.3.129
- single-task message, C.3.128
- smon timer, C.3.130
- SQL*Net break/reset to client, C.3.131
- SQL*Net break/reset to dblink, C.3.132
- SQL*Net message from client, C.3.133
- SQL*Net message from dblink, C.3.134
- SQL*Net message to client, C.3.135
- SQL*Net message to dblink, C.3.136
- SQL*Net more data from client, C.3.137
- SQL*Net more data from dblink, C.3.138
- SQL*Net more data to client, C.3.139
- SQL*Net more data to dblink, C.3.140
- Streams AQ: waiting for messages in the queue, C.3.141
- switch logfile command, C.3.142
- timer in sksawat, C.3.144
- transaction, C.3.145
- unbound tx, C.3.146
- undo segment extension, C.3.148
- undo segment recovery, C.3.149
- undo segment tx slot, C.3.150
- undo_retention publish retry, C.3.147
- virtual circuit status, C.3.151
- virtual circuit wait, C.3.152
- WCR: replay client notify, C.3.153
- WCR: replay clock, C.3.154
- WCR: replay lock order, C.3.155
- WCR: replay paused, C.3.156
- WCR: Sync context busy, C.3.157
- WMON goes to sleep, C.3.158
- write complete waits, C.3.159
- writes stopped by instance recovery or database suspension, C.3.160
- WM_COMPRESS_BATCH_SIZES view, 2.1.2
- WM_COMPRESSIBLE_TABLES view, 2.1.2
- WM_EVENTS_INFO view, 2.1.2
- WM_INSTALLATION view, 2.1.2
- WM_REPLICATION_INFO view, 2.1.2
- WORKAREA_SIZE_POLICY initialization parameter, 1.265
X
- XML_DB_EVENTS initialization parameter, 1.266
- XS_SESSION_ROLES view, 6.508
