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.214

ENABLE THREAD, 1.214

THREAD, 1.214

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.372, 5.461, 5.462, 5.473

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.180

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.281

audit trails for connections and disconnections, 5.284

auditing characteristics described by, 5.374

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.197

---

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.183, 1.184

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_WORKLOAD_CAPTURES view, 5.180

DBA_WORKLOAD_FILTERS view, 5.181

DBA_WORKSPACE_SESSIONS view, 2.1.2

DBA_XML_SCHEMAS view, 5.182

DBA_XML_TAB_COLS view, 5.183

DBA_XML_TABLES view, 5.184

DBA_XML_VIEW_COLS view, 5.185

DBA_XML_VIEWS view, 5.190

DBMS_ALERT_INFO view, 5.191

DBMS_LOCK_ALLOCATED view, 5.192

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.193

destination

archiving redo log files, 1.99

overriding default, 1.99

USER_DUMP_DEST, 1.225

DG_BROKER_CONFIG_FILEn initialization parameter, 1.59

DG_BROKER_START initialization parameter, 1.60

DICT synonym for DICTIONARY, 5.194

DICT_COLUMNS view, 5.195

DICTIONARY view, 5.196

DICT synonym, 5.194

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.172

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.172

ERROR_SIZE view, 5.197

EVENT initialization parameter, 1.65

EXCEPTIONS view, 5.198

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.186

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.187

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.188

HS_ALL_DD view, 5.189

HS_ALL_INITS view, 5.199

HS_AUTOREGISTER initialization parameter, 1.80

HS_BASE_CAPS view, 5.200

HS_BASE_DD view, 5.201

HS_CLASS_CAPS view, 5.202

HS_CLASS_DD view, 5.203

HS_CLASS_INIT view, 5.204

HS_EXTERNAL_OBJECT_PRIVILEGES view, 5.205

HS_EXTERNAL_OBJECTS view, 5.206

HS_EXTERNAL_USER_PRIVILEGES view, 5.207

HS_FDS_CLASS view, 5.208

HS_FDS_INST view, 5.209

HS_INST_CAPS view, 5.210

HS_INST_DD view, 5.211

HS_INST_INIT view, 5.212

---

I

IDEPTREE view, 5.213

IFILE initialization parameter, 1.3.2.1.1, 1.81

IND synonym for USER_INDEXES view, 5.214

INDEX_HISTOGRAM view, 5.215

INDEX_STATS view, 5.216

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_11G_ENABLE_CAPTURE, 1.167

PRE_PAGE_SGA, 1.168

PROCESSES, 1.169

QUERY_REWRITE_ENABLED, 1.170

QUERY_REWRITE_INTEGRITY, 1.171

RDBMS_SERVER_DN, 1.172

READ_ONLY_OPEN_DELAYED, 1.173

RECOVERY_PARALLELISM, 1.174

RECYCLEBIN, 1.175

REMOTE_ARCHIVE_ENABLE, 1.176

REMOTE_DEPENDENCIES_MODE, 1.177

REMOTE_LISTENER, 1.178

REMOTE_LOGIN_PASSWORDFILE, 1.179

REMOTE_OS_AUTHENT, 1.180

REMOTE_OS_ROLES, 1.181

REPLICATION_DEPENDENCY_TRACKING, 1.182

RESOURCE_LIMIT, 1.183

RESOURCE_MANAGER_PLAN, 1.184

RESUMABLE_TIMEOUT, 1.185

ROLLBACK_SEGMENTS, 1.186

SERIAL_REUSE, 1.187

SERVICE_NAMES, 1.188

SESSION_CACHED_CURSORS, 1.189

SESSION_MAX_OPEN_FILES, 1.190

SESSIONS, 1.191

SGA_MAX_SIZE, 1.192

SGA_TARGET, 1.193

SHADOW_CORE_DUMP, 1.194

SHARED_MEMORY_ADDRESS, 1.195

SHARED_POOL_RESERVED_SIZE, 1.196

SHARED_POOL_SIZE, 1.197

SHARED_SERVER_SESSIONS, 1.198

SHARED_SERVERS, 1.199

SKIP_UNUSABLE_INDEXES, 1.200

SMTP_OUT_SERVER, 1.201

SORT_AREA_RETAINED_SIZE, 1.202

SORT_AREA_SIZE, 1.203

specifying in initialization parameter files, 1.3.2.1

SPFILE, 1.204

SQL_TRACE, 1.205

