Index
A B C D E F G H I J L M N O P Q R S T U V W
A
- ACTIVE_INSTANCE_COUNT initialization parameter, 1.7
- ALL_ALL_TABLES view, 2.3
- ALL_APPLY view, 2.4
- ALL_APPLY_CONFLICT_COLUMNS view, 2.5
- ALL_APPLY_DML_HANDLERS view, 2.6
- ALL_APPLY_ENQUEUE view, 2.7
- ALL_APPLY_ERROR view, 2.8
- ALL_APPLY_EXECUTE view, 2.9
- ALL_APPLY_KEY_COLUMNS view, 2.10
- ALL_APPLY_PARAMETERS view, 2.11
- ALL_APPLY_PROGRESS view, 2.12
- ALL_APPLY_TABLE_COLUMNS view, 2.13
- ALL_ARGUMENTS view, 2.14
- ALL_ASSOCIATIONS view, 2.15
- ALL_AUDIT_POLICIES view, 2.16
- ALL_AUDIT_POLICY_COLUMNS view, 2.17
- ALL_AW_PS view, 2.18
- ALL_AWS view, 2.19
- ALL_BASE_TABLE_MVIEWS view, 2.20
- ALL_CAPTURE view, 2.21
- ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.22
- ALL_CAPTURE_PARAMETERS view, 2.23
- ALL_CAPTURE_PREPARED_DATABASE view, 2.24
- ALL_CAPTURE_PREPARED_SCHEMAS view, 2.25
- ALL_CAPTURE_PREPARED_TABLES view, 2.26
- ALL_CATALOG view, 2.27
- ALL_CLUSTER_HASH_EXPRESSIONS view, 2.28
- ALL_CLUSTERS view, 2.29
- ALL_COL_COMMENTS view, 2.30
- ALL_COL_PRIVS view, 2.31
- ALL_COL_PRIVS_MADE view, 2.32
- ALL_COL_PRIVS_RECD view, 2.33
- ALL_COLL_TYPES view, 2.34
- ALL_CONS_COLUMNS view, 2.35
- ALL_CONS_OBJ_COLUMNS view, 2.36
- ALL_CONSTRAINTS view, 2.37
- ALL_CONTEXT view, 2.38
- ALL_DB_LINKS view, 2.39
- ALL_DEF_AUDIT_OPTS view, 2.40
- ALL_DEPENDENCIES view, 2.41
- ALL_DEQUEUE_QUEUES view, 2.42
- ALL_DIM_ATTRIBUTES view, 2.43
- ALL_DIM_CHILD_OF view, 2.44
- ALL_DIM_HIERARCHIES view, 2.45
- ALL_DIM_JOIN_KEY view, 2.46
- ALL_DIM_LEVEL_KEY view, 2.47
- ALL_DIM_LEVELS view, 2.48
- ALL_DIMENSIONS view, 2.49
- ALL_DIRECTORIES view, 2.50
- ALL_ENCRYPTED_COLUMNS view, 2.51
- ALL_ERRORS view, 2.52
- ALL_EVALUATION_CONTEXT_TABLES view, 2.53
- ALL_EVALUATION_CONTEXT_VARS view, 2.54
- ALL_EVALUATION_CONTEXTS view, 2.55
- ALL_EXTERNAL_LOCATIONS view, 2.56
- ALL_EXTERNAL_TABLES view, 2.57
- ALL_FILE_GROUP_EXPORT_INFO view, 2.58
- ALL_FILE_GROUP_FILES view, 2.59
- ALL_FILE_GROUP_TABLES view, 2.60
- ALL_FILE_GROUP_TABLESPACES view, 2.61
- ALL_FILE_GROUP_VERSIONS view, 2.62
- ALL_FILE_GROUPS view, 2.63
- ALL_IND_COLUMNS view, 2.64
- ALL_IND_EXPRESSIONS view, 2.65
- ALL_IND_PARTITIONS view, 2.66
- ALL_IND_STATISTICS view, 2.67
- ALL_IND_SUBPARTITIONS view, 2.68
- ALL_INDEXES view, 2.69
- ALL_INDEXTYPE_ARRAYTYPES view, 2.70
- ALL_INDEXTYPE_COMMENTS view, 2.71
- ALL_INDEXTYPE_OPERATORS view, 2.72
- ALL_INDEXTYPES view, 2.73
- ALL_INTERNAL_TRIGGERS view, 2.74
- ALL_JAVA_ARGUMENTS view, 2.75
- ALL_JAVA_CLASSES view, 2.76
- ALL_JAVA_DERIVATIONS view, 2.77
- ALL_JAVA_FIELDS view, 2.78
- ALL_JAVA_IMPLEMENTS view, 2.79
- ALL_JAVA_INNERS view, 2.80
- ALL_JAVA_LAYOUTS view, 2.81
- ALL_JAVA_METHODS view, 2.82
- ALL_JAVA_NCOMPS view, 2.83
- ALL_JAVA_RESOLVERS view, 2.84
- ALL_JAVA_THROWS view, 2.85
- ALL_JOBS view, 2.86
- ALL_JOIN_IND_COLUMNS view, 2.87
- ALL_LIBRARIES view, 2.88
- ALL_LOB_PARTITIONS view, 2.89
- ALL_LOB_SUBPARTITIONS view, 2.90
- ALL_LOB_TEMPLATES view, 2.91
- ALL_LOBS view, 2.92
- ALL_LOG_GROUP_COLUMNS view, 2.93
- ALL_LOG_GROUPS view, 2.94
- ALL_METHOD_PARAMS view, 2.95
- ALL_METHOD_RESULTS view, 2.96
- ALL_MVIEW_AGGREGATES view, 2.97
- ALL_MVIEW_ANALYSIS view, 2.98
- ALL_MVIEW_COMMENTS view, 2.99
- ALL_MVIEW_DETAIL_RELATIONS view, 2.100
- ALL_MVIEW_JOINS view, 2.101
- ALL_MVIEW_KEYS view, 2.102
- ALL_MVIEW_LOGS view, 2.103
- ALL_MVIEW_REFRESH_TIMES view, 2.104
- ALL_MVIEWS view, 2.105
- ALL_NESTED_TABLE_COLS view, 3.1
- ALL_NESTED_TABLES view, 3.2
- ALL_OBJ_COLATTRS view, 3.3
- ALL_OBJECT_TABLES view, 3.4
- ALL_OBJECTS view, 3.5
- ALL_OPANCILLARY view, 3.6
- ALL_OPARGUMENTS view, 3.7
- ALL_OPBINDINGS view, 3.8
- ALL_OPERATOR_COMMENTS view, 3.9
- ALL_OPERATORS view, 3.10
- ALL_OUTLINE_HINTS view, 3.11
- ALL_OUTLINES view, 3.12
- ALL_PART_COL_STATISTICS view, 3.13
- ALL_PART_HISTOGRAMS view, 3.14
- ALL_PART_INDEXES view, 3.15
- ALL_PART_KEY_COLUMNS view, 3.16
- ALL_PART_LOBS view, 3.17
- ALL_PART_TABLES view, 3.18
- ALL_PARTIAL_DROP_TABS view, 3.19
- ALL_PENDING_CONV_TABLES view, 3.20
- ALL_PLSQL_OBJECT_SETTINGS view, 3.21
- ALL_POLICIES view, 3.22
- ALL_POLICY_CONTEXTS view, 3.23
- ALL_POLICY_GROUPS view, 3.24
- ALL_PROCEDURES view, 3.25
- ALL_PROPAGATION view, 3.26
- ALL_PUBLISHED_COLUMNS view, 3.27
- ALL_QUEUE_SUBSCRIBERS view, 3.28
- ALL_QUEUE_TABLES view, 3.29
- ALL_QUEUES view, 3.30
- ALL_REFRESH view, 3.31
- ALL_REFRESH_CHILDREN view, 3.32
- ALL_REFRESH_DEPENDENCIES view, 3.33
- ALL_REFS view, 3.34
- ALL_REGISTERED_MVIEWS view, 3.35
- ALL_REGISTRY_BANNERS view, 3.36
- 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.37
- ALL_RULE_SET_RULES view, 3.38
- ALL_RULE_SETS view, 3.39
- ALL_RULES view, 3.40
- ALL_SCHEDULER_CHAIN_RULES view, 3.41
- ALL_SCHEDULER_CHAIN_STEPS view, 3.42
- ALL_SCHEDULER_CHAINS view, 3.43
- ALL_SCHEDULER_GLOBAL_ATTRIBUTE view, 3.44
- ALL_SCHEDULER_JOB_ARGS view, 3.45
- ALL_SCHEDULER_JOB_CLASSES view, 3.46
- ALL_SCHEDULER_JOB_LOG view, 3.47
- ALL_SCHEDULER_JOB_RUN_DETAILS view, 3.48
- ALL_SCHEDULER_JOBS view, 3.49
- ALL_SCHEDULER_PROGRAM_ARGS view, 3.50
- ALL_SCHEDULER_PROGRAMS 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_SEQUENCES view, 3.61
- ALL_SERVICES view, 3.62
- ALL_SOURCE view, 3.63
- ALL_SOURCE_TABLES view, 3.64
- ALL_SQLJ_TYPE_ATTRS view, 3.65
- ALL_SQLJ_TYPE_METHODS view, 3.66
- ALL_SQLJ_TYPES view, 3.67
- ALL_SQLSET view, 3.68
- ALL_SQLSET_BINDS view, 3.69
- ALL_SQLSET_PLANS view, 3.70
- ALL_SQLSET_REFERENCES view, 3.71
- ALL_SQLSET_STATEMENTS view, 3.72
- ALL_STORED_SETTINGS view, 3.73
- ALL_STREAMS_GLOBAL_RULES view, 3.74
- ALL_STREAMS_MESSAGE_CONSUMERS view, 3.75
- ALL_STREAMS_MESSAGE_RULES view, 3.76
- ALL_STREAMS_NEWLY_SUPPORTED view, 3.77
- ALL_STREAMS_RULES view, 3.78
- ALL_STREAMS_SCHEMA_RULES view, 3.79
- ALL_STREAMS_TABLE_RULES view, 3.80
- ALL_STREAMS_TRANSFORM_FUNCTION view, 3.81
- ALL_STREAMS_UNSUPPORTED view, 3.82
- ALL_SUBPART_COL_STATISTICS view, 3.83
- ALL_SUBPART_HISTOGRAMS view, 3.84
- ALL_SUBPART_KEY_COLUMNS view, 3.85
- ALL_SUBPARTITION_TEMPLATES view, 3.86
- ALL_SUBSCRIBED_COLUMNS view, 3.87
- ALL_SUBSCRIBED_TABLES view, 3.88
- ALL_SUBSCRIPTIONS view, 3.89
- ALL_SUMDELTA view, 3.90
- ALL_SYNONYMS view, 3.91
- ALL_TAB_COL_STATISTICS view, 3.92
- ALL_TAB_COLS view, 3.93
- ALL_TAB_COLUMNS view, 3.94
- ALL_TAB_COMMENTS view, 3.95
- ALL_TAB_HISTOGRAMS view, 3.96
- ALL_TAB_MODIFICATIONS view, 3.97
- ALL_TAB_PARTITIONS view, 3.98
- ALL_TAB_PRIVS view, 3.99
- ALL_TAB_PRIVS_MADE view, 3.100
- ALL_TAB_PRIVS_RECD view, 3.101
- ALL_TAB_STATISTICS view, 3.102
- ALL_TAB_STATS_HISTORY view, 3.103
- ALL_TAB_SUBPARTITIONS view, 3.104
- ALL_TABLES view, 3.105
- ALL_TRIGGER_COLS view, 3.106
- ALL_TRIGGERS view, 3.107
- ALL_TYPE_ATTRS view, 3.108
- ALL_TYPE_METHODS view, 3.109
- ALL_TYPE_VERSIONS view, 3.110
- ALL_TYPES view, 3.111
- ALL_UNUSED_COL_TABS view, 3.112
- ALL_UPDATABLE_COLUMNS view, 3.113
- ALL_USERS view, 3.114
- ALL_USTATS view, 3.115
- ALL_VARRAYS view, 3.116
- ALL_VERSION_HVIEW view, 2.1.2
- ALL_VIEWS view, 3.117
- ALL_WARNING_SETTINGS view, 3.118
- 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_SCHEMAS view, 3.119
- ALL_XML_TAB_COLS view, 3.120
- ALL_XML_TABLES view, 3.121
- ALL_XML_VIEW_COLS view, 3.122
- ALL_XML_VIEWS view, 3.123
- ALLOCATE EXTENT clause
-
- of ALTER TABLE
-
- instance number, 1.84
- allocation
-
- PCM locks, 1.74
- ALTER DATABASE statement
-
- ADD LOGFILE, 1.213
- ENABLE THREAD, 1.213
- THREAD, 1.213
- ALTER TABLE statement
-
- allocating extents, 1.84
- ANALYZE statement, 2.69, 3.1, 3.93, 3.94, 3.105, 4.207, 5.1, 5.145, 5.146, 5.155, 5.370, 5.459, 5.460, 5.471
- AQ_TM_PROCESSES initialization parameter, 1.8
- ARCHIVE LOG START statement
-
- automatic archiving, 1.99
- ARCHIVE_LAG_TARGET initialization parameter, 1.9
- archived redo logs
-
- destination file, 1.99
- storage device, 1.99, 1.103
- ARCHIVELOG mode, 1.99
-
- archiving destination, 1.99, 1.103
- ASM_DISKGROUPS initialization parameter, 1.10
- ASM_DISKSTRING initialization parameter, 1.11
- ASM_POWER_LIMIT initialization parameter, 1.12
- AUDIT_ACTIONS table, 3.124
- AUDIT_FILE_DEST initialization parameter, 1.13
- AUDIT_SYS_OPERATIONS initialization parameter, 1.14
- AUDIT_SYSLOG_LEVEL initialization parameter, 1.15
- AUDIT_TRAIL initialization parameter, 1.16
- authenticating remote clients, 1.179
- authenticating users, 1.147
B
- BACKGROUND_CORE_DUMP initialization parameter, 1.17
- BACKGROUND_DUMP_DEST initialization parameter, 1.18
- BACKUP_TAPE_IO_SLAVES initialization parameter, 1.19
- BITMAP_MERGE_AREA_SIZE initialization parameter, 1.20
- BLANK_TRIMMING initialization parameter, 1.21
- blocks
-
- PCM lock, 1.74
- redo log, 1.109
- size, 1.37, 1.41, 1.51, A.2
C
- cache
-
- dictionary, 7.61, 7.62, 7.63, 7.65, 7.66, 7.67, 7.68
- statistics, 1.109
- CAT synonym for USER_CATALOG view, 3.126
- CATALOG view, 3.125
- CATALOG.SQL script, B.1
-
- creating V$ views, 6.1
- CATAUDIT.SQL script
-
- audit trail records created by, 5.279
- audit trails for connections and disconnections, 5.282
- auditing characteristics described by, 5.372
- 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
- CATNOQUE.SQL script, B.3
- CATNORMN.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
- CATRMAN.SQL script, B.2
- CATUPGRD.SQL script, B.4
- CHAINED_ROWS table, 3.127
- CHANGE_PROPAGATION_SETS view, 3.128
- CHANGE_PROPAGATIONS view, 3.129
- CHANGE_SETS view, 3.130
- CHANGE_SOURCES view, 3.131
- CHANGE_TABLES view, 3.132
- characters
-
- numeric group separators, 1.129
- checkpoints
-
- checkpoint interval, 1.109
- statistics, 1.109
- CIRCUITS initialization parameter, 1.22
- CLU synonym for USER_CLUSTERS view, 3.133
- CLUSTER_DATABASE initialization parameter, 1.23
- CLUSTER_DATABASE_INSTANCES initialization parameter, 1.24
- CLUSTER_INTERCONNECTS initialization parameter, 1.25
- COL view, 3.134
- COLS synonym for USER_TAB_COLUMNS view, 3.135
- COMMIT_POINT_STRENGTH initialization parameter, 1.26
- COMMIT_WRITE initialization parameter, 1.27
- COMPATIBLE initialization parameter, 1.28
- contention
-
- block-level, 7.180
- control files
-
- names, 1.30
- specifying, 1.30
- CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.29
- CONTROL_FILES initialization parameter, 1.30
- CORE_DUMP_DEST initialization parameter, 1.31
- cost-based optimization, 1.145
-
- favoring IN-list iterators, 1.143
- CPU_COUNT initialization parameter, 1.32
- CREATE TABLE statement
-
- FREELIST GROUPS clause, 1.84
- CREATE_BITMAP_AREA_SIZE initialization parameter, 1.33
- CREATE_STORED_OUTLINES initialization parameter, 1.34
- creating
-
- a database
-
- setting block size, 1.37, 1.41, 1.51
- currency, 1.120, 1.121
-
- international currency symbol, 1.125
- CURSOR_SHARING initialization parameter, 1.35
- CURSOR_SPACE_FOR_TIME initialization parameter, 1.36
- cursors
-
- OPEN_CURSORS initialization parameter, 1.138
- shared pool, 1.196
D
- data blocks
-
- reading multiple, 1.47
- size of, 1.37, 1.41, 1.51
- data dictionary, 2
-
- cache, 7.61, 7.62, 7.63, 7.65, 7.66, 7.67, 7.68
- datafiles, 1.74
- scripts, B.2
- SQL scripts, B.1
- tables, 2.1
- views, 1.74
-
- overview, 2.1
- user views, 2
- database writer process (DBWR)
-
- checkpoint, 1.109
- DATABASE_PROPERTIES view, 3.136
- databases
-
- block size, A.2
- database limits, A
- default language, 1.126
- resource limits, 1.182, 1.183
- datafiles
-
- mapping blocks to PCM locks, 1.74
- maximum number, 1.49
- parameter, 1.49
- unspecified for PCM locks, 1.74
- dates
-
- language used for, 1.123, 1.132, 1.133
- setting SYSDATE, 1.73
- TO_CHAR function, 1.122
- TO_DATE function, 1.122
- DB_BLOCK_BUFFERS initialization parameter, 1.38
- DB_BLOCK_CHECKING initialization parameter, 1.39
- DB_BLOCK_CHECKSUM initialization parameter, 1.40
- DB_BLOCK_SIZE initialization parameter, 1.41
- DB_CACHE_ADVICE initialization parameter, 1.42
- DB_CACHE_SIZE initialization parameter, 1.43
- DB_CREATE_FILE_DEST initialization parameter, 1.44
- DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.45
- DB_DOMAIN initialization parameter, 1.46
- DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.47
- DB_FILE_NAME_CONVERT initialization parameter, 1.48
- DB_FILES initialization parameter, 1.49
- DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.50
- DB_KEEP_CACHE_SIZE initialization parameter, 1.51
- DB_NAME initialization parameter, 1.52
- DB_nK_CACHE_SIZE initialization parameter, 1.37
- DB_RECOVERY_FILE_DEST initialization parameter, 1.53
- DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.54
- DB_RECYCLE_CACHE_SIZE initialization parameter, 1.55
- DB_UNIQUE_NAME initialization parameter, 1.56
- DB_WRITER_PROCESSES initialization parameter, 1.57
- DBA_2PC_NEIGHBORS view, 4.1
- DBA_2PC_PENDING view, 4.2
- DBA_ADVISOR_ACTIONS view, 4.3
- DBA_ADVISOR_COMMANDS view, 4.4
- DBA_ADVISOR_DEF_PARAMETERS view, 4.5
- DBA_ADVISOR_DEFINITIONS view, 4.6
- DBA_ADVISOR_FINDINGS view, 4.7
- DBA_ADVISOR_JOURNAL view, 4.8
- DBA_ADVISOR_LOG view, 4.9
- DBA_ADVISOR_OBJECT_TYPES view, 4.10
- DBA_ADVISOR_OBJECTS view, 4.11
- DBA_ADVISOR_PARAMETERS view, 4.12
- DBA_ADVISOR_RATIONALE view, 4.13
- DBA_ADVISOR_RECOMMENDATIONS view, 4.14
- DBA_ADVISOR_SQLA_REC_SUM view, 4.15
- DBA_ADVISOR_SQLA_WK_MAP view, 4.16
- DBA_ADVISOR_SQLA_WK_STMTS view, 4.17
- DBA_ADVISOR_SQLW_JOURNAL view, 4.18
- DBA_ADVISOR_SQLW_PARAMETERS view, 4.19
- DBA_ADVISOR_SQLW_STMTS view, 4.20
- DBA_ADVISOR_SQLW_SUM view, 4.21
- DBA_ADVISOR_SQLW_TABLES view, 4.22
- DBA_ADVISOR_SQLW_TEMPLATES view, 4.23
- DBA_ADVISOR_TASKS view, 4.24
- DBA_ADVISOR_TEMPLATES view, 4.25
- DBA_ADVISOR_USAGE view, 4.26
- DBA_ALERT_HISTORY view, 4.27
- DBA_ALL_TABLES view, 4.28
- DBA_APPLICATION_ROLES view, 4.29
- DBA_APPLY view, 4.30
- DBA_APPLY_CONFLICT_COLUMNS view, 4.31
- DBA_APPLY_DML_HANDLERS view, 4.32
- DBA_APPLY_ENQUEUE view, 4.33
- DBA_APPLY_ERROR view, 4.34
- DBA_APPLY_EXECUTE view, 4.35
- DBA_APPLY_INSTANTIATED_GLOBAL view, 4.36
- DBA_APPLY_INSTANTIATED_OBJECTS view, 4.37
- DBA_APPLY_INSTANTIATED_SCHEMAS view, 4.38
- DBA_APPLY_KEY_COLUMNS view, 4.39
- DBA_APPLY_OBJECT_DEPENDENCIES view, 4.40
- DBA_APPLY_PARAMETERS view, 4.41
- DBA_APPLY_PROGRESS view, 4.42
- DBA_APPLY_SPILL_TXN view, 4.43
- DBA_APPLY_TABLE_COLUMNS view, 4.44
- DBA_APPLY_VALUE_DEPENDENCIES view, 4.45
- DBA_AQ_AGENT_PRIVS view, 4.46
- DBA_AQ_AGENTS view, 4.47
- DBA_ASSOCIATIONS view, 4.48
- DBA_ATTRIBUTE_TRANSFORMATIONS view, 4.49
- DBA_AUDIT_EXISTS view, 4.50
- DBA_AUDIT_OBJECT view, 4.51
- DBA_AUDIT_POLICIES view, 4.52
- DBA_AUDIT_POLICY_COLUMNS view, 4.53
- DBA_AUDIT_SESSION view, 4.54
- DBA_AUDIT_STATEMENT view, 4.55
- DBA_AUDIT_TRAIL view, 4.56
- DBA_AUTO_SEGADV_CTL view, 4.57
- DBA_AUTO_SEGADV_SUMMARY view, 4.58
- DBA_AW_PS view, 4.59
- DBA_AWS view, 4.60
- DBA_BASE_TABLE_MVIEWS view, 4.61
- DBA_BLOCKERS view, 4.62
- DBA_CAPTURE view, 4.63
- DBA_CAPTURE_EXTRA_ATTRIBUTES view, 4.64
- DBA_CAPTURE_PARAMETERS view, 4.65
- DBA_CAPTURE_PREPARED_DATABASE view, 4.66
- DBA_CAPTURE_PREPARED_SCHEMAS view, 4.67
- DBA_CAPTURE_PREPARED_TABLES view, 4.68
- DBA_CATALOG view, 4.69
- DBA_CHANGE_NOTIFICATION_REGS view, 4.70
- DBA_CLU_COLUMNS view, 4.71
- DBA_CLUSTER_HASH_EXPRESSIONS view, 4.72
- DBA_CLUSTERS view, 4.73
- DBA_COL_COMMENTS view, 4.74
- DBA_COL_PRIVS view, 4.75
- DBA_COLL_TYPES view, 4.76
- DBA_COMMON_AUDIT_TRAIL view, 4.77
- DBA_CONNECT_ROLE_GRANTEES view, 4.78
- DBA_CONS_OBJ_COLUMNS view, 4.79
- DBA_CONSTRAINTS view, 4.80
- DBA_CONTEXT view, 4.81
- DBA_CPU_USAGE_STATISTICS view, 4.82
- DBA_DATA_FILES view, 4.83
- DBA_DATAPUMP_JOBS view, 4.84
- DBA_DATAPUMP_SESSIONS view, 4.85
- DBA_DB_LINKS view, 4.86
- DBA_DDL_LOCKS view, 4.87
- DBA_DEPENDENCIES view, 4.88
- DBA_DIM_ATTRIBUTES view, 4.89
- DBA_DIM_CHILD_OF view, 4.90
- DBA_DIM_HIERARCHIES view, 4.91
- DBA_DIM_JOIN_KEY view, 4.92
- DBA_DIM_LEVEL_KEY view, 4.93
- DBA_DIM_LEVELS view, 4.94
- DBA_DIMENSIONS view, 4.95
- DBA_DIRECTORIES view, 4.96
- DBA_DML_LOCKS view, 4.97
- DBA_DMT_FREE_SPACE view, 4.98
- DBA_DMT_USED_EXTENTS view, 4.99
- DBA_ENABLED_AGGREGATIONS view, 4.100
- DBA_ENABLED_TRACES view, 4.101
- DBA_ENCRYPTED_COLUMNS view, 4.102
- DBA_EPG_DAD_AUTHORIZATION view, 4.103
- DBA_ERRORS view, 4.104
- DBA_EVALUATION_CONTEXT_TABLES view, 4.105
- DBA_EVALUATION_CONTEXT_VARS view, 4.106
- DBA_EVALUATION_CONTEXTS view, 4.107
- DBA_EXP_FILES view, 4.108
- DBA_EXP_OBJECTS view, 4.109
- DBA_EXP_VERSION view, 4.110
- DBA_EXTENTS view, 4.111
- DBA_EXTERNAL_LOCATIONS view, 4.112
- DBA_EXTERNAL_TABLES view, 4.113
- DBA_FEATURE_USAGE_STATISTICS view, 4.114
- DBA_FGA_AUDIT_TRAIL view, 4.115
- DBA_FILE_GROUP_EXPORT_INFO view, 4.116
- DBA_FILE_GROUP_FILES view, 4.117
- DBA_FILE_GROUP_TABLES view, 4.118
- DBA_FILE_GROUP_TABLESPACES view, 4.119
- DBA_FILE_GROUP_VERSIONS view, 4.120
- DBA_FILE_GROUPS view, 4.121
- DBA_FREE_SPACE view, 4.122
- DBA_FREE_SPACE_COALESCED view, 4.123
- DBA_HIGH_WATER_MARK_STATISTICS view, 4.124
- DBA_HIST_ACTIVE_SESS_HISTORY view, 4.125
- DBA_HIST_BASELINE view, 4.126
- DBA_HIST_BG_EVENT_SUMMARY view, 4.127
- DBA_HIST_BUFFER_POOL_STAT view, 4.128
- DBA_HIST_BUFFERED_QUEUES view, 4.129
- DBA_HIST_BUFFERED_SUBSCRIBERS view, 4.130
- DBA_HIST_COMP_IOSTAT view, 4.131
- DBA_HIST_CR_BLOCK_SERVER view, 4.132
- DBA_HIST_CURRENT_BLOCK_SERVER view, 4.133
- DBA_HIST_DATABASE_INSTANCE view, 4.134
- DBA_HIST_DATAFILE view, 4.135
- DBA_HIST_DB_CACHE_ADVICE view, 4.136
- DBA_HIST_DLM_MISC view, 4.137
- DBA_HIST_ENQUEUE_STAT view, 4.138
- DBA_HIST_EVENT_NAME view, 4.139
- DBA_HIST_FILEMETRIC_HISTORY view, 4.140
- DBA_HIST_FILESTATXS view, 4.141
- DBA_HIST_INST_CACHE_TRANSFER view, 4.142
- DBA_HIST_INSTANCE_RECOVERY view, 4.143
- DBA_HIST_JAVA_POOL_ADVICE view, 4.144
- DBA_HIST_LATCH view, 4.145
- DBA_HIST_LATCH_CHILDREN view, 4.146
- DBA_HIST_LATCH_MISSES_SUMMARY view, 4.147
- DBA_HIST_LATCH_NAME view, 4.148
- DBA_HIST_LATCH_PARENT view, 4.149
- DBA_HIST_LIBRARYCACHE view, 4.150
- DBA_HIST_LOG view, 4.151
- DBA_HIST_METRIC_NAME view, 4.152
- DBA_HIST_MTTR_TARGET_ADVICE view, 4.153
- DBA_HIST_OPTIMIZER_ENV view, 4.154
- DBA_HIST_OSSTAT view, 4.155
- DBA_HIST_OSSTAT_NAME view, 4.156
- DBA_HIST_PARAMETER view, 4.157
- DBA_HIST_PARAMETER_NAME view, 4.158
- DBA_HIST_PGA_TARGET_ADVICE view, 4.159
- DBA_HIST_PGASTAT view, 4.160
- DBA_HIST_PROCESS_MEM_SUMMARY view, 4.161
- DBA_HIST_RESOURCE_LIMIT view, 4.162
- DBA_HIST_ROWCACHE_SUMMARY view, 4.163
- DBA_HIST_RULE_SET view, 4.164
- DBA_HIST_SEG_STAT view, 4.165
- DBA_HIST_SEG_STAT_OBJ view, 4.166
- DBA_HIST_SERVICE_NAME view, 4.167
- DBA_HIST_SERVICE_STAT view, 4.168
- DBA_HIST_SERVICE_WAIT_CLASS view, 4.169
- DBA_HIST_SESS_TIME_STATS view, 4.170
- DBA_HIST_SESSMETRIC_HISTORY view, 4.171
- DBA_HIST_SGA view, 4.172
- DBA_HIST_SGA_TARGET_ADVICE view, 4.173
- DBA_HIST_SGASTAT view, 4.174
- DBA_HIST_SHARED_POOL_ADVICE view, 4.175
- DBA_HIST_SNAP_ERROR view, 4.176
- DBA_HIST_SNAPSHOT view, 4.177
- DBA_HIST_SQL_BIND_METADATA view, 4.178
- DBA_HIST_SQL_PLAN view, 4.179
- DBA_HIST_SQL_SUMMARY view, 4.180
- DBA_HIST_SQL_WORKAREA_HSTGRM view, 4.181
- DBA_HIST_SQLBIND view, 4.182
- DBA_HIST_SQLSTAT view, 4.183
- DBA_HIST_SQLTEXT view, 4.184
- DBA_HIST_STAT_NAME view, 4.185
- DBA_HIST_STREAMS_APPLY_SUM view, 4.186
- DBA_HIST_STREAMS_CAPTURE view, 4.187
- DBA_HIST_STREAMS_POOL_ADVICE view, 4.188
- DBA_HIST_SYS_TIME_MODEL view, 4.189
- DBA_HIST_SYSMETRIC_HISTORY view, 4.190
- DBA_HIST_SYSMETRIC_SUMMARY view, 4.191
- DBA_HIST_SYSSTAT view, 4.192
- DBA_HIST_SYSTEM_EVENT view, 4.193
- DBA_HIST_TABLESPACE_STAT view, 4.194
- DBA_HIST_TBSPC_SPACE_USAGE view, 4.195
- DBA_HIST_TEMPFILE view, 4.196
- DBA_HIST_TEMPSTATXS view, 4.197
- DBA_HIST_THREAD view, 4.198
- DBA_HIST_UNDOSTAT view, 4.199
- DBA_HIST_WAITCLASSMET_HISTORY view, 4.200
- DBA_HIST_WAITSTAT view, 4.201
- DBA_HIST_WR_CONTROL view, 4.202
- DBA_IND_COLUMNS view, 4.203
- DBA_IND_EXPRESSIONS view, 4.204
- DBA_IND_PARTITIONS view, 4.205
- DBA_IND_STATISTICS view, 4.206
- DBA_IND_SUBPARTITIONS view, 4.207
- DBA_INDEXES view, 4.208
-
- collecting statistics for, 4.207
- DBA_INDEXTYPE_ARRAYTYPES view, 4.209
- DBA_INDEXTYPE_COMMENTS view, 4.210
- DBA_INDEXTYPE_OPERATORS view, 4.211
- DBA_INDEXTYPES view, 4.212
- DBA_INTERNAL_TRIGGERS view, 4.213
- DBA_JAVA_ARGUMENTS view, 4.214
- DBA_JAVA_CLASSES view, 4.215
- DBA_JAVA_DERIVATIONS view, 4.216
- DBA_JAVA_FIELDS view, 4.217
- DBA_JAVA_IMPLEMENTS view, 4.218
- DBA_JAVA_INNERS view, 4.219
- DBA_JAVA_LAYOUTS view, 4.220
- DBA_JAVA_METHODS view, 4.221
- DBA_JAVA_NCOMPS view, 4.222
- DBA_JAVA_POLICY view, 4.223
- DBA_JAVA_RESOLVERS view, 4.224
- DBA_JAVA_THROWS view, 4.225
- DBA_JOBS view, 4.226
- DBA_JOBS_RUNNING view, 4.227
- DBA_JOIN_IND_COLUMNS view, 4.228
- DBA_KGLLOCK view, 4.229
- DBA_LIBRARIES view, 4.230
- DBA_LMT_FREE_SPACE view, 4.231
- DBA_LMT_USED_EXTENTS view, 4.232
- DBA_LOB_PARTITIONS view, 4.233
- DBA_LOB_SUBPARTITIONS view, 4.234
- DBA_LOB_TEMPLATES view, 4.235
- DBA_LOBS view, 4.236
- DBA_LOCK view, 4.237
-
- DBA_LOCKS synonym, 4.239
- DBA_LOCK_INTERNAL view, 4.238
- DBA_LOCKS synonym for DBA_LOCK view, 4.239
- DBA_LOG_GROUP_COLUMNS view, 4.240
- DBA_LOG_GROUPS view, 4.241
- DBA_LOGMNR_LOG view, 4.242
- DBA_LOGMNR_PURGED_LOG view, 4.243
- DBA_LOGMNR_SESSION view, 4.244
- DBA_LOGSTDBY_EVENTS view, 4.245
- DBA_LOGSTDBY_HISTORY view, 4.246
- DBA_LOGSTDBY_LOG view, 4.247
- DBA_LOGSTDBY_NOT_UNIQUE view, 4.248
- DBA_LOGSTDBY_PARAMETERS view, 4.249
- DBA_LOGSTDBY_PROGRESS view, 4.250
- DBA_LOGSTDBY_SKIP view, 4.251
- DBA_LOGSTDBY_SKIP_TRANSACTION view, 4.252
- DBA_LOGSTDBY_UNSUPPORTED view, 4.253
- DBA_METHOD_PARAMS view, 4.254
- DBA_METHOD_RESULTS view, 4.255
- DBA_MVIEW_AGGREGATES view, 4.256
- DBA_MVIEW_ANALYSIS view, 4.257
- DBA_MVIEW_COMMENTS view, 4.258
- DBA_MVIEW_DETAIL_RELATIONS view, 4.259
- DBA_MVIEW_JOINS view, 4.260
- DBA_MVIEW_KEYS view, 4.261
- DBA_MVIEW_LOG_FILTER_COLS view, 4.262
- DBA_MVIEW_LOGS view, 4.263
- DBA_MVIEW_REFRESH_TIMES view, 4.264
- DBA_MVIEWS view, 4.265
- DBA_NESTED_TABLE_COLS view, 5.1
- DBA_NESTED_TABLES view, 5.2
- DBA_OBJ_AUDIT_OPTS view, 5.3
- DBA_OBJ_COLATTRS view, 5.4
- DBA_OBJECT_SIZE view, 5.5
- DBA_OBJECT_TABLES view, 5.6
- DBA_OBJECTS view, 5.7
- DBA_OPANCILLARY view, 5.8
- DBA_OPARGUMENTS view, 5.9
- DBA_OPBINDINGS view, 5.10
- DBA_OPERATOR_COMMENTS view, 5.11
- DBA_OPERATORS view, 5.12
- DBA_OPTSTAT_OPERATIONS view, 5.13
- DBA_ORPHAN_KEY_TABLE view, 5.14
- DBA_OUTLINE_HINTS view, 5.15
- DBA_OUTLINES view, 5.16
- DBA_OUTSTANDING_ALERTS view, 5.17
- DBA_PART_COL_STATISTICS view, 5.18
- DBA_PART_HISTOGRAMS view, 5.19
- DBA_PART_INDEXES view, 5.20
- DBA_PART_KEY_COLUMNS view, 5.21
- DBA_PART_LOBS view, 5.22
- DBA_PART_TABLES view, 5.23
- DBA_PARTIAL_DROP_TABS view, 5.24
- DBA_PENDING_CONV_TABLES view, 5.25
- DBA_PENDING_TRANSACTIONS view, 5.26
- DBA_PLSQL_OBJECT_SETTINGS view, 5.27
- DBA_POLICIES view, 5.28
- DBA_POLICY_CONTEXTS view, 5.29
- DBA_POLICY_GROUPS view, 5.30
- DBA_PRIV_AUDIT_OPTS view, 5.31
- DBA_PROCEDURES view, 5.32
- DBA_PROFILES view, 5.33
- DBA_PROPAGATION view, 5.34
- DBA_PROXIES view, 5.35
- DBA_PUBLISHED_COLUMNS view, 5.36
- DBA_QUEUE_SCHEDULES view, 5.37
- DBA_QUEUE_SUBSCRIBERS view, 5.38
- DBA_QUEUE_TABLES view, 5.39
- DBA_QUEUES view, 5.40
- DBA_RCHILD view, 5.41
- DBA_RECOVERABLE_SCRIPT view, 5.42
- DBA_RECOVERABLE_SCRIPT_BLOCKS view, 5.43
- DBA_RECOVERABLE_SCRIPT_ERRORS view, 5.44
- DBA_RECOVERABLE_SCRIPT_PARAMS view, 5.45
- DBA_RECYCLEBIN view, 5.46
- DBA_REDEFINITION_ERRORS view, 5.47
- DBA_REDEFINITION_OBJECTS view, 5.48
- DBA_REFRESH view, 5.49
- DBA_REFRESH_CHILDREN view, 5.50
- DBA_REFS view, 5.51
- DBA_REGISTERED_ARCHIVED_LOG view, 5.52
- DBA_REGISTERED_MVIEW_GROUPS view, 5.53
- DBA_REGISTERED_MVIEWS view, 5.54
- DBA_REGISTRY view, 5.55
- DBA_REGISTRY_HIERARCHY view, 5.56
- DBA_REGISTRY_HISTORY view, 5.57
- DBA_REGISTRY_LOG view, 5.58
- DBA_REPAIR_TABLE view, 5.59
- 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.60
- DBA_RESUMABLE view, 5.61
- DBA_REWRITE_EQUIVALENCES view, 5.62
- DBA_RGROUP view, 5.63
- DBA_ROLE_PRIVS view, 5.64
- DBA_ROLES view, 5.65
- DBA_ROLLBACK_SEGS view, 5.66
- DBA_RSRC_CONSUMER_GROUP_PRIVS view, 5.67
- DBA_RSRC_CONSUMER_GROUPS view, 5.68
- DBA_RSRC_GROUP_MAPPINGS view, 5.69
- DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 5.70
- DBA_RSRC_MAPPING_PRIORITY view, 5.71
- DBA_RSRC_PLAN_DIRECTIVES view, 5.72
- DBA_RSRC_PLANS view, 5.73
- DBA_RULE_SET_RULES view, 5.74
- DBA_RULE_SETS view, 5.75
- DBA_RULES view, 5.76
- DBA_SCHEDULER_CHAIN_RULES view, 5.77
- DBA_SCHEDULER_CHAIN_STEPS view, 5.78
- DBA_SCHEDULER_CHAINS view, 5.79
- DBA_SCHEDULER_GLOBAL_ATTRIBUTE view, 5.80
- DBA_SCHEDULER_JOB_ARGS view, 5.81
- DBA_SCHEDULER_JOB_CLASSES view, 5.82
- DBA_SCHEDULER_JOB_LOG view, 5.83
- DBA_SCHEDULER_JOB_RUN_DETAILS view, 5.84
- DBA_SCHEDULER_JOBS view, 5.85
- DBA_SCHEDULER_PROGRAM_ARGS view, 5.86
- DBA_SCHEDULER_PROGRAMS view, 5.87
- DBA_SCHEDULER_RUNNING_CHAINS view, 5.88
- DBA_SCHEDULER_RUNNING_JOBS view, 5.89
- DBA_SCHEDULER_SCHEDULES view, 5.90
- DBA_SCHEDULER_WINDOW_DETAILS view, 5.91
- DBA_SCHEDULER_WINDOW_GROUPS view, 5.92
- DBA_SCHEDULER_WINDOW_LOG view, 5.93
- DBA_SCHEDULER_WINDOWS view, 5.94
- DBA_SCHEDULER_WINGROUP_MEMBERS view, 5.95
- DBA_SEC_RELEVANT_COLS view, 5.96
- DBA_SEGMENTS view, 5.97
- DBA_SEGMENTS_OLD view, 5.98
- DBA_SEQUENCES view, 5.99
- DBA_SERVER_REGISTRY view, 5.100
- DBA_SERVICES view, 5.101
- DBA_SOURCE view, 5.102
- DBA_SOURCE_TABLES view, 5.103
- DBA_SQL_PROFILES view, 5.104
- DBA_SQLJ_TYPE_ATTRS view, 5.105
- DBA_SQLJ_TYPE_METHODS view, 5.106
- DBA_SQLJ_TYPES view, 5.107
- DBA_SQLSET view, 5.108
- DBA_SQLSET_BINDS view, 5.109
- DBA_SQLSET_PLANS view, 5.110
- DBA_SQLSET_REFERENCES view, 5.111
- DBA_SQLSET_STATEMENTS view, 5.112
- DBA_SQLTUNE_BINDS view, 5.113
- DBA_SQLTUNE_PLANS view, 5.114
- DBA_SQLTUNE_RATIONALE_PLAN view, 5.115
- DBA_SQLTUNE_STATISTICS view, 5.116
- DBA_STMT_AUDIT_OPTS view, 5.117
- DBA_STORED_SETTINGS view, 5.118
- DBA_STREAMS_ADD_COLUMN view, 5.119
- DBA_STREAMS_ADMINISTRATOR view, 5.120
- DBA_STREAMS_DELETE_COLUMN view, 5.121
- DBA_STREAMS_GLOBAL_RULES view, 5.122
- DBA_STREAMS_MESSAGE_CONSUMERS view, 5.123
- DBA_STREAMS_MESSAGE_RULES view, 5.124
- DBA_STREAMS_NEWLY_SUPPORTED view, 5.125
- DBA_STREAMS_RENAME_COLUMN view, 5.126
- DBA_STREAMS_RENAME_SCHEMA view, 5.127
- DBA_STREAMS_RENAME_TABLE view, 5.128
- DBA_STREAMS_RULES view, 5.129
- DBA_STREAMS_SCHEMA_RULES view, 5.130
- DBA_STREAMS_TABLE_RULES view, 5.131
- DBA_STREAMS_TRANSFORM_FUNCTION view, 5.132
- DBA_STREAMS_TRANSFORMATIONS view, 5.133
- DBA_STREAMS_UNSUPPORTED view, 5.134
- DBA_SUBPART_COL_STATISTICS view, 5.135
- DBA_SUBPART_HISTOGRAMS view, 5.136
- DBA_SUBPART_KEY_COLUMNS view, 5.137
- DBA_SUBPARTITION_TEMPLATES view, 5.138
- DBA_SUBSCRIBED_COLUMNS view, 5.139
- DBA_SUBSCRIBED_TABLES view, 5.140
- DBA_SUBSCRIPTIONS view, 5.141
- DBA_SYNONYMS view, 5.142
- DBA_SYS_PRIVS view, 5.143
- DBA_TAB_COL_STATISTICS view, 5.144
- DBA_TAB_COLS view, 5.145
- DBA_TAB_COLUMNS view, 5.146
- DBA_TAB_COMMENTS view, 5.147
- DBA_TAB_HISTOGRAMS view, 5.148
- DBA_TAB_MODIFICATIONS view, 5.149
- DBA_TAB_PARTITIONS view, 5.150
- DBA_TAB_PRIVS view, 5.151
- DBA_TAB_STATISTICS view, 5.152
- DBA_TAB_STATS_HISTORY view, 5.153
- DBA_TAB_SUBPARTITIONS view, 5.154
- DBA_TABLES view, 5.155
- DBA_TABLESPACE_GROUPS view, 5.156
- DBA_TABLESPACES view, 5.157
- DBA_TEMP_FILES view, 5.158
- DBA_THRESHOLDS view, 5.159
- DBA_TRANSFORMATIONS view, 5.160
- DBA_TRIGGER_COLS view, 5.161
- DBA_TRIGGERS view, 5.162
- DBA_TS_QUOTAS view, 5.163
- DBA_TSM_DESTINATION view, 5.164
- DBA_TSM_SOURCE view, 5.165
- DBA_TUNE_MVIEW view, 5.166
- DBA_TYPE_ATTRS view, 5.167
- DBA_TYPE_METHODS view, 5.168
- DBA_TYPE_VERSIONS view, 5.169
- DBA_TYPES view, 5.170
- DBA_UNDO_EXTENTS view, 5.171
- DBA_UNUSED_COL_TABS view, 5.172
- DBA_UPDATABLE_COLUMNS view, 5.173
- DBA_USERS view, 5.174
- DBA_USTATS view, 5.175
- DBA_VARRAYS view, 5.176
- DBA_VIEWS view, 5.177
- DBA_WAITERS view, 5.178
- DBA_WARNING_SETTINGS view, 5.179
- DBA_WORKSPACE_SESSIONS view, 2.1.2
- DBA_XML_SCHEMAS view, 5.180
- DBA_XML_TAB_COLS view, 5.181
- DBA_XML_TABLES view, 5.182
- DBA_XML_VIEW_COLS view, 5.183
- DBA_XML_VIEWS view, 5.188
- DBMS_ALERT_INFO view, 5.189
- DBMS_LOCK_ALLOCATED view, 5.190
- DBMSIOTC.SQL script, B.2
- DBMSPOOL.SQL script, B.2
- DBWR_IO_SLAVES initialization parameter, 1.58
- DEFCALL view, 2.1.1
- DEFCALLDEST view, 2.1.1
- DEFDEFAULTDEST view, 2.1.1
- DEFERRCOUNT view, 2.1.1
- 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, 5.191
- destination
-
- archiving redo log files, 1.99
- overriding default, 1.99
- USER_DUMP_DEST, 1.224
- DG_BROKER_CONFIG_FILEn initialization parameter, 1.59
- DG_BROKER_START initialization parameter, 1.60
- DICT synonym for DICTIONARY, 5.192
- DICT_COLUMNS view, 5.193
- DICTIONARY view, 5.194
-
- DICT synonym, 5.192
- disk drives
-
- archiving destination, 1.99
- DISK_ASYNCH_IO initialization parameter, 1.61
- dispatcher processes
-
- maximum number, 1.115
- DISPATCHERS initialization parameter, 1.62
- distinguished name, 1.171
- DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.63
- DML_LOCKS initialization parameter, 1.64
- downgrading
-
- scripts, B.4
- dump files, 1.116
- dynamic performance tables
-
- CATALOG.SQL script, 6.1
- public synonyms (V$), 6.1.1
- views (V_$), 6.1.1
E
- embedded initialization parameter files, 1.81
- 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.64
- 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.171
- ERROR_SIZE view, 5.195
- EVENT initialization parameter, 1.65
- EXCEPTIONS view, 5.196
- extent
-
- allocating to instance, 1.84
F
- FAL_CLIENT initialization parameter, 1.66
- FAL_SERVER initialization parameter, 1.67
- FAST_START_MTTR_TARGET initialization parameter, 1.68
- FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.69
- FILE_MAPPING initialization parameter, 1.70
- FILEIO_NETWORK_ADAPTERS initialization parameter, 1.71
- filenames
-
- case significance, 1.3.2.1.1
- name and number, 1.74
- FILESYSTEMIO_OPTIONS initialization parameter, 1.72
- FIXED_DATE initialization parameter, 1.73
- FLASHBACK_TRANSACTION_QUERY view, 5.184
- free space list
-
- locating space, 1.84
- FREELIST GROUPS clause, 1.84
G
- GC_FILES_TO_LOCKS initialization parameter, 1.74
- GCS_SERVER_PROCESSES initialization parameter, 1.75
- GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.76
- GLOBAL_NAME view, 5.185
- GLOBAL_NAMES initialization parameter, 1.77
- GV$ views
-
- for Real Application Clusters, 6.1.2
H
- HASH_AREA_SIZE initialization parameter, 1.78
- Heterogeneous Services
-
- agents, 1.80
- HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.79
- HS_ALL_CAPS view, 5.186
- HS_ALL_DD view, 5.187
- HS_ALL_INITS view, 5.197
- HS_AUTOREGISTER initialization parameter, 1.80
- HS_BASE_CAPS view, 5.198
- HS_BASE_DD view, 5.199
- HS_CLASS_CAPS view, 5.200
- HS_CLASS_DD view, 5.201
- HS_CLASS_INIT view, 5.202
- HS_EXTERNAL_OBJECT_PRIVILEGES view, 5.203
- HS_EXTERNAL_OBJECTS view, 5.204
- HS_EXTERNAL_USER_PRIVILEGES view, 5.205
- HS_FDS_CLASS view, 5.206
- HS_FDS_INST view, 5.207
- HS_INST_CAPS view, 5.208
- HS_INST_DD view, 5.209
- HS_INST_INIT view, 5.210
I
- IDEPTREE view, 5.211
- IFILE initialization parameter, 1.3.2.1.1, 1.81
- IND synonym for USER_INDEXES view, 5.212
- INDEX_HISTOGRAM view, 5.213
- INDEX_STATS view, 5.214
- initialization parameter file
-
- common file, 1.81
- embedded, 1.81
- 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
- AUDIT_FILE_DEST, 1.13
- AUDIT_SYS_OPERATIONS, 1.14
- AUDIT_SYSLOG_LEVEL, 1.15
- AUDIT_TRAIL, 1.16
- BACKGROUND_CORE_DUMP, 1.17
- BACKGROUND_DUMP_DEST, 1.18
- BACKUP_TAPE_IO_SLAVES, 1.19
- basic, 1.2
- BITMAP_MERGE_AREA_SIZE, 1.20
- BLANK_TRIMMING, 1.21
- case significance in filenames, 1.3.2.1.1
- CIRCUITS, 1.22
- CLUSTER_DATABASE, 1.23
- CLUSTER_DATABASE_INSTANCES, 1.24
- CLUSTER_INTERCONNECTS, 1.25
- COMMIT_POINT_STRENGTH, 1.26
- COMMIT_WRITE, 1.27
- COMPATIBLE, 1.28
- CONTROL_FILE_RECORD_KEEP_TIME, 1.29
- CONTROL_FILES, 1.30
- CORE_DUMP_DEST, 1.31
- CPU_COUNT, 1.32
- CREATE_BITMAP_AREA_SIZE, 1.33
- CREATE_STORED_OUTLINES, 1.34
- CURSOR_SHARING, 1.35
- CURSOR_SPACE_FOR_TIME, 1.36
- DB_BLOCK_BUFFERS, 1.38
- DB_BLOCK_CHECKING, 1.39
- DB_BLOCK_CHECKSUM, 1.40
- DB_BLOCK_SIZE, 1.41
- DB_CACHE_ADVICE, 1.42
- DB_CACHE_SIZE, 1.43
- DB_CREATE_FILE_DEST, 1.44
- DB_CREATE_ONLINE_LOG_DEST_n, 1.45
- DB_DOMAIN, 1.46
- DB_FILE_MULTIBLOCK_READ_COUNT, 1.47
- DB_FILE_NAME_CONVERT, 1.48
- DB_FILES, 1.49
- DB_FLASHBACK_RETENTION_TARGET, 1.50
- DB_KEEP_CACHE_SIZE, 1.51
- DB_NAME, 1.52
- DB_nK_CACHE_SIZE, 1.37
- DB_RECOVERY_FILE_DEST, 1.53
- DB_RECOVERY_FILE_DEST_SIZE, 1.54
- DB_RECYCLE_CACHE_SIZE, 1.55
- DB_UNIQUE_NAME, 1.56
- DB_WRITER_PROCESSES, 1.57
- DBWR_IO_SLAVES, 1.58
- derived, 1.1.1.1
- DG_BROKER_CONFIG_FILEn, 1.59
- DG_BROKER_START, 1.60
- DISK_ASYNCH_IO, 1.61
- DISPATCHERS, 1.62
- display current settings, 1.4.3
- DISTRIBUTED_LOCK_TIMEOUT, 1.63
- DML_LOCKS, 1.64
- embedded initialization parameter files, 1.3.2.1.1
- EVENT, 1.65
- FAL_CLIENT, 1.66
- FAL_SERVER, 1.67
- FAST_START_MTTR_TARGET, 1.68
- FAST_START_PARALLEL_ROLLBACK, 1.69
- FILE_MAPPING, 1.70
- FILEIO_NETWORK_ADAPTERS, 1.71
- FILESYSTEMIO_OPTIONS, 1.72
- FIXED_DATE, 1.73
- functional category, 1.4.1
- GC_FILES_TO_LOCKS, 1.74
- GCS_SERVER_PROCESSES, 1.75
- GLOBAL_CONTEXT_POOL_SIZE, 1.76
- GLOBAL_NAMES, 1.77
- HASH_AREA_SIZE, 1.78
- HI_SHARED_MEMORY_ADDRESS, 1.79
- HS_AUTOREGISTER, 1.80
- IFILE, 1.3.2.1.1, 1.81
- INSTANCE_GROUPS, 1.82
- INSTANCE_NAME, 1.83
- INSTANCE_NUMBER, 1.84
- INSTANCE_TYPE, 1.85
- JAVA_MAX_SESSIONSPACE_SIZE, 1.86
- JAVA_POOL_SIZE, 1.87
- JAVA_SOFT_SESSIONSPACE_LIMIT, 1.88
- JOB_QUEUE_PROCESSES, 1.89
- LARGE_POOL_SIZE, 1.90
- LDAP_DIRECTORY_ACCESS, 1.91
- LICENSE_MAX_SESSIONS, 1.92
- LICENSE_MAX_USERS, 1.93
- LICENSE_SESSIONS_WARNING, 1.94
- LOCAL_LISTENER, 1.95
- LOCK_NAME_SPACE, 1.96
- LOCK_SGA, 1.97
- LOG_ARCHIVE_CONFIG, 1.98
- LOG_ARCHIVE_DEST, 1.99
- LOG_ARCHIVE_DEST_n, 1.100
- LOG_ARCHIVE_DEST_STATE_n, 1.101
- LOG_ARCHIVE_DUPLEX_DEST, 1.102
- LOG_ARCHIVE_FORMAT, 1.103
- LOG_ARCHIVE_LOCAL_FIRST, 1.104
- LOG_ARCHIVE_MAX_PROCESSES, 1.105
- LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.106
- LOG_ARCHIVE_TRACE, 1.107
- LOG_BUFFER, 1.108
- LOG_CHECKPOINT_INTERVAL, 1.109
- LOG_CHECKPOINT_TIMEOUT, 1.110
- LOG_CHECKPOINTS_TO_ALERT, 1.111
- LOG_FILE_NAME_CONVERT, 1.112
- LOGMNR_MAX_PERSISTENT_SESSIONS, 1.113
- MAX_COMMIT_PROPAGATION_DELAY, 1.114
- MAX_DISPATCHERS, 1.115
- MAX_DUMP_FILE_SIZE, 1.116
- MAX_ENABLED_ROLES, 1.117
- MAX_SHARED_SERVERS, 1.118
- modifiable, 1.4.2
- NLS_CALENDAR, 1.119
- NLS_COMP, 1.120
- NLS_CURRENCY, 1.121
- NLS_DATE_FORMAT, 1.122
- NLS_DATE_LANGUAGE, 1.123
- NLS_DUAL_CURRENCY, 1.124
- NLS_ISO_CURRENCY, 1.125
- NLS_LANGUAGE, 1.126
- NLS_LENGTH_SEMANTICS, 1.127
- NLS_NCHAR_CONV_EXCP, 1.128
- NLS_NUMERIC_CHARACTERS, 1.129
- NLS_SORT, 1.130
- NLS_TERRITORY, 1.131
- NLS_TIMESTAMP_FORMAT, 1.132
- NLS_TIMESTAMP_TZ_FORMAT, 1.133
- O7_DICTIONARY_ACCESSIBILITY, 1.134
- OBJECT_CACHE_MAX_SIZE_PERCENT, 1.135
- OBJECT_CACHE_OPTIMAL_SIZE, 1.136
- OLAP_PAGE_POOL_SIZE, 1.137
- OPEN_CURSORS, 1.138
- OPEN_LINKS, 1.139
- OPEN_LINKS_PER_INSTANCE, 1.140
- operating system-dependent values, 1.1.1.2
- OPTIMIZER_DYNAMIC_SAMPLING, 1.141
- OPTIMIZER_FEATURES_ENABLE, 1.142
- OPTIMIZER_INDEX_CACHING, 1.143
- OPTIMIZER_INDEX_COST_ADJ, 1.144
- OPTIMIZER_MODE, 1.145
- OPTIMIZER_SECURE_VIEW_MERGING, 1.146
- OS_AUTHENT_PREFIX, 1.147
- OS_ROLES, 1.148
- PARALLEL_ADAPTIVE_MULTI_USER, 1.149
- PARALLEL_AUTOMATIC_TUNING, 1.150
- PARALLEL_EXECUTION_MESSAGE_SIZE, 1.151
- PARALLEL_INSTANCE_GROUP, 1.152
- PARALLEL_MAX_SERVERS, 1.153
- PARALLEL_MIN_PERCENT, 1.154
- PARALLEL_MIN_SERVERS, 1.155
- PARALLEL_THREADS_PER_CPU, 1.156
- parameter files, 1.3
- performance tuning, 1.1.1.3
- PGA_AGGREGATE_TARGET, 1.157
- PLSQL_CCFLAGS, 1.158
- PLSQL_CODE_TYPE, 1.159
- PLSQL_COMPILER_FLAGS, 1.160
- PLSQL_DEBUG, 1.161
- PLSQL_NATIVE_LIBRARY_DIR, 1.162
- PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1.163
- PLSQL_OPTIMIZE_LEVEL, 1.164
- PLSQL_V2_COMPATIBILITY, 1.165
- PLSQL_WARNINGS, 1.166
- PRE_PAGE_SGA, 1.167
- PROCESSES, 1.168
- QUERY_REWRITE_ENABLED, 1.169
- QUERY_REWRITE_INTEGRITY, 1.170
- RDBMS_SERVER_DN, 1.171
- READ_ONLY_OPEN_DELAYED, 1.172
- RECOVERY_PARALLELISM, 1.173
- RECYCLEBIN, 1.174
- REMOTE_ARCHIVE_ENABLE, 1.175
- REMOTE_DEPENDENCIES_MODE, 1.176
- REMOTE_LISTENER, 1.177
- REMOTE_LOGIN_PASSWORDFILE, 1.178
- REMOTE_OS_AUTHENT, 1.179
- REMOTE_OS_ROLES, 1.180
- REPLICATION_DEPENDENCY_TRACKING, 1.181
- RESOURCE_LIMIT, 1.182
- RESOURCE_MANAGER_PLAN, 1.183
- RESUMABLE_TIMEOUT, 1.184
- ROLLBACK_SEGMENTS, 1.185
- SERIAL_REUSE, 1.186
- SERVICE_NAMES, 1.187
- SESSION_CACHED_CURSORS, 1.188
- SESSION_MAX_OPEN_FILES, 1.189
- SESSIONS, 1.190
- SGA_MAX_SIZE, 1.191
- SGA_TARGET, 1.192
- SHADOW_CORE_DUMP, 1.193
- SHARED_MEMORY_ADDRESS, 1.194
- SHARED_POOL_RESERVED_SIZE, 1.195
- SHARED_POOL_SIZE, 1.196
- SHARED_SERVER_SESSIONS, 1.197
- SHARED_SERVERS, 1.198
- SKIP_UNUSABLE_INDEXES, 1.199
- SMTP_OUT_SERVER, 1.200
- SORT_AREA_RETAINED_SIZE, 1.201
- SORT_AREA_SIZE, 1.202
- specifying in initialization parameter files, 1.3.2.1
- SPFILE, 1.203
- SQL_TRACE, 1.204
- SQL92_SECURITY, 1.205
- SQLTUNE_CATEGORY, 1.206
- STANDBY_ARCHIVE_DEST, 1.207
- STANDBY_FILE_MANAGEMENT, 1.208
- STAR_TRANSFORMATION_ENABLED, 1.209
- STATISTICS_LEVEL, 1.210
- STREAMS_POOL_SIZE, 1.211
- TAPE_ASYNCH_IO, 1.212
- THREAD, 1.213
- TIMED_OS_STATISTICS, 1.214
- TIMED_STATISTICS, 1.215
- TRACE_ENABLED, 1.216
- TRACEFILE_IDENTIFIER, 1.217
- TRANSACTIONS, 1.218
- TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.219
- UNDO_MANAGEMENT, 1.220
- UNDO_RETENTION, 1.221
- UNDO_TABLESPACE, 1.222
- USE_INDIRECT_DATA_BUFFERS, 1.223
- USER_DUMP_DEST, 1.224
- UTL_FILE_DIR, 1.225
- variable, 1.1.1.3
- WORKAREA_SIZE_POLICY, 1.226
- INITJVM.SQL script, B.5
- INIT.ORA file. See initialization parameter file
- IN-list iterators
-
- optimizer use of, 1.143
- inserts
-
- locating free space, 1.84
- INST_ID column, 6.1.2
- INSTANCE clause
-
- of ALTER TABLE
-
- allocating extents, 1.84
- INSTANCE_GROUPS initialization parameter, 1.82
- INSTANCE_NAME initialization parameter, 1.83
- INSTANCE_NUMBER initialization parameter, 1.84
- INSTANCE_TYPE initialization parameter, 1.85
- instances
-
- checkpoint, 1.109
- startup order, 1.84
- I/O
-
- reading multiple blocks, 1.47
- redo log files, 1.108
J
- Java initialization parameters
-
- JAVA_MAX_SESSIONSPACE_SIZE, 1.86
- JAVA_POOL_SIZE, 1.87
- JAVA_SOFT_SESSIONSPACE_LIMIT, 1.88
- Java scripts, B.5
- JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.86
- JAVA_POOL_SIZE initialization parameter, 1.87
- JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.88
- JOB_QUEUE_PROCESSES initialization parameter, 1.89
L
- language
-
- database default language, 1.126
- LARGE_POOL_SIZE initialization parameter, 1.90
- LDAP_DIRECTORY_ACCESS initialization parameter, 1.91
- LICENSE_MAX_SESSIONS initialization parameter, 1.92
- LICENSE_MAX_USERS initialization parameter, 1.93
- LICENSE_SESSIONS_WARNING initialization parameter, 1.94
- licenses
-
- maximum sessions, 1.92
- maximum users, 1.93
- warning for concurrent user sessions, 1.94
- limits on the database, A
- linguistic sorts, 1.130
- local currency, 1.120, 1.121
- LOCAL_LISTENER initialization parameter, 1.95
- LOCK_NAME_SPACE initialization parameter, 1.96
- LOCK_SGA initialization parameter, 1.97
- locks
-
- names, C.2
- LOG_ARCHIVE_CONFIG initialization parameter, 1.98
- LOG_ARCHIVE_DEST initialization parameter, 1.99
- LOG_ARCHIVE_DEST_n initialization parameter, 1.100
- LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.101
- LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.102
- LOG_ARCHIVE_FORMAT initialization parameter, 1.103
- LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.104
- LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.105
- LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.106
- LOG_ARCHIVE_TRACE initialization parameter, 1.107
- LOG_BUFFER initialization parameter, 1.108
- LOG_CHECKPOINT_INTERVAL initialization parameter, 1.109
- LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.110
- LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.111
- LOG_FILE_NAME_CONVERT initialization parameter, 1.112
- LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1.113
- lowercase significance, 1.3.2.1.1
M
- MAP_OBJECT table, 5.215
- MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1.114
- MAX_DISPATCHERS initialization parameter, 1.115
- MAX_DUMP_FILE_SIZE initialization parameter, 1.116
- MAX_ENABLED_ROLES initialization parameter, 1.117
- MAX_SHARED_SERVERS initialization parameter, 1.118
- memory
-
- amount used for sorting, 1.201
- virtual, 1.1.1.3
- monitor
-
- performance, 1.109
- multiple-process systems
-
- number of processes, 1.168
N
- NLS_CALENDAR initialization parameter, 1.119
- NLS_COMP initialization parameter, 1.120
- NLS_CURRENCY initialization parameter, 1.121
-
- defined by NLS_TERRITORY, 1.131
- NLS_DATABASE_PARAMETERS view, 5.216
- NLS_DATE_FORMAT initialization parameter, 1.122
-
- defined by NLS_NUMERIC_CHARACTERS, 1.129
- defined by NLS_TERRITORY, 1.131
- NLS_DATE_LANGUAGE initialization parameter, 1.123
- NLS_DUAL_CURRENCY initialization parameter, 1.124
- NLS_INSTANCE_PARAMETERS view, 5.217
- NLS_ISO_CURRENCY initialization parameter, 1.125
-
- defined by NLS_TERRITORY, 1.131
- NLS_LANGUAGE initialization parameter, 1.126
- NLS_LENGTH_SEMANTICS initialization parameter, 1.127
- NLS_NCHAR_CONV_EXCP initialization parameter, 1.128
- NLS_NUMERIC_CHARACTERS initialization parameter, 1.129
- NLS_SESSION_PARAMETERS view, 5.218
- NLS_SORT initialization parameter, 1.130
- NLS_TERRITORY initialization parameter, 1.131
- NLS_TIMESTAMP_FORMAT initialization parameter, 1.132
- NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.133
- numeric group separators, 1.129
O
- O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.134
- OBJ synonym for USER_OBJECTS view, 5.219
- OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.135
- OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.136
- objects
-
- data dictionary, 2.1
- OLAP_PAGE_POOL_SIZE initialization parameter, 1.137
- online redo log
-
- archiving mode, 1.99
- block, 1.109
- file size, 1.109
- setting checkpoint interval, 1.109
- OPEN_CURSORS initialization parameter, 1.138
- OPEN_LINKS initialization parameter, 1.139
- OPEN_LINKS_PER_INSTANCE initialization parameter, 1.140
- operating system
-
- authenticating remote clients, 1.179
- authenticating users and passwords, 1.147
- dependent parameters, 1.1.1.2
- roles for remote clients, 1.180
- optimization
-
- trading cursor space for time, 1.36
- OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.141
- OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.142
- OPTIMIZER_INDEX_CACHING initialization parameter, 1.143
- OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.144
- OPTIMIZER_MODE initialization parameter, 1.145
- OPTIMIZER_SECURE_VIEW_MERGING initialization parameter, 1.146
- ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE view.
- OS_AUTHENT_PREFIX initialization parameter, 1.147
- OS_ROLES initialization parameter, 1.148
P
- parallel query
-
- maximum number of instances, 1.151
- maximum number of servers, 1.153
- minimum number of queries, 1.155
- PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.149
- PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.150
- PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.151
- PARALLEL_INSTANCE_GROUP initialization parameter, 1.152
- PARALLEL_MAX_SERVERS initialization parameter, 1.153
- PARALLEL_MIN_PERCENT initialization parameter, 1.154
- PARALLEL_MIN_SERVERS initialization parameter, 1.155
- PARALLEL_THREADS_PER_CPU initialization parameter, 1.156
- passwords
-
- authenticating, 1.147, 1.179
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.178
- PCM lock
-
- mapping blocks to, 1.74
- performance, 1.1.1.3
-
- shared pool, 1.196
- PGA_AGGREGATE_TARGET initialization parameter, 1.157
- PLAN_TABLE table, 5.220
- PLSQL_CCFLAGS initialization parameter, 1.158
- PLSQL_CODE_TYPE initialization parameter, 1.159
- PLSQL_COMPILER_FLAGS initialization parameter, 1.160
- PLSQL_DEBUG initialization parameter, 1.161
- PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1.162
- PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1.163
- PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.164
- PLSQL_V2_COMPATIBILITY initialization parameter, 1.165
- PLSQL_WARNINGS initialization parameter, 1.166
- PLUGGABLE_SET_CHECK view, 5.221
- PRE_PAGE_SGA initialization parameter, 1.167
- privileges
-
- remote login, 1.178
- RESTRICTED_SESSION privilege, 1.92, 1.94
- table-level select privileges, 1.205
- procedures
-
- shared pool, 1.196
- processes
-
- derived parameter values, 1.218
- dispatcher process maximum number, 1.115
- maximum shared server processes, 1.118
- number of server processes, 1.86, 1.88, 1.197, 1.198
- recovery, 1.173
- trace files, 1.224
- user processes, 1.168
- PROCESSES initialization parameter, 1.168
- PRODUCT_COMPONENT_VERSION view, 5.222
- profiles
-
- resource limits, 1.182, 1.183
- PROXY_USERS view, 5.223
- PSTUBTBL view, 5.224
- PUBLIC clause
-
- of ALTER DATABASE
-
- thread of redo, 1.213
- PUBLIC_DEPENDENCY view, 5.225
- PUBLICSYN view, 5.226
Q
- queries
-
- dictionary views, 1.74
- hints, 1.145
- QUERY_REWRITE_ENABLED initialization parameter, 1.169
- QUERY_REWRITE_INTEGRITY initialization parameter, 1.170
- QUEUE_PRIVILEGES view, 5.227
R
- RC_ARCHIVED_LOG view, 2.1.3
- RC_BACKUP_CONTROLFILE view, 2.1.3
- RC_BACKUP_CORRUPTION view, 2.1.3
- RC_BACKUP_DATAFILE view, 2.1.3
- RC_BACKUP_PIECE view, 2.1.3
- RC_BACKUP_REDOLOG view, 2.1.3
- RC_BACKUP_SET view, 2.1.3
- RC_BACKUP_SPFILE 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_CONTROLFILE 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_RESYNC view, 2.1.3
- RC_RMAN_CONFIGURATION 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
- RDBMS_SERVER_DN initialization parameter, 1.171
- READ_ONLY_OPEN_DELAYED initialization parameter, 1.172
- Real Application Clusters
-
- dynamic performance views, 6.1.2
- initialization parameters
-
- CIRCUITS, 1.22
- CLUSTER_DATABASE, 1.23
- CLUSTER_DATABASE_INSTANCES, 1.24
- CLUSTER_INTERCONNECTS, 1.25
- DISPATCHERS, 1.62
- FAST_START_PARALLEL_ROLLBACK, 1.69
- PARALLEL_ADAPTIVE_MULTI_USER, 1.149
- PARALLEL_AUTOMATIC_TUNING, 1.150
- PARALLEL_EXECUTION_MESSAGE_SIZE, 1.151
- PARALLEL_INSTANCE_GROUP, 1.152
- PARALLEL_MAX_SERVERS, 1.153
- PARALLEL_MIN_PERCENT, 1.154
- PARALLEL_MIN_SERVERS, 1.155
- PARALLEL_THREADS_PER_CPU, 1.156
- recovery
-
- number of required processes, 1.173
- RECOVERY_PARALLELISM initialization parameter, 1.173
- RECYCLEBIN initialization parameter, 1.174
- RECYCLEBIN synonym for USER_RECYCLEBIN view, 5.228
- redo logs
-
- buffer size, 1.108
- redo thread, 1.213
- remote clients
-
- authenticating, 1.179
- remote logins, 1.178
- REMOTE_ARCHIVE_ENABLE initialization parameter, 1.175
- REMOTE_DEPENDENCIES_MODE initialization parameter, 1.176
- REMOTE_LISTENER initialization parameter, 1.177
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.178
- REMOTE_OS_AUTHENT initialization parameter, 1.179
- REMOTE_OS_ROLES initialization parameter, 1.180
- REPAIR_TABLE view. See DBA_REPAIR_TABLE view.
- REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.181
- resource limits for profiles, 1.182, 1.183
- RESOURCE_COST view, 5.229
- RESOURCE_LIMIT initialization parameter, 1.182
- RESOURCE_MANAGER_PLAN initialization parameter, 1.183
- RESOURCE_MAP table, 5.230
- RESUMABLE_TIMEOUT initialization parameter, 1.184
- RMJVM.SQL script, B.5
- ROLE_ROLE_PRIVS view, 5.231
- ROLE_SYS_PRIVS view, 5.232
- ROLE_TAB_PRIVS view, 5.233
- ROLE_WM_PRIVS view, 2.1.2
- roles, 1.148
-
- remote clients, 1.180
- ROLLBACK_SEGMENTS initialization parameter, 1.185
S
- 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
- CATNOQUE.SQL, B.3
- CATNORMN.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
- CATRMAN.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
- UTLU101I.SQL, B.4
- UTLU101S.SQL, B.4
- UTLVALID.SQL, B.2
- UTLXPLAN.SQL, B.2
- SEQ synonym for USER_SEQUENCES view, 5.234
- SERIAL_REUSE initialization parameter, 1.186
- server parameter file
-
- overview, 1.3
- server processes
-
- number, 1.86, 1.88, 1.197, 1.198
- SERVICE_NAMES initialization parameter, 1.187
- SESSION_CACHED_CURSORS initialization parameter, 1.188
- SESSION_CONTEXT view, 5.235
- SESSION_MAX_OPEN_FILES initialization parameter, 1.189
- SESSION_PRIVS view, 5.236
- SESSION_ROLES view, 5.237
- SESSIONS initialization parameter, 1.190
- SGA_MAX_SIZE initialization parameter, 1.191
- SGA_TARGET initialization parameter, 1.192
- SHADOW_CORE_DUMP initialization parameter, 1.193
- shared server
-
- SESSIONS initialization parameter, 1.190
- shared server processes
-
- maximum number, 1.118
- SHARED_MEMORY_ADDRESS initialization parameter, 1.194
- SHARED_POOL_RESERVED_SIZE initialization parameter, 1.195
- SHARED_POOL_SIZE initialization parameter, 1.196
- SHARED_SERVER_SESSIONS initialization parameter, 1.197
- SHARED_SERVERS initialization parameter, 1.198
- SHOW PARAMETERS command, 1.4.3
- SKIP_UNUSABLE_INDEXES initialization parameter, 1.199
- SMTP_OUT_SERVER initialization parameter, 1.200
- SORT_AREA_RETAINED_SIZE initialization parameter, 1.201
- SORT_AREA_SIZE initialization parameter, 1.202
- sorting
-
- maximum memory, 1.201
- ORDER BY queries, 1.130
- SOURCE_SIZE view, 5.238
- SPFILE initialization parameter, 1.203
- SQL scripts
-
- creating the data dictionary, B.1
- optional, B.2
- required, B.1
- SQL_TRACE initialization parameter, 1.204
- SQL92_SECURITY initialization parameter, 1.205
- SQLTUNE_CATEGORY initialization parameter, 1.206
- STANDBY_ARCHIVE_DEST initialization parameter, 1.207
- STANDBY_FILE_MANAGEMENT initialization parameter, 1.208
- STAR_TRANSFORMATION_ENABLED initialization parameter, 1.209
- starting up
-
- instance number, 1.84
- startup order, 1.84
- 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 authentication, 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.109, 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
- 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 release 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 (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 IO requests, 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 direct, 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 from cache, E.2
- physical writes non checkpoint, E.2
- pinned buffers inspected, E.2
- prefetched blocks, 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
- recursive calls, E.2
- recursive cpu usage, E.2
- redo blocks written, E.2
- redo buffer allocation retries, E.2
- redo entries, E.2
- redo log space requests, E.2
- redo log space wait time, E.2
- redo log switch interrupts, E.2
- redo ordering marks, E.2
- redo size, E.2
- redo sync writes, E.2
- redo synch time, E.2
- redo wastage, E.2
- redo write time, E.2
- redo writer latching time, 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
- 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.215
- 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.210
- STMT_AUDIT_OPTION_MAP table, 5.239
- STREAMS_POOL_SIZE initialization parameter, 1.211
- switch redo log file, 1.109
- SYN synonym for USER_SYNONYMS view, 5.240
- SYNONYMS view, 5.241
- SYS_OBJECTS view, 5.246
- SYSCATALOG view, 5.242
- SYSFILES view, 5.243
- SYSSEGOBJ view, 5.244
- system global area, 1.1.1.3
-
- buffer areas, 1.108
- maximum concurrent transactions, 1.218
- system performance, 1.1.1.3
- SYSTEM_PRIVILEGE_MAP table, 5.245
T
- TAB view, 5.247
- TABLE_PRIVILEGE_MAP table, 5.248
- tables
-
- data dictionary, 2.1
- DML locks, 1.64
- locating free space, 1.84
- TABQUOTAS view, 5.250
- TABS synonym for USER_TABLES view, 5.249
- tape archiving destination, 1.99
- TAPE_ASYNCH_IO initialization parameter, 1.212
- territory, 1.124, 1.131
- THREAD initialization parameter, 1.213
- TIMED_OS_STATISTICS initialization parameter, 1.214
- TIMED_STATISTICS initialization parameter, 1.215
-
- file read/write statistics, 6.107, 7.165
- TO_CHAR function, 1.122
- TO_DATE function, 1.122
- trace files
-
- destination, 1.224
- maximum size, 1.116
- TRACE_ENABLED initialization parameter, 1.216
- TRACEFILE_IDENTIFIER initialization parameter, 1.217
- transactions
-
- concurrent, 1.218
- data locking, 1.64
- TRANSACTIONS initialization parameter, 1.218
-
- DML locks, 1.64
- TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.219
- TRUSTED_SERVERS view, 5.251
- TS_PITR_CHECK view, 5.252
- TS_PITR_OBJECTS TO_BE_DROPPED view, 5.253
U
- UNDO_MANAGEMENT initialization parameter, 1.220
- UNDO_RETENTION initialization parameter, 1.221
- UNDO_TABLESPACE initialization parameter, 1.222
- UNI_PLUGGABLE_SET_CHECK view, 5.254
- updates
-
- locating free space, 1.84
- upgrading
-
- scripts, B.4
- uppercase characters, 1.3.2.1.1
- USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.223
- user processes
-
- trace files, 1.224
- USER_ADVISOR_ACTIONS view, 5.255
- USER_ADVISOR_FINDINGS view, 5.256
- USER_ADVISOR_JOURNAL view, 5.257
- USER_ADVISOR_LOG view, 5.258
- USER_ADVISOR_OBJECTS view, 5.259
- USER_ADVISOR_PARAMETERS view, 5.260
- USER_ADVISOR_RATIONALE view, 5.261
- USER_ADVISOR_RECOMMENDATIONS view, 5.262
- USER_ADVISOR_SQLA_REC_SUM view, 5.263
- USER_ADVISOR_SQLA_WK_MAP view, 5.264
- USER_ADVISOR_SQLA_WK_STMTS view, 5.265
- USER_ADVISOR_SQLW_JOURNAL view, 5.266
- USER_ADVISOR_SQLW_PARAMETERS view, 5.267
- USER_ADVISOR_SQLW_STMTS view, 5.268
- USER_ADVISOR_SQLW_SUM view, 5.269
- USER_ADVISOR_SQLW_TABLES view, 5.270
- USER_ADVISOR_SQLW_TEMPLATES view, 5.271
- USER_ADVISOR_TASKS view, 5.272
- USER_ADVISOR_TEMPLATES view, 5.273
- USER_ALL_TABLES view, 5.274
- USER_AQ_AGENT_PRIVS view, 5.275
- USER_ARGUMENTS view, 5.276
- USER_ASSOCIATIONS view, 5.277
- USER_ATTRIBUTE_TRANSFORMATIONS view, 5.278
- USER_AUDIT_OBJECT view, 5.279
- USER_AUDIT_POLICIES view, 5.280
- USER_AUDIT_POLICY_COLUMNS view, 5.281
- USER_AUDIT_SESSION view, 5.282
- USER_AUDIT_STATEMENT view, 5.283
- USER_AUDIT_TRAIL view, 5.284
- USER_AW_PS view, 5.285
- USER_AWS view, 5.286
- USER_BASE_TABLE_MVIEWS view, 5.287
- USER_CATALOG view, 5.288
-
- CAT synonym, 3.126
- USER_CHANGE_NOTIFICATION_REGS view, 5.289
- USER_CLU_COLUMNS view, 5.290
- USER_CLUSTER_HASH_EXPRESSIONS view, 5.291
- USER_CLUSTERS view, 5.292
-
- CLU synonym, 3.133
- USER_COL_COMMENTS view, 5.293
- USER_COL_PRIVS view, 5.294
- USER_COL_PRIVS_MADE view, 5.295
- USER_COL_PRIVS_RECD view, 5.296
- USER_COLL_TYPES view, 5.297
- USER_CONS_COLUMNS view, 5.298
- USER_CONS_OBJ_COLUMNS view, 5.299
- USER_CONSTRAINTS view, 5.300
- USER_DATAPUMP_JOBS view, 5.301
- USER_DB_LINKS view, 5.302
- USER_DEPENDENCIES view, 5.303
- USER_DIM_ATTRIBUTES view, 5.304
- USER_DIM_CHILD_OF view, 5.305
- USER_DIM_HIERARCHIES view, 5.306
- USER_DIM_JOIN_KEY view, 5.307
- USER_DIM_LEVEL_KEY view, 5.308
- USER_DIM_LEVELS view, 5.309
- USER_DIMENSIONS view, 5.310
- USER_DUMP_DEST initialization parameter, 1.224
- USER_ENCRYPTED_COLUMNS view, 5.311
- USER_EPG_DAD_AUTHORIZATION view, 5.312
- USER_ERRORS view, 5.313
- USER_EVALUATION_CONTEXT_TABLES view, 5.314
- USER_EVALUATION_CONTEXT_VARS view, 5.315
- USER_EVALUATION_CONTEXTS view, 5.316
- USER_EXTENTS view, 5.317
- USER_EXTERNAL_LOCATIONS view, 5.318
- USER_EXTERNAL_TABLES view, 5.319
- USER_FILE_GROUP_EXPORT_INFO view, 5.320
- USER_FILE_GROUP_FILES view, 5.321
- USER_FILE_GROUP_TABLES view, 5.322
- USER_FILE_GROUP_TABLESPACES view, 5.323
- USER_FILE_GROUP_VERSIONS view, 5.324
- USER_FILE_GROUPS view, 5.325
- USER_FREE_SPACE view, 5.326
- USER_IND_COLUMNS view, 5.327
- USER_IND_EXPRESSIONS view, 5.328
- USER_IND_PARTITIONS view, 5.329
- USER_IND_STATISTICS view, 5.330
- USER_IND_SUBPARTITIONS view, 5.331
- USER_INDEXES view, 5.332
-
- IND synonym, 5.212
- USER_INDEXTYPE_ARRAYTYPES view, 5.333
- USER_INDEXTYPE_COMMENTS view, 5.334
- USER_INDEXTYPE_OPERATORS view, 5.335
- USER_INDEXTYPES view, 5.336
- USER_INTERNAL_TRIGGERS view, 5.337
- USER_JAVA_ARGUMENTS view, 5.338
- USER_JAVA_CLASSES view, 5.339
- USER_JAVA_DERIVATIONS view, 5.340
- USER_JAVA_FIELDS view, 5.341
- USER_JAVA_IMPLEMENTS view, 5.342
- USER_JAVA_INNERS view, 5.343
- USER_JAVA_LAYOUTS view, 5.344
- USER_JAVA_METHODS view, 5.345
- USER_JAVA_NCOMPS view, 5.346
- USER_JAVA_POLICY view, 5.347
- USER_JAVA_RESOLVERS view, 5.348
- USER_JAVA_THROWS view, 5.349
- USER_JOBS view, 5.350
- USER_JOIN_IND_COLUMNS view, 5.351, 5.351
- USER_LIBRARIES view, 5.352
- USER_LOB_PARTITIONS view, 5.353
- USER_LOB_SUBPARTITIONS view, 5.354
- USER_LOB_TEMPLATES view, 5.355
- USER_LOBS view, 5.356
- USER_LOG_GROUP_COLUMNS view, 5.357
- USER_LOG_GROUPS view, 5.358
- USER_METHOD_PARAMS view, 5.359
- USER_METHOD_RESULTS view, 5.360
- USER_MVIEW_AGGREGATES view, 5.361
- USER_MVIEW_ANALYSIS view, 5.362
- USER_MVIEW_COMMENTS view, 5.363
- USER_MVIEW_DETAIL_RELATIONS view, 5.364
- USER_MVIEW_JOINS view, 5.365
- USER_MVIEW_KEYS view, 5.366
- USER_MVIEW_LOGS view, 5.367
- USER_MVIEW_REFRESH_TIMES view, 5.368
- USER_MVIEWS view, 5.369
- USER_NESTED_TABLE_COLS view, 5.370
- USER_NESTED_TABLES view, 5.371
- USER_OBJ_AUDIT_OPTS view, 5.372
- USER_OBJ_COLATTRS view, 5.373
- USER_OBJECT_SIZE view, 5.374
- USER_OBJECT_TABLES view, 5.375
- USER_OBJECTS view, 5.376
-
- OBJ synonym, 5.219
- USER_OPANCILLARY view, 5.377
- USER_OPARGUMENTS view, 5.378
- USER_OPBINDINGS view, 5.379
- USER_OPERATOR_COMMENTS view, 5.380
- USER_OPERATORS view, 5.381
- USER_OUTLINE_HINTS view, 5.382
- USER_OUTLINES view, 5.383
- USER_PART_COL_STATISTICS view, 5.384
- USER_PART_HISTOGRAMS view, 5.385
- USER_PART_INDEXES view, 5.386
- USER_PART_KEY_COLUMNS view, 5.387
- USER_PART_LOBS view, 5.388
- USER_PART_TABLES view, 5.389
- USER_PARTIAL_DROP_TABS view, 5.390
- USER_PASSWORD_LIMITS view, 5.391
- USER_PENDING_CONV_TABLES view, 5.392
- USER_PLSQL_OBJECT_SETTINGS view, 5.393
- USER_POLICIES view, 5.394
- USER_POLICY_CONTEXTS view, 5.395
- USER_POLICY_GROUPS view, 5.396
- USER_PROCEDURES view, 5.397
- USER_PROXIES view, 5.398
- USER_PUBLISHED_COLUMNS view, 5.399
- USER_QUEUE_SCHEDULES view, 5.400
- USER_QUEUE_SUBSCRIBERS view, 5.401
- USER_QUEUE_TABLES view, 5.402
- USER_QUEUES view, 5.403
- USER_RECYCLEBIN view, 5.404
-
- RECYCLEBIN synonym, 5.228
- USER_REFRESH view, 5.405
- USER_REFRESH_CHILDREN view, 5.406
- USER_REFS view, 5.407
- USER_REGISTERED_MVIEWS view, 5.408
- USER_REGISTRY view, 5.409
- 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, 5.410
- USER_RESUMABLE view, 5.411
- USER_REWRITE_EQUIVALENCES view, 5.412
- USER_ROLE_PRIVS view, 5.413
- USER_RSRC_CONSUMER_GROUP_PRIVS view, 5.414
- USER_RSRC_MANAGER_SYSTEM_PRIVS view, 5.415
- USER_RULE_SET_RULES view, 5.416
- USER_RULE_SETS view, 5.417
- USER_RULES view, 5.418
- USER_SCHEDULER_CHAIN_RULES view, 5.419
- USER_SCHEDULER_CHAIN_STEPS view, 5.420
- USER_SCHEDULER_CHAINS view, 5.421
- USER_SCHEDULER_JOB_ARGS view, 5.422
- USER_SCHEDULER_JOB_LOG view, 5.423
- USER_SCHEDULER_JOB_RUN_DETAILS view, 5.424
- USER_SCHEDULER_JOBS view, 5.425
- USER_SCHEDULER_PROGRAM_ARGS view, 5.426
- USER_SCHEDULER_PROGRAMS view, 5.427
- USER_SCHEDULER_RUNNING_CHAINS view, 5.428
- USER_SCHEDULER_RUNNING_JOBS view, 5.429
- USER_SCHEDULER_SCHEDULES view, 5.430
- USER_SEC_RELEVANT_COLS view, 5.431
- USER_SEGMENTS view, 5.432
- USER_SEQUENCES view, 5.433
-
- SEQ synonym, 5.234
- USER_SOURCE view, 5.434
- USER_SOURCE_TABLES view, 5.435
- USER_SQLJ_TYPE_ATTRS view, 5.436
- USER_SQLJ_TYPE_METHODS view, 5.437
- USER_SQLJ_TYPES view, 5.438
- USER_SQLSET view, 5.439
- USER_SQLSET_BINDS view, 5.440
- USER_SQLSET_PLANS view, 5.441
- USER_SQLSET_REFERENCES view, 5.442
- USER_SQLSET_STATEMENTS view, 5.443
- USER_SQLTUNE_BINDS view, 5.444
- USER_SQLTUNE_PLANS view, 5.445
- USER_SQLTUNE_RATIONALE_PLAN view, 5.446
- USER_SQLTUNE_STATISTICS view, 5.447
- USER_STORED_SETTINGS view, 5.448
- USER_SUBPART_COL_STATISTICS view, 5.449
- USER_SUBPART_HISTOGRAMS view, 5.450
- USER_SUBPART_KEY_COLUMNS view, 5.451
- USER_SUBPARTITION_TEMPLATES view, 5.452
- USER_SUBSCRIBED_COLUMNS view, 5.453
- USER_SUBSCRIBED_TABLES view, 5.454
- USER_SUBSCRIPTIONS view, 5.455
- USER_SYNONYMS view, 5.456
-
- SYN synonym, 5.240
- USER_SYS_PRIVS view, 5.457
- USER_TAB_COL_STATISTICS view, 5.458
- USER_TAB_COLS view, 5.459
- USER_TAB_COLUMNS view, 5.460
-
- COLS synonym, 3.135
- USER_TAB_COMMENTS view, 5.461
- USER_TAB_HISTOGRAMS view, 5.462
- USER_TAB_MODIFICATIONS view, 5.463
- USER_TAB_PARTITIONS view, 5.464
- USER_TAB_PRIVS view, 5.465
- USER_TAB_PRIVS_MADE view, 5.466
- USER_TAB_PRIVS_RECD view, 5.467
- USER_TAB_STATISTICS view, 5.468
- USER_TAB_STATS_HISTORY view, 5.469
- USER_TAB_SUBPARTITIONS view, 5.470
- USER_TABLES view, 5.471
-
- TABS synonym, 5.249
- USER_TABLESPACES view, 5.472
- USER_TRANSFORMATIONS view, 5.473
- USER_TRIGGER_COLS view, 5.474
- USER_TRIGGERS view, 5.475
- USER_TS_QUOTAS view, 5.476
- USER_TUNE_MVIEW view, 5.477
- USER_TYPE_ATTRS view, 5.478
- USER_TYPE_METHODS view, 5.479
- USER_TYPE_VERSIONS view, 5.480
- USER_TYPES view, 5.481
- USER_UNUSED_COL_TABS view, 5.482
- USER_UPDATABLE_COLUMNS view, 5.483
- USER_USERS view, 5.484
- USER_USTATS view, 5.485
- USER_VARRAYS view, 5.486
- USER_VIEWS view, 5.487
- USER_WARNING_SETTINGS view, 5.488
- 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_SCHEMAS view, 5.489
- USER_XML_TAB_COLS view, 5.490
- USER_XML_TABLES view, 5.491
- USER_XML_VIEW_COLS view, 5.492
- USER_XML_VIEWS view, 5.493
- USERLOCK.SQL script, B.2
- users
-
- authenticating, 1.147
- multiple, 1.64
- UTL_FILE_DIR initialization parameter, 1.225
- UTLBSTAT.SQL script, B.2
- UTLCHN1.SQL script, B.2
- UTLCONST.SQL script, B.2
- UTLDTREE.SQL script, 5.191, 5.211, 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
- UTLU101I.SQL script, B.4
- UTLU101S.SQL script, B.4
- UTLVALID.SQL script, B.2
- UTLXPLAN.SQL script, B.2
V
- V$ACCESS view, 6.3
- V$ACTIVE_INSTANCES view, 6.4
- V$ACTIVE_SERVICES view, 6.5
- V$ACTIVE_SESS_POOL_MTH view, 6.6
- V$ACTIVE_SESSION_HISTORY view, 6.7
- V$ADVISOR_PROGRESS view, 6.8
- V$ALERT_TYPES view, 6.9
- V$AQ view, 6.10
- V$ARCHIVE view, 6.11
- V$ARCHIVE_DEST view, 6.12
- V$ARCHIVE_DEST_STATUS view, 6.13
- V$ARCHIVE_GAP view, 6.14
- V$ARCHIVE_PROCESSES view, 6.15
- V$ARCHIVED_LOG view, 6.16
- V$ASM_ALIAS view, 6.17
- V$ASM_CLIENT view, 6.18
- V$ASM_DISK view, 6.19
- V$ASM_DISK_STAT view, 6.20
- V$ASM_DISKGROUP view, 6.21
- V$ASM_DISKGROUP_STAT view, 6.22
- V$ASM_FILE view, 6.23
- V$ASM_OPERATION view, 6.24
- V$ASM_TEMPLATE view, 6.25
- V$BACKUP view, 6.26
- V$BACKUP_ARCHIVELOG_DETAILS view, 6.27
- V$BACKUP_ARCHIVELOG_SUMMARY view, 6.28
- V$BACKUP_ASYNC_IO view, 6.29
- V$BACKUP_CONTROLFILE_DETAILS view, 6.30
- V$BACKUP_CONTROLFILE_SUMMARY view, 6.31
- V$BACKUP_COPY_DETAILS view, 6.32
- V$BACKUP_COPY_SUMMARY view, 6.33
- V$BACKUP_CORRUPTION view, 6.34
- V$BACKUP_DATAFILE view, 6.35
- V$BACKUP_DATAFILE_DETAILS view, 6.36
- V$BACKUP_DATAFILE_SUMMARY view, 6.37
- V$BACKUP_DEVICE view, 6.38
- V$BACKUP_FILES view, 6.39
- V$BACKUP_PIECE view, 6.40
- V$BACKUP_PIECE_DETAILS view, 6.41
- V$BACKUP_REDOLOG view, 6.42
- V$BACKUP_SET view, 6.43
- V$BACKUP_SET_DETAILS view, 6.44
- V$BACKUP_SET_SUMMARY view, 6.45
- V$BACKUP_SPFILE view, 6.46
- V$BACKUP_SPFILE_DETAILS view, 6.47
- V$BACKUP_SPFILE_SUMMARY view, 6.48
- V$BACKUP_SYNC_IO view, 6.49
- V$BGPROCESS view, 6.50
- V$BH view, 6.51
- V$BLOCK_CHANGE_TRACKING view, 6.52
- V$BLOCKING_QUIESCE view, 6.53
- V$BUFFER_POOL view, 6.54
- V$BUFFER_POOL_STATISTICS view, 6.55
- V$BUFFERED_PUBLISHERS view, 6.56
- V$BUFFERED_QUEUES view, 6.57
- V$BUFFERED_SUBSCRIBERS view, 6.58
- V$CACHE view, 6.59
- V$CACHE_LOCK view, 6.60
- V$CACHE_TRANSFER view, 6.61
- V$CIRCUIT view, 6.62
- V$CLASS_CACHE_TRANSFER view, 6.63
- V$CLIENT_STATS view, 6.64
- V$CLUSTER_INTERCONNECTS view, 6.65
- V$CONFIGURED_INTERCONNECTS view, 6.66
- V$CONTEXT view, 6.67
- V$CONTROLFILE view, 6.68
- V$CONTROLFILE_RECORD_SECTION view, 6.69
- V$COPY_CORRUPTION view, 6.70
- V$CR_BLOCK_SERVER view, 6.71
- V$CURRENT_BLOCK_SERVER view, 6.72
- V$DATABASE view, 6.73
- V$DATABASE_BLOCK_CORRUPTION view, 6.74
- V$DATABASE_INCARNATION view, 6.75
- V$DATAFILE view, 6.76
- V$DATAFILE_COPY view, 6.77
- V$DATAFILE_HEADER view, 6.78
- V$DATAGUARD_CONFIG view, 6.79
- V$DATAGUARD_STATS view, 6.80
- V$DATAGUARD_STATUS view, 6.81
- V$DB_CACHE_ADVICE view, 6.82
- V$DB_OBJECT_CACHE view, 6.83
- V$DB_PIPES view, 6.84
- V$DB_TRANSPORTABLE_PLATFORM view, 6.85
- V$DBFILE view, 6.86
- V$DBLINK view, 6.87
- V$DELETED_OBJECT view, 6.88
- V$DISPATCHER view, 6.89
- V$DISPATCHER_CONFIG view, 6.90
- V$DISPATCHER_RATE view, 6.91
- V$ENABLEDPRIVS view, 6.92
- V$ENQUEUE_LOCK view, 6.93
- V$ENQUEUE_STAT view, 6.94
- V$ENQUEUE_STATISTICS view, 6.95
- V$EVENT_HISTOGRAM view, 6.96
- V$EVENT_NAME view, 6.97
- V$EVENTMETRIC view, 6.98
- V$EXECUTION view, 6.99
- V$FALSE_PING view, 6.100
- V$FAST_START_SERVERS view, 6.101
- V$FAST_START_TRANSACTIONS view, 6.102
- V$FILE_CACHE_TRANSFER view, 6.103
- V$FILE_HISTOGRAM view, 6.104
- V$FILEMETRIC view, 6.105
- V$FILEMETRIC_HISTORY view, 6.106
- V$FILESTAT view, 6.107
- V$FIXED_TABLE view, 6.108
- V$FIXED_VIEW_DEFINITION view, 6.109
- V$FLASH_RECOVERY_AREA_USAGE view, 6.110
- V$FLASHBACK_DATABASE_LOG view, 6.111
- V$FLASHBACK_DATABASE_STAT view, 6.112
- V$GC_ELEMENT view, 6.113
- V$GC_ELEMENTS_WITH_COLLISIONS view, 6.114
- V$GCSHVMASTER_INFO view, 6.115
- V$GCSPFMASTER_INFO view, 6.116
- V$GES_BLOCKING_ENQUEUE view, 6.117
- V$GES_CONVERT_LOCAL view, 6.118
- V$GES_CONVERT_REMOTE view, 6.119
- V$GES_ENQUEUE view, 6.120
- V$GES_LATCH view, 6.121
- V$GES_RESOURCE view, 6.122
- V$GES_STATISTICS view, 6.123
- V$GLOBAL_BLOCKED_LOCKS view, 6.124
- V$GLOBAL_TRANSACTION view, 6.125
- V$HS_AGENT view, 6.126
- V$HS_PARAMETER view, 6.127
- V$HS_SESSION view, 6.128
- V$HVMASTER_INFO view, 6.129
- V$INDEXED_FIXED_COLUMN view, 6.130
- V$INSTANCE view, 6.131
- V$INSTANCE_CACHE_TRANSFER view, 6.132
- V$INSTANCE_RECOVERY view, 6.133
- V$JAVA_LIBRARY_CACHE_MEMORY view, 6.134
- V$JAVA_POOL_ADVICE view, 6.135
- V$LATCH view, 6.136
- V$LATCH_CHILDREN view, 6.137
- V$LATCH_MISSES view, 6.138
- V$LATCH_PARENT view, 6.139
- V$LATCHHOLDER view, 6.140
- V$LATCHNAME view, 6.141
- V$LIBRARY_CACHE_MEMORY view, 6.142
- V$LIBRARYCACHE view, 6.143
- V$LICENSE view, 6.144
- V$LOADISTAT view, 6.145
- V$LOADPSTAT view, 6.146
- V$LOCK view, 6.147
- V$LOCK_ACTIVITY view, 6.148
- V$LOCKED_OBJECT view, 6.149
- V$LOG view, 6.150
- V$LOG_HISTORY view, 6.151
- V$LOGFILE view, 6.152
- V$LOGHIST view, 6.153
- V$LOGMNR_CONTENTS view, 6.154
- V$LOGMNR_DICTIONARY view, 6.155
- V$LOGMNR_DICTIONARY_LOAD view, 6.156
- V$LOGMNR_LATCH view, 6.157
- V$LOGMNR_LOGS view, 6.158
- V$LOGMNR_PARAMETERS view, 6.159
- V$LOGMNR_PROCESS view, 6.160
- V$LOGMNR_SESSION view, 6.161
- V$LOGMNR_STATS view, 6.162
- V$LOGSTDBY view, 6.163
- V$LOGSTDBY_PROCESS view, 6.164
- V$LOGSTDBY_PROGRESS view, 6.165
- V$LOGSTDBY_STATE view, 6.166
- V$LOGSTDBY_STATS view, 6.167
- V$LOGSTDBY_TRANSACTION view, 6.168
- V$MANAGED_STANDBY view, 6.169
- V$MAP_COMP_LIST view, 6.170
- V$MAP_ELEMENT view, 6.171
- V$MAP_EXT_ELEMENT view, 6.172
- V$MAP_FILE view, 6.173
- V$MAP_FILE_EXTENT view, 6.174
- V$MAP_FILE_IO_STACK view, 6.175
- V$MAP_LIBRARY view, 6.176
- V$MAP_SUBELEMENT view, 6.177
- V$METRICNAME view, 6.178
- V$MTTR_TARGET_ADVICE view, 6.179
- V$MUTEX_SLEEP view, 6.180
- V$MUTEX_SLEEP_HISTORY view, 6.181
- V$MVREFRESH view, 6.182
- V$MYSTAT view, 6.183
- V$NLS_PARAMETERS view, 7.1
- V$NLS_VALID_VALUES view, 7.2
- V$OBJECT_DEPENDENCY view, 7.3
- V$OBJECT_USAGE view, 7.4
- V$OBSOLETE_BACKUP_FILES view, 7.5
- V$OBSOLETE_PARAMETER view, 7.6
- V$OFFLINE_RANGE view, 7.7
- V$OPEN_CURSOR view, 7.8
- V$OPTION view, 7.9
- V$OSSTAT view, 7.10
- V$PARALLEL_DEGREE_LIMIT_MTH view, 7.11
- V$PARAMETER view, 7.12
- V$PARAMETER_VALID_VALUES view, 7.13
- V$PARAMETER2 view, 7.14
- V$PGA_TARGET_ADVICE view, 7.15
- V$PGA_TARGET_ADVICE_HISTOGRAM view, 7.16
- V$PGASTAT view, 7.17
- V$PQ_SESSTAT view, 7.18
- V$PQ_SLAVE view, 7.19
- V$PQ_SYSSTAT view, 7.20
- V$PQ_TQSTAT view, 7.21
- V$PROCESS view, 7.22
- V$PROCESS_MEMORY view, 7.23
- V$PROPAGATION_RECEIVER view, 7.24
- V$PROPAGATION_SENDER view, 7.25
- V$PROXY_ARCHIVEDLOG view, 7.26
- V$PROXY_ARCHIVELOG_DETAILS view, 7.27
- V$PROXY_ARCHIVELOG_SUMMARY view, 7.28
- V$PROXY_COPY_DETAILS view, 7.29
- V$PROXY_COPY_SUMMARY view, 7.30
- V$PROXY_DATAFILE view, 7.31
- V$PWFILE_USERS view, 7.32
- V$PX_PROCESS view, 7.33
- V$PX_PROCESS_SYSSTAT view, 7.34
- V$PX_SESSION view, 7.35
- V$PX_SESSTAT view, 7.36
- V$QUEUE view, 7.37
- V$QUEUEING_MTH view, 7.38
- V$RECOVER_FILE view, 7.39
- V$RECOVERY_FILE_DEST view, 7.40
- V$RECOVERY_FILE_STATUS view, 7.41
- V$RECOVERY_LOG view, 7.42
- V$RECOVERY_PROGRESS view, 7.43
- V$RECOVERY_STATUS view, 7.44
- V$REPLPROP view, 7.45
- V$REPLQUEUE view, 7.46
- V$REQDIST view, 7.47
- V$RESERVED_WORDS view, 7.48
- V$RESOURCE view, 7.49
- V$RESOURCE_LIMIT view, 7.50
- V$RESTORE_POINT view, 7.51
- V$RMAN_BACKUP_JOB_DETAILS view, 7.52
- V$RMAN_BACKUP_SUBJOB_DETAILS view, 7.53
- V$RMAN_BACKUP_TYPE view, 7.54
- V$RMAN_CONFIGURATION view, 7.55
- V$RMAN_ENCRYPTION_ALGORITHMS view, 7.56
- V$RMAN_OUTPUT view, 7.57
- V$RMAN_STATUS view, 7.58
- V$ROLLNAME view, 7.59
- V$ROLLSTAT view, 7.60
- V$ROWCACHE view, 7.61
- V$ROWCACHE_PARENT view, 7.62
- V$ROWCACHE_SUBORDINATE view, 7.63
- V$RSRC_CONS_GROUP_HISTORY view, 7.64
- V$RSRC_CONSUMER_GROUP view, 7.65
- V$RSRC_CONSUMER_GROUP_CPU_MTH view, 7.66
- V$RSRC_PLAN view, 7.67
- V$RSRC_PLAN_CPU_MTH view, 7.68
- V$RSRC_PLAN_HISTORY view, 7.69
- V$RSRC_SESSION_INFO view, 7.70
- V$RULE view, 7.71
- V$RULE_SET view, 7.72
- V$RULE_SET_AGGREGATE_STATS view, 7.73
- V$SCHEDULER_RUNNING_JOBS view, 7.74
- V$SEGMENT_STATISTICS view, 7.75
- V$SEGSTAT view, 7.76
- V$SEGSTAT_NAME view, 7.77
- V$SERV_MOD_ACT_STATS view, 7.78
- V$SERVICE_EVENT view, 7.79
- V$SERVICE_STATS view, 7.80
- V$SERVICE_WAIT_CLASS view, 7.81
- V$SERVICEMETRIC view, 7.82
- V$SERVICEMETRIC_HISTORY view, 7.83
- V$SERVICES view, 7.84
- V$SES_OPTIMIZER_ENV view, 7.85
- V$SESS_IO view, 7.86
- V$SESS_TIME_MODEL view, 7.87
- V$SESSION view, 7.88
- V$SESSION_CONNECT_INFO view, 7.89
- V$SESSION_CURSOR_CACHE view, 7.90
- V$SESSION_EVENT view, 7.91, C
- V$SESSION_LONGOPS view, 7.92
- V$SESSION_OBJECT_CACHE view, 7.93
- V$SESSION_WAIT view, 7.94, C
- V$SESSION_WAIT_CLASS view, 7.95
- V$SESSION_WAIT_HISTORY view, 7.96
- V$SESSMETRIC view, 7.97
- V$SESSTAT view, 7.98, E, E.1
- V$SGA view, 7.99
- V$SGA_CURRENT_RESIZE_OPS view, 7.100
- V$SGA_DYNAMIC_COMPONENTS view, 7.101
- V$SGA_DYNAMIC_FREE_MEMORY view, 7.102
- V$SGA_RESIZE_OPS view, 7.103
- V$SGA_TARGET_ADVICE view, 7.104
- V$SGAINFO view, 7.105
- V$SGASTAT view, 7.106
- V$SHARED_POOL_ADVICE view, 7.107, 7.141
- V$SHARED_POOL_RESERVED view, 7.108
- V$SHARED_SERVER view, 7.109
- V$SHARED_SERVER_MONITOR view, 7.110
- V$SORT_SEGMENT view, 7.111
- V$SPPARAMETER view, 7.112
- V$SQL view, 7.113
- V$SQL_BIND_CAPTURE view, 7.114
- V$SQL_BIND_DATA view, 7.115
- V$SQL_BIND_METADATA view, 7.116
- V$SQL_CURSOR view, 7.117
- V$SQL_JOIN_FILTER view, 7.118
- V$SQL_OPTIMIZER_ENV view, 7.119
- V$SQL_PLAN view, 7.120
- V$SQL_PLAN_STATISTICS view, 7.121
- V$SQL_PLAN_STATISTICS_ALL view, 7.122
- V$SQL_REDIRECTION view, 7.123
- V$SQL_SHARED_CURSOR view, 7.124
- V$SQL_SHARED_MEMORY view, 7.125
- V$SQL_WORKAREA view, 7.126
- V$SQL_WORKAREA_ACTIVE view, 7.127
- V$SQL_WORKAREA_HISTOGRAM view, 7.128
- V$SQLAREA view, 7.129
- V$SQLAREA_PLAN_HASH view, 7.130
- V$SQLSTATS view, 7.131
- V$SQLTEXT view, 7.132
- V$SQLTEXT_WITH_NEWLINES view, 7.133
- V$STANDBY_LOG view, 7.134
- V$STATISTICS_LEVEL view, 7.135
- V$STATNAME view, 7.136, E.1
- V$STREAMS_APPLY_COORDINATOR view, 7.137
- V$STREAMS_APPLY_READER view, 7.138
- V$STREAMS_APPLY_SERVER view, 7.139
- V$STREAMS_CAPTURE view, 7.140
- V$STREAMS_TRANSACTION view, 7.142
- V$SUBCACHE view, 7.143
- V$SYS_OPTIMIZER_ENV view, 7.144
- V$SYS_TIME_MODEL view, 7.145
- V$SYSAUX_OCCUPANTS view, 7.146
- V$SYSMETRIC view, 7.147
- V$SYSMETRIC_HISTORY view, 7.148
- V$SYSMETRIC_SUMMARY view, 7.149
- V$SYSSTAT view, 7.150, E
- V$SYSTEM_CURSOR_CACHE view, 7.151
- V$SYSTEM_EVENT view, 7.152, C
- V$SYSTEM_PARAMETER view, 7.153
- V$SYSTEM_PARAMETER2 view, 7.154
- V$SYSTEM_WAIT_CLASS view, 7.155
- V$TABLESPACE view, 7.156
- V$TEMP_CACHE_TRANSFER view, 7.157
- V$TEMP_EXTENT_MAP view, 7.158
- V$TEMP_EXTENT_POOL view, 7.159
- V$TEMP_HISTOGRAM view, 7.160
- V$TEMP_SPACE_HEADER view, 7.161
- V$TEMPFILE view, 7.162
- V$TEMPORARY_LOBS view, 7.163
- V$TEMPSEG_USAGE view, 7.164
- V$TEMPSTAT view, 7.165
- V$THREAD view, 7.166
- V$THRESHOLD_TYPES view, 7.167
- V$TIMER view, 7.168
- V$TIMEZONE_NAMES view, 7.169
- V$TRANSACTION view, 7.170
- V$TRANSACTION_ENQUEUE view, 7.171
- V$TRANSPORTABLE_PLATFORM view, 7.172
- V$TYPE_SIZE view, 7.173
- V$UNDOSTAT view, 7.174
- V$UNUSABLE_BACKUPFILE_DETAILS view, 7.175
- V$VERSION view, 7.176
- V$VPD_POLICY view, 7.177
- V$WAITCLASSMETRIC view, 7.178
- V$WAITCLASSMETRIC_HISTORY view, 7.179
- V$WAITSTAT view, 7.180
- V$WALLET view, 7.181
- V$XML_AUDIT_TRAIL view, 7.182
- views
-
- data dictionary views, 2
- datafiles, 1.74
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
- mutex X, C.3.24
- pin S, C.3.25
- pin S wait on X, C.3.26
- pin X, C.3.27
- Daa Guard Broker
-
- process exit, C.3.29
- Data Guard
-
- process cleanup, C.3.28
- Data Guard Broker
-
- single instance, C.3.30
- 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 write, C.3.39
- dispatcher shutdown, C.3.40
- dispatcher timer, C.3.41
- duplicate cluster key, C.3.42
- enq
-
- OW - initialization, C.3.43
- OW - termination, C.3.44
- enqueue, C.3.45
- flashback buf free by RVWR, C.3.46
- free buffer waits, C.3.47
- free global transaction table entry, C.3.48
- free process state object, C.3.49
- GCS lock open S, C.3.50
- GCS lock open X, C.3.51
- gcs remastering wait for drop pkey, C.3.52
- global cache busy, C.3.53
- global cache freelist, C.3.55
- global cache lock cleanup, C.3.54
- inactive session, C.3.56
- inactive transaction branch, C.3.57
- index block split, C.3.58
- instance state change, C.3.59
- io done, C.3.60
- kcl bg acks, C.3.61
- ksxr wait for mount shared, C.3.62
- ktm
-
- instance recovery, C.3.63
- latch activity, C.3.64
- latch free, C.3.65
- library cache load lock, C.3.66
- library cache lock, C.3.67
- library cache pin, C.3.68
- LMON global data update, C.3.70
- lock manager wait for remote message, C.3.71
- log buffer space, C.3.72
- log file parallel write, C.3.73
- log file sequential read, C.3.74
- log file single write, C.3.75
- log file switch (archiving needed), C.3.76
- log file switch (checkpoint incomplete), C.3.77
- log file switch (clearing log file), C.3.78
- log file switch (private strand flush incomplete), C.3.79
- log file switch completion, C.3.80
- log file sync, C.3.81
- log switch/archive, C.3.82
- optimizer stats update retry, C.3.83
- pending global transaction(s), C.3.84
- pipe get, C.3.85
- pipe put, C.3.86
- PL/SQL lock timer, C.3.87
- pmon timer, C.3.88
- prewarm transfer retry, C.3.89
- prior process spawner to be cleaned up, C.3.90
- process startup, C.3.91
- PX dequeue wait, C.3.92
- PX qref latch, C.3.93
- PX server shutdown, C.3.94
- PX signal server, C.3.95
- rdbms ipc message, C.3.97
- rdbms ipc message block, C.3.98
- rdbms ipc reply, C.3.99
- read by other session, C.3.100
- resmgr
-
- become active, C.3.101
- cpu quantum, C.3.102
- rolling migration
-
- cluster quisce, C.3.103
- row cache lock, C.3.104
- sbtbufinfo, C.3.105
- sbtgetbuf, C.3.106
- sbtmapbuf, C.3.107
- sbtrelbuf, C.3.108
- scginq AST call, C.3.109
- SGA
-
- allocation forcing component growth, C.3.110
- MMAN sleep for component shrink, C.3.111
- sga_target resize, C.3.112
- single-task message, C.3.113
- smon timer, C.3.114
- SQL*Net break/reset to client, C.3.115
- SQL*Net break/reset to dblink, C.3.116
- SQL*Net message from client, C.3.117
- SQL*Net message from dblink, C.3.118
- SQL*Net message to client, C.3.119
- SQL*Net message to dblink, C.3.120
- SQL*Net more data from client, C.3.121
- SQL*Net more data from dblink, C.3.122
- SQL*Net more data to client, C.3.123
- SQL*Net more data to dblink, C.3.124
- Streams AQ
-
- waiting for messages in the queue, C.3.96
- switch logfile command, C.3.125
- timer in sksawat, C.3.126
- transaction, C.3.127
- unbound tx, C.3.128
- undo segment extension, C.3.130
- undo segment recovery, C.3.131
- undo segment tx slot, C.3.132
- undo_retention publish retry, C.3.129
- virtual circuit status, C.3.133
- WMON goes to sleep, C.3.134
- write complete waits, C.3.135
- writes stopped by instance recovery or database suspension, C.3.136
- WM_INSTALLATION view, 2.1.2
- WM_REPLICATION_INFO view, 2.1.2
- WORKAREA_SIZE_POLICY initialization parameter, 1.226