SQL92_SECURITY, 1.206

SQLTUNE_CATEGORY, 1.207

STANDBY_ARCHIVE_DEST, 1.208

STANDBY_FILE_MANAGEMENT, 1.209

STAR_TRANSFORMATION_ENABLED, 1.210

STATISTICS_LEVEL, 1.211

STREAMS_POOL_SIZE, 1.212

TAPE_ASYNCH_IO, 1.213

THREAD, 1.214

TIMED_OS_STATISTICS, 1.215

TIMED_STATISTICS, 1.216

TRACE_ENABLED, 1.217

TRACEFILE_IDENTIFIER, 1.218

TRANSACTIONS, 1.219

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.220

UNDO_MANAGEMENT, 1.221

UNDO_RETENTION, 1.222

UNDO_TABLESPACE, 1.223

USE_INDIRECT_DATA_BUFFERS, 1.224

USER_DUMP_DEST, 1.225

UTL_FILE_DIR, 1.226

variable, 1.1.1.3

WORKAREA_SIZE_POLICY, 1.227

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.217

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.202

virtual, 1.1.1.3

monitor

performance, 1.109

multiple-process systems

number of processes, 1.169

---

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.218

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.219

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.220

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.221

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.180

authenticating users and passwords, 1.147

dependent parameters, 1.1.1.2

roles for remote clients, 1.181

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.180

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.179

PCM lock

mapping blocks to, 1.74

performance, 1.1.1.3

shared pool, 1.197

PGA_AGGREGATE_TARGET initialization parameter, 1.157

PLAN_TABLE table, 5.222

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.223

PRE_11G_ENABLE_CAPTURE initialization parameter, 1.167

PRE_PAGE_SGA initialization parameter, 1.168

privileges

remote login, 1.179

RESTRICTED_SESSION privilege, 1.92, 1.94

table-level select privileges, 1.206

procedures

shared pool, 1.197

processes

derived parameter values, 1.219

dispatcher process maximum number, 1.115

maximum shared server processes, 1.118

number of server processes, 1.86, 1.88, 1.198, 1.199

recovery, 1.174

trace files, 1.225

user processes, 1.169

PROCESSES initialization parameter, 1.169

PRODUCT_COMPONENT_VERSION view, 5.224

profiles

resource limits, 1.183, 1.184

PROXY_USERS view, 5.225

PSTUBTBL view, 5.226

PUBLIC clause

of ALTER DATABASE

thread of redo, 1.214

PUBLIC_DEPENDENCY view, 5.227

PUBLICSYN view, 5.228

---

Q

queries

dictionary views, 1.74

hints, 1.145

QUERY_REWRITE_ENABLED initialization parameter, 1.170

QUERY_REWRITE_INTEGRITY initialization parameter, 1.171

QUEUE_PRIVILEGES view, 5.229

---

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.172

READ_ONLY_OPEN_DELAYED initialization parameter, 1.173

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.174

RECOVERY_PARALLELISM initialization parameter, 1.174

RECYCLEBIN initialization parameter, 1.175

RECYCLEBIN synonym for USER_RECYCLEBIN view, 5.230

redo logs

buffer size, 1.108

redo thread, 1.214

remote clients

authenticating, 1.180

remote logins, 1.179

REMOTE_ARCHIVE_ENABLE initialization parameter, 1.176

REMOTE_DEPENDENCIES_MODE initialization parameter, 1.177

REMOTE_LISTENER initialization parameter, 1.178

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.179

REMOTE_OS_AUTHENT initialization parameter, 1.180

REMOTE_OS_ROLES initialization parameter, 1.181

REPAIR_TABLE view. See DBA_REPAIR_TABLE view.

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.182

resource limits for profiles, 1.183, 1.184

RESOURCE_COST view, 5.231

RESOURCE_LIMIT initialization parameter, 1.183

RESOURCE_MANAGER_PLAN initialization parameter, 1.184

RESOURCE_MAP table, 5.232

RESUMABLE_TIMEOUT initialization parameter, 1.185

RMJVM.SQL script, B.5

ROLE_ROLE_PRIVS view, 5.233

ROLE_SYS_PRIVS view, 5.234

ROLE_TAB_PRIVS view, 5.235

ROLE_WM_PRIVS view, 2.1.2

roles, 1.148

remote clients, 1.181

ROLLBACK_SEGMENTS initialization parameter, 1.186

---

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.236

SERIAL_REUSE initialization parameter, 1.187

server parameter file

overview, 1.3

server processes

number, 1.86, 1.88, 1.198, 1.199

SERVICE_NAMES initialization parameter, 1.188

SESSION_CACHED_CURSORS initialization parameter, 1.189

SESSION_CONTEXT view, 5.237

SESSION_MAX_OPEN_FILES initialization parameter, 1.190

SESSION_PRIVS view, 5.238

SESSION_ROLES view, 5.239

SESSIONS initialization parameter, 1.191

SGA_MAX_SIZE initialization parameter, 1.192

SGA_TARGET initialization parameter, 1.193

SHADOW_CORE_DUMP initialization parameter, 1.194

shared server

SESSIONS initialization parameter, 1.191

shared server processes

maximum number, 1.118

SHARED_MEMORY_ADDRESS initialization parameter, 1.195

SHARED_POOL_RESERVED_SIZE initialization parameter, 1.196

SHARED_POOL_SIZE initialization parameter, 1.197

SHARED_SERVER_SESSIONS initialization parameter, 1.198

SHARED_SERVERS initialization parameter, 1.199

SHOW PARAMETERS command, 1.4.3

SKIP_UNUSABLE_INDEXES initialization parameter, 1.200

SMTP_OUT_SERVER initialization parameter, 1.201

SORT_AREA_RETAINED_SIZE initialization parameter, 1.202

SORT_AREA_SIZE initialization parameter, 1.203

sorting

maximum memory, 1.202

ORDER BY queries, 1.130

SOURCE_SIZE view, 5.240

SPFILE initialization parameter, 1.204

SQL scripts

creating the data dictionary, B.1

optional, B.2

required, B.1

SQL_TRACE initialization parameter, 1.205

SQL92_SECURITY initialization parameter, 1.206

SQLTUNE_CATEGORY initialization parameter, 1.207

STANDBY_ARCHIVE_DEST initialization parameter, 1.208

STANDBY_FILE_MANAGEMENT initialization parameter, 1.209

STAR_TRANSFORMATION_ENABLED initialization parameter, 1.210

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.216

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.211

STMT_AUDIT_OPTION_MAP table, 5.241

STREAMS_POOL_SIZE initialization parameter, 1.212

switch redo log file, 1.109

SYN synonym for USER_SYNONYMS view, 5.242

SYNONYMS view, 5.243

SYS_OBJECTS view, 5.248

SYSCATALOG view, 5.244

SYSFILES view, 5.245

SYSSEGOBJ view, 5.246

system global area, 1.1.1.3

buffer areas, 1.108

maximum concurrent transactions, 1.219

system performance, 1.1.1.3

SYSTEM_PRIVILEGE_MAP table, 5.247

---

T

TAB view, 5.249

TABLE_PRIVILEGE_MAP table, 5.250

tables

data dictionary, 2.1

DML locks, 1.64

locating free space, 1.84

TABQUOTAS view, 5.252

TABS synonym for USER_TABLES view, 5.251

tape archiving destination, 1.99

TAPE_ASYNCH_IO initialization parameter, 1.213

territory, 1.124, 1.131

THREAD initialization parameter, 1.214

TIMED_OS_STATISTICS initialization parameter, 1.215

TIMED_STATISTICS initialization parameter, 1.216

file read/write statistics, 6.107, 7.165

TO_CHAR function, 1.122

TO_DATE function, 1.122

trace files

destination, 1.225

maximum size, 1.116

TRACE_ENABLED initialization parameter, 1.217

TRACEFILE_IDENTIFIER initialization parameter, 1.218

transactions

concurrent, 1.219

data locking, 1.64

TRANSACTIONS initialization parameter, 1.219

DML locks, 1.64

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.220

TRUSTED_SERVERS view, 5.253

TS_PITR_CHECK view, 5.254

TS_PITR_OBJECTS TO_BE_DROPPED view, 5.255

---

U

UNDO_MANAGEMENT initialization parameter, 1.221

UNDO_RETENTION initialization parameter, 1.222

UNDO_TABLESPACE initialization parameter, 1.223

UNI_PLUGGABLE_SET_CHECK view, 5.256

updates

locating free space, 1.84

upgrading

scripts, B.4

uppercase characters, 1.3.2.1.1

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.224

user processes

trace files, 1.225

USER_ADVISOR_ACTIONS view, 5.257

USER_ADVISOR_FINDINGS view, 5.258

USER_ADVISOR_JOURNAL view, 5.259

USER_ADVISOR_LOG view, 5.260

USER_ADVISOR_OBJECTS view, 5.261

USER_ADVISOR_PARAMETERS view, 5.262

USER_ADVISOR_RATIONALE view, 5.263

USER_ADVISOR_RECOMMENDATIONS view, 5.264

USER_ADVISOR_SQLA_REC_SUM view, 5.265

USER_ADVISOR_SQLA_WK_MAP view, 5.266

USER_ADVISOR_SQLA_WK_STMTS view, 5.267

USER_ADVISOR_SQLW_JOURNAL view, 5.268

USER_ADVISOR_SQLW_PARAMETERS view, 5.269

USER_ADVISOR_SQLW_STMTS view, 5.270

USER_ADVISOR_SQLW_SUM view, 5.271

USER_ADVISOR_SQLW_TABLES view, 5.272

USER_ADVISOR_SQLW_TEMPLATES view, 5.273

USER_ADVISOR_TASKS view, 5.274

USER_ADVISOR_TEMPLATES view, 5.275

USER_ALL_TABLES view, 5.276

USER_AQ_AGENT_PRIVS view, 5.277

USER_ARGUMENTS view, 5.278

USER_ASSOCIATIONS view, 5.279

USER_ATTRIBUTE_TRANSFORMATIONS view, 5.280

USER_AUDIT_OBJECT view, 5.281

USER_AUDIT_POLICIES view, 5.282

USER_AUDIT_POLICY_COLUMNS view, 5.283

USER_AUDIT_SESSION view, 5.284

USER_AUDIT_STATEMENT view, 5.285

USER_AUDIT_TRAIL view, 5.286

USER_AW_PS view, 5.287

USER_AWS view, 5.288

USER_BASE_TABLE_MVIEWS view, 5.289

USER_CATALOG view, 5.290

CAT synonym, 3.126

USER_CHANGE_NOTIFICATION_REGS view, 5.291

USER_CLU_COLUMNS view, 5.292

USER_CLUSTER_HASH_EXPRESSIONS view, 5.293

USER_CLUSTERS view, 5.294

CLU synonym, 3.133

USER_COL_COMMENTS view, 5.295

USER_COL_PRIVS view, 5.296

USER_COL_PRIVS_MADE view, 5.297

USER_COL_PRIVS_RECD view, 5.298

USER_COLL_TYPES view, 5.299

USER_CONS_COLUMNS view, 5.300

USER_CONS_OBJ_COLUMNS view, 5.301

USER_CONSTRAINTS view, 5.302

USER_DATAPUMP_JOBS view, 5.303

USER_DB_LINKS view, 5.304

USER_DEPENDENCIES view, 5.305

USER_DIM_ATTRIBUTES view, 5.306

USER_DIM_CHILD_OF view, 5.307

USER_DIM_HIERARCHIES view, 5.308

USER_DIM_JOIN_KEY view, 5.309

USER_DIM_LEVEL_KEY view, 5.310

USER_DIM_LEVELS view, 5.311

USER_DIMENSIONS view, 5.312

USER_DUMP_DEST initialization parameter, 1.225

USER_ENCRYPTED_COLUMNS view, 5.313

USER_EPG_DAD_AUTHORIZATION view, 5.314

USER_ERRORS view, 5.315

USER_EVALUATION_CONTEXT_TABLES view, 5.316

USER_EVALUATION_CONTEXT_VARS view, 5.317

USER_EVALUATION_CONTEXTS view, 5.318

USER_EXTENTS view, 5.319

USER_EXTERNAL_LOCATIONS view, 5.320

USER_EXTERNAL_TABLES view, 5.321

USER_FILE_GROUP_EXPORT_INFO view, 5.322

USER_FILE_GROUP_FILES view, 5.323

USER_FILE_GROUP_TABLES view, 5.324

USER_FILE_GROUP_TABLESPACES view, 5.325

USER_FILE_GROUP_VERSIONS view, 5.326

USER_FILE_GROUPS view, 5.327

USER_FREE_SPACE view, 5.328

USER_IND_COLUMNS view, 5.329

USER_IND_EXPRESSIONS view, 5.330

USER_IND_PARTITIONS view, 5.331

USER_IND_STATISTICS view, 5.332

USER_IND_SUBPARTITIONS view, 5.333

USER_INDEXES view, 5.334

IND synonym, 5.214

USER_INDEXTYPE_ARRAYTYPES view, 5.335

USER_INDEXTYPE_COMMENTS view, 5.336

USER_INDEXTYPE_OPERATORS view, 5.337

USER_INDEXTYPES view, 5.338

USER_INTERNAL_TRIGGERS view, 5.339

USER_JAVA_ARGUMENTS view, 5.340

USER_JAVA_CLASSES view, 5.341

USER_JAVA_DERIVATIONS view, 5.342

USER_JAVA_FIELDS view, 5.343

USER_JAVA_IMPLEMENTS view, 5.344

USER_JAVA_INNERS view, 5.345

USER_JAVA_LAYOUTS view, 5.346

USER_JAVA_METHODS view, 5.347

USER_JAVA_NCOMPS view, 5.348

USER_JAVA_POLICY view, 5.349

USER_JAVA_RESOLVERS view, 5.350

USER_JAVA_THROWS view, 5.351

USER_JOBS view, 5.352

USER_JOIN_IND_COLUMNS view, 5.353, 5.353

USER_LIBRARIES view, 5.354

USER_LOB_PARTITIONS view, 5.355

USER_LOB_SUBPARTITIONS view, 5.356

USER_LOB_TEMPLATES view, 5.357

USER_LOBS view, 5.358

USER_LOG_GROUP_COLUMNS view, 5.359

USER_LOG_GROUPS view, 5.360

USER_METHOD_PARAMS view, 5.361

USER_METHOD_RESULTS view, 5.362

USER_MVIEW_AGGREGATES view, 5.363

USER_MVIEW_ANALYSIS view, 5.364

USER_MVIEW_COMMENTS view, 5.365

USER_MVIEW_DETAIL_RELATIONS view, 5.366

USER_MVIEW_JOINS view, 5.367

USER_MVIEW_KEYS view, 5.368

USER_MVIEW_LOGS view, 5.369

USER_MVIEW_REFRESH_TIMES view, 5.370

USER_MVIEWS view, 5.371

USER_NESTED_TABLE_COLS view, 5.372

USER_NESTED_TABLES view, 5.373

USER_OBJ_AUDIT_OPTS view, 5.374

USER_OBJ_COLATTRS view, 5.375

USER_OBJECT_SIZE view, 5.376

USER_OBJECT_TABLES view, 5.377

USER_OBJECTS view, 5.378

OBJ synonym, 5.221

USER_OPANCILLARY view, 5.379

USER_OPARGUMENTS view, 5.380

USER_OPBINDINGS view, 5.381

USER_OPERATOR_COMMENTS view, 5.382

USER_OPERATORS view, 5.383

USER_OUTLINE_HINTS view, 5.384

USER_OUTLINES view, 5.385

USER_PART_COL_STATISTICS view, 5.386

USER_PART_HISTOGRAMS view, 5.387

USER_PART_INDEXES view, 5.388

USER_PART_KEY_COLUMNS view, 5.389

USER_PART_LOBS view, 5.390

USER_PART_TABLES view, 5.391

USER_PARTIAL_DROP_TABS view, 5.392

USER_PASSWORD_LIMITS view, 5.393

USER_PENDING_CONV_TABLES view, 5.394

USER_PLSQL_OBJECT_SETTINGS view, 5.395

USER_POLICIES view, 5.396

USER_POLICY_CONTEXTS view, 5.397

USER_POLICY_GROUPS view, 5.398

USER_PROCEDURES view, 5.399

USER_PROXIES view, 5.400

USER_PUBLISHED_COLUMNS view, 5.401

USER_QUEUE_SCHEDULES view, 5.402

USER_QUEUE_SUBSCRIBERS view, 5.403

USER_QUEUE_TABLES view, 5.404

USER_QUEUES view, 5.405

USER_RECYCLEBIN view, 5.406

RECYCLEBIN synonym, 5.230

USER_REFRESH view, 5.407

USER_REFRESH_CHILDREN view, 5.408

USER_REFS view, 5.409

USER_REGISTERED_MVIEWS view, 5.410

USER_REGISTRY view, 5.411

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.412

USER_RESUMABLE view, 5.413

USER_REWRITE_EQUIVALENCES view, 5.414

USER_ROLE_PRIVS view, 5.415

USER_RSRC_CONSUMER_GROUP_PRIVS view, 5.416

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 5.417

USER_RULE_SET_RULES view, 5.418

USER_RULE_SETS view, 5.419

USER_RULES view, 5.420

USER_SCHEDULER_CHAIN_RULES view, 5.421

USER_SCHEDULER_CHAIN_STEPS view, 5.422

USER_SCHEDULER_CHAINS view, 5.423

USER_SCHEDULER_JOB_ARGS view, 5.424

USER_SCHEDULER_JOB_LOG view, 5.425

USER_SCHEDULER_JOB_RUN_DETAILS view, 5.426

USER_SCHEDULER_JOBS view, 5.427

USER_SCHEDULER_PROGRAM_ARGS view, 5.428

USER_SCHEDULER_PROGRAMS view, 5.429

USER_SCHEDULER_RUNNING_CHAINS view, 5.430

USER_SCHEDULER_RUNNING_JOBS view, 5.431

USER_SCHEDULER_SCHEDULES view, 5.432

USER_SEC_RELEVANT_COLS view, 5.433

USER_SEGMENTS view, 5.434

USER_SEQUENCES view, 5.435

SEQ synonym, 5.236

USER_SOURCE view, 5.436

USER_SOURCE_TABLES view, 5.437

USER_SQLJ_TYPE_ATTRS view, 5.438

USER_SQLJ_TYPE_METHODS view, 5.439

USER_SQLJ_TYPES view, 5.440

USER_SQLSET view, 5.441

USER_SQLSET_BINDS view, 5.442

USER_SQLSET_PLANS view, 5.443

USER_SQLSET_REFERENCES view, 5.444

USER_SQLSET_STATEMENTS view, 5.445

USER_SQLTUNE_BINDS view, 5.446

USER_SQLTUNE_PLANS view, 5.447

USER_SQLTUNE_RATIONALE_PLAN view, 5.448

USER_SQLTUNE_STATISTICS view, 5.449

USER_STORED_SETTINGS view, 5.450

USER_SUBPART_COL_STATISTICS view, 5.451

USER_SUBPART_HISTOGRAMS view, 5.452

USER_SUBPART_KEY_COLUMNS view, 5.453

USER_SUBPARTITION_TEMPLATES view, 5.454

USER_SUBSCRIBED_COLUMNS view, 5.455

USER_SUBSCRIBED_TABLES view, 5.456

USER_SUBSCRIPTIONS view, 5.457

USER_SYNONYMS view, 5.458

SYN synonym, 5.242

USER_SYS_PRIVS view, 5.459

USER_TAB_COL_STATISTICS view, 5.460

USER_TAB_COLS view, 5.461

USER_TAB_COLUMNS view, 5.462

COLS synonym, 3.135

USER_TAB_COMMENTS view, 5.463

USER_TAB_HISTOGRAMS view, 5.464

USER_TAB_MODIFICATIONS view, 5.465

USER_TAB_PARTITIONS view, 5.466

USER_TAB_PRIVS view, 5.467

USER_TAB_PRIVS_MADE view, 5.468

USER_TAB_PRIVS_RECD view, 5.469

USER_TAB_STATISTICS view, 5.470

USER_TAB_STATS_HISTORY view, 5.471

USER_TAB_SUBPARTITIONS view, 5.472

USER_TABLES view, 5.473

TABS synonym, 5.251

USER_TABLESPACES view, 5.474

USER_TRANSFORMATIONS view, 5.475

USER_TRIGGER_COLS view, 5.476

USER_TRIGGERS view, 5.477

USER_TS_QUOTAS view, 5.478

USER_TUNE_MVIEW view, 5.479

USER_TYPE_ATTRS view, 5.480

USER_TYPE_METHODS view, 5.481

USER_TYPE_VERSIONS view, 5.482

USER_TYPES view, 5.483

USER_UNUSED_COL_TABS view, 5.484

USER_UPDATABLE_COLUMNS view, 5.485

USER_USERS view, 5.486

USER_USTATS view, 5.487

USER_VARRAYS view, 5.488

USER_VIEWS view, 5.489

USER_WARNING_SETTINGS view, 5.490

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.491

USER_XML_TAB_COLS view, 5.492

USER_XML_TABLES view, 5.493

USER_XML_VIEW_COLS view, 5.494

USER_XML_VIEWS view, 5.495

USERLOCK.SQL script, B.2

users

authenticating, 1.147

multiple, 1.64

UTL_FILE_DIR initialization parameter, 1.226

UTLBSTAT.SQL script, B.2

UTLCHN1.SQL script, B.2

UTLCONST.SQL script, B.2

UTLDTREE.SQL script, 5.193, 5.213, 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.227