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_DIM_ATTRIBUTES view, 2.42

ALL_DIM_CHILD_OF view, 2.43

ALL_DIM_HIERARCHIES view, 2.44

ALL_DIM_JOIN_KEY view, 2.45

ALL_DIM_LEVEL_KEY view, 2.46

ALL_DIM_LEVELS view, 2.47

ALL_DIMENSIONS view, 2.48

ALL_DIRECTORIES view, 2.49

ALL_ERRORS view, 2.50

ALL_EVALUATION_CONTEXT_TABLES view, 2.51

ALL_EVALUATION_CONTEXT_VARS view, 2.52

ALL_EVALUATION_CONTEXTS view, 2.53

ALL_EXTERNAL_LOCATIONS view, 2.54

ALL_EXTERNAL_TABLES view, 2.55

ALL_IND_COLUMNS view, 2.56

ALL_IND_EXPRESSIONS view, 2.57

ALL_IND_PARTITIONS view, 2.58

ALL_IND_STATISTICS view, 2.59

ALL_IND_SUBPARTITIONS view, 2.60

ALL_INDEXES view, 2.61

ALL_INDEXTYPE_ARRAYTYPES view, 2.62

ALL_INDEXTYPE_COMMENTS view, 2.63

ALL_INDEXTYPE_OPERATORS view, 2.64

ALL_INDEXTYPES view, 2.65

ALL_INTERNAL_TRIGGERS view, 2.66

ALL_JAVA_ARGUMENTS view, 2.67

ALL_JAVA_CLASSES view, 2.68

ALL_JAVA_DERIVATIONS view, 2.69

ALL_JAVA_FIELDS view, 2.70

ALL_JAVA_IMPLEMENTS view, 2.71

ALL_JAVA_INNERS view, 2.72

ALL_JAVA_LAYOUTS view, 2.73

ALL_JAVA_METHODS view, 2.74

ALL_JAVA_NCOMPS view, 2.75

ALL_JAVA_RESOLVERS view, 2.76

ALL_JAVA_THROWS view, 2.77

ALL_JOBS view, 2.78

ALL_JOIN_IND_COLUMNS view, 2.79

ALL_LIBRARIES view, 2.80

ALL_LOB_PARTITIONS view, 2.81

ALL_LOB_SUBPARTITIONS view, 2.82

ALL_LOB_TEMPLATES view, 2.83

ALL_LOBS view, 2.84

ALL_LOG_GROUP_COLUMNS view, 2.85

ALL_LOG_GROUPS view, 2.86

ALL_METHOD_PARAMS view, 2.87

ALL_METHOD_RESULTS view, 2.88

ALL_MVIEW_AGGREGATES view, 2.89

ALL_MVIEW_ANALYSIS view, 2.90

ALL_MVIEW_COMMENTS view, 2.91

ALL_MVIEW_DETAIL_RELATIONS view, 2.92

ALL_MVIEW_JOINS view, 2.93

ALL_MVIEW_KEYS view, 2.94

ALL_MVIEW_LOGS view, 2.95

ALL_MVIEW_REFRESH_TIMES view, 2.96

ALL_MVIEWS view, 2.97

ALL_NESTED_TABLE_COLS view, 2.98

ALL_NESTED_TABLES view, 2.99

ALL_OBJ_COLATTRS view, 2.100

ALL_OBJECT_TABLES view, 2.101

ALL_OBJECTS view, 2.102

ALL_OPANCILLARY view, 2.103

ALL_OPARGUMENTS view, 2.104

ALL_OPBINDINGS view, 2.105

ALL_OPERATOR_COMMENTS view, 2.106

ALL_OPERATORS view, 2.107

ALL_OUTLINE_HINTS view, 2.108

ALL_OUTLINES view, 2.109

ALL_PART_COL_STATISTICS view, 2.110

ALL_PART_HISTOGRAMS view, 2.111

ALL_PART_INDEXES view, 2.112

ALL_PART_KEY_COLUMNS view, 2.113

ALL_PART_LOBS view, 2.114

ALL_PART_TABLES view, 2.115

ALL_PARTIAL_DROP_TABS view, 2.116

ALL_PENDING_CONV_TABLES view, 2.117

ALL_PLSQL_OBJECT_SETTINGS view, 2.118

ALL_POLICIES view, 2.119

ALL_POLICY_CONTEXTS view, 2.120

ALL_POLICY_GROUPS view, 2.121

ALL_PROCEDURES view, 2.122

ALL_PROPAGATION view, 2.123

ALL_PUBLISHED_COLUMNS view, 2.124

ALL_QUEUE_TABLES view, 2.125

ALL_QUEUES view, 2.126

ALL_REFRESH view, 2.127

ALL_REFRESH_CHILDREN view, 2.128

ALL_REFRESH_DEPENDENCIES view, 2.129

ALL_REFS view, 2.130

ALL_REGISTERED_MVIEWS view, 2.131

ALL_REGISTRY_BANNERS view, 2.132

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, 2.133

ALL_RULE_SET_RULES view, 2.134

ALL_RULE_SETS view, 2.135

ALL_RULES view, 2.136

ALL_SCHEDULER_JOB_ARGS view, 2.137

ALL_SCHEDULER_JOB_CLASSES view, 2.138

ALL_SCHEDULER_JOB_LOG view, 2.139

ALL_SCHEDULER_JOB_RUN_DETAILS view, 2.140

ALL_SCHEDULER_JOBS view, 2.141

ALL_SCHEDULER_PROGRAM_ARGS view, 2.142

ALL_SCHEDULER_PROGRAMS view, 2.143

ALL_SCHEDULER_RUNNING_JOBS view, 2.144

ALL_SCHEDULER_SCHEDULES view, 2.145

ALL_SCHEDULER_WINDOW_DETAILS view, 2.146

ALL_SCHEDULER_WINDOW_GROUPS view, 2.147

ALL_SCHEDULER_WINDOW_LOG view, 2.148

ALL_SCHEDULER_WINDOWS view, 2.149

ALL_SCHEDULER_WINGROUP_MEMBERS view, 2.150

ALL_SEC_RELEVANT_COLS view, 2.151

ALL_SEQUENCES view, 2.152

ALL_SERVICES view, 2.153

ALL_SOURCE view, 2.154

ALL_SOURCE_TABLES view, 2.155

ALL_SQLJ_TYPE_ATTRS view, 2.156

ALL_SQLJ_TYPE_METHODS view, 2.157

ALL_SQLJ_TYPES view, 2.158

ALL_STORED_SETTINGS view, 2.159

ALL_STREAMS_GLOBAL_RULES view, 2.160

ALL_STREAMS_MESSAGE_CONSUMERS view, 2.161

ALL_STREAMS_MESSAGE_RULES view, 2.162

ALL_STREAMS_NEWLY_SUPPORTED view, 2.163

ALL_STREAMS_RULES view, 2.164

ALL_STREAMS_SCHEMA_RULES view, 2.165

ALL_STREAMS_TABLE_RULES view, 2.166

ALL_STREAMS_TRANSFORM_FUNCTION view, 2.167

ALL_STREAMS_UNSUPPORTED view, 2.168

ALL_SUBPART_COL_STATISTICS view, 2.169

ALL_SUBPART_HISTOGRAMS view, 2.170

ALL_SUBPART_KEY_COLUMNS view, 2.171

ALL_SUBPARTITION_TEMPLATES view, 2.172

ALL_SUBSCRIBED_COLUMNS view, 2.173

ALL_SUBSCRIBED_TABLES view, 2.174

ALL_SUBSCRIPTIONS view, 2.175

ALL_SUMDELTA view, 2.176

ALL_SYNONYMS view, 2.177

ALL_TAB_COL_STATISTICS view, 2.178

ALL_TAB_COLS view, 2.179

ALL_TAB_COLUMNS view, 2.180

ALL_TAB_COMMENTS view, 2.181

ALL_TAB_HISTOGRAMS view, 2.182

ALL_TAB_MODIFICATIONS view, 2.183

ALL_TAB_PARTITIONS view, 2.184

ALL_TAB_PRIVS view, 2.185

ALL_TAB_PRIVS_MADE view, 2.186

ALL_TAB_PRIVS_RECD view, 2.187

ALL_TAB_STATISTICS view, 2.188

ALL_TAB_SUBPARTITIONS view, 2.189

ALL_TABLES view, 2.190

ALL_TRIGGER_COLS view, 2.191

ALL_TRIGGERS view, 2.192

ALL_TYPE_ATTRS view, 2.193

ALL_TYPE_METHODS view, 2.194

ALL_TYPE_VERSIONS view, 2.195

ALL_TYPES view, 2.196

ALL_UNUSED_COL_TABS view, 2.197

ALL_UPDATABLE_COLUMNS view, 2.198

ALL_USERS view, 2.199

ALL_USTATS view, 2.200

ALL_VARRAYS view, 2.201

ALL_VERSION_HVIEW view, 2.1.2

ALL_VIEWS view, 2.202

ALL_WARNING_SETTINGS view, 2.203

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, 2.204

ALL_XML_TAB_COLS view, 2.205

ALL_XML_TABLES view, 2.206

ALL_XML_VIEW_COLS view, 2.207

ALL_XML_VIEWS view, 2.208

ALLOCATE EXTENT clause

of ALTER TABLE

instance number, 1.85

allocation

PCM locks, 1.75

ALTER DATABASE statement

ADD LOGFILE, 1.211

ENABLE THREAD, 1.211

THREAD, 1.211

ALTER TABLE statement

allocating extents, 1.85

ANALYZE statement, 2.61, 2.98, 2.179, 2.180, 2.190, 3.179, 3.237, 3.359, 3.360, 3.368, 3.572, 3.655, 3.656, 3.666

AQ_TM_PROCESSES initialization parameter, 1.8

ARCHIVE LOG START statement

automatic archiving, 1.100

ARCHIVE_LAG_TARGET initialization parameter, 1.9

archived redo logs

destination file, 1.100

storage device, 1.100, 1.104

ARCHIVELOG mode, 1.100

archiving destination, 1.100, 1.104

ASM_DISKGROUPS initialization parameter, 1.10

ASM_DISKSTRING initialization parameter, 1.11

ASM_POWER_LIMIT initialization parameter, 1.12

AUDIT_ACTIONS table, 2.209

AUDIT_FILE_DEST initialization parameter, 1.13

AUDIT_SYS_OPERATIONS initialization parameter, 1.14

AUDIT_TRAIL initialization parameter, 1.15

authenticating remote clients, 1.177

authenticating users, 1.147

B

BACKGROUND_CORE_DUMP initialization parameter, 1.16

BACKGROUND_DUMP_DEST initialization parameter, 1.17

BACKUP_TAPE_IO_SLAVES initialization parameter, 1.18

BITMAP_MERGE_AREA_SIZE initialization parameter, 1.19

BLANK_TRIMMING initialization parameter, 1.20

blocks

PCM lock, 1.75

redo log, 1.110

size, 1.35, 1.39, 1.49, A.2

C

cache

dictionary, 5.50, 5.51, 5.52, 5.53, 5.54, 5.55, 5.56

statistics, 1.110

CAT synonym for USER_CATALOG view, 2.211

CATALOG view, 2.210

CATALOG.SQL script, B.1

creating V$ views, 4.1

CATAUDIT.SQL script

audit trail records created by, 3.490

audit trails for connections and disconnections, 3.493

auditing characteristics described by, 3.574

CATBLOCK.SQL script, B.2

CATCLUST.SQL script, B.1

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

CHAINED_ROWS table, 2.212

CHANGE_SETS view, 2.213

CHANGE_SOURCES view, 2.214

CHANGE_TABLES view, 2.215

characters

numeric group separators, 1.130

checkpoints

checkpoint interval, 1.110

statistics, 1.110

CIRCUITS initialization parameter, 1.21

CLU synonym for USER_CLUSTERS view, 2.216

CLUSTER_DATABASE initialization parameter, 1.22

CLUSTER_DATABASE_INSTANCES initialization parameter, 1.23

CLUSTER_INTERCONNECTS initialization parameter, 1.24

COL view, 2.217

COLS synonym for USER_TAB_COLUMNS view, 2.218

COMMIT_POINT_STRENGTH initialization parameter, 1.25

COMPATIBLE initialization parameter, 1.26

contention

block-level, 5.158

control files

names, 1.28

specifying, 1.28

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.27

CONTROL_FILES initialization parameter, 1.28

CORE_DUMP_DEST initialization parameter, 1.29

cost-based optimization, 1.146

favoring IN-list iterators, 1.144

CPU_COUNT initialization parameter, 1.30

CREATE TABLE statement

FREELIST GROUPS clause, 1.85

CREATE_BITMAP_AREA_SIZE initialization parameter, 1.31

CREATE_STORED_OUTLINES initialization parameter, 1.32

creating

a database

setting block size, 1.35, 1.39, 1.49

currency, 1.122

international currency symbol, 1.126

CURSOR_SHARING initialization parameter, 1.33

CURSOR_SPACE_FOR_TIME initialization parameter, 1.34

cursors

OPEN_CURSORS initialization parameter, 1.139

shared pool, 1.194

D

D0902000.SQL script, B.4

data blocks

reading multiple, 1.45

size of, 1.35, 1.39, 1.49

data dictionary, 2

cache, 5.50, 5.51, 5.52, 5.53, 5.54, 5.55, 5.56

datafiles, 1.75

scripts, B.2

SQL scripts, B.1

tables, 2.1

views, 1.75

overview, 2.1

user views, 2

database writer process (DBWR)

checkpoint, 1.110

DATABASE_PROPERTIES view, 2.219

databases

block size, A.2

database limits, A

default language, 1.127

resource limits, 1.180, 1.181

datafiles

mapping blocks to PCM locks, 1.75

maximum number, 1.47

parameter, 1.47

unspecified for PCM locks, 1.75

dates

language used for, 1.124, 1.133, 1.134

setting SYSDATE, 1.74

TO_CHAR function, 1.123

TO_DATE function, 1.123

DB_BLOCK_BUFFERS initialization parameter, 1.36

DB_BLOCK_CHECKING initialization parameter, 1.37

DB_BLOCK_CHECKSUM initialization parameter, 1.38

DB_BLOCK_SIZE initialization parameter, 1.39

DB_CACHE_ADVICE initialization parameter, 1.40

DB_CACHE_SIZE initialization parameter, 1.41

DB_CREATE_FILE_DEST initialization parameter, 1.42

DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.43

DB_DOMAIN initialization parameter, 1.44

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.45

DB_FILE_NAME_CONVERT initialization parameter, 1.46

DB_FILES initialization parameter, 1.47

DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.48

DB_KEEP_CACHE_SIZE initialization parameter, 1.49

DB_NAME initialization parameter, 1.50

DB_nK_CACHE_SIZE initialization parameter, 1.35

DB_RECOVERY_FILE_DEST initialization parameter, 1.51

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.52

DB_RECYCLE_CACHE_SIZE initialization parameter, 1.53

DB_UNIQUE_NAME initialization parameter, 1.54

DB_WRITER_PROCESSES initialization parameter, 1.55

DBA_2PC_NEIGHBORS view, 3.1

DBA_2PC_PENDING view, 3.2

DBA_ADVISOR_ACTIONS view, 3.3

DBA_ADVISOR_COMMANDS view, 3.4

DBA_ADVISOR_DEFINITIONS view, 3.5

DBA_ADVISOR_FINDINGS view, 3.6

DBA_ADVISOR_JOURNAL view, 3.7

DBA_ADVISOR_LOG view, 3.8

DBA_ADVISOR_OBJECT_TYPES view, 3.9

DBA_ADVISOR_OBJECTS view, 3.10

DBA_ADVISOR_PARAMETERS view, 3.11

DBA_ADVISOR_RATIONALE view, 3.12

DBA_ADVISOR_RECOMMENDATIONS view, 3.13

DBA_ADVISOR_SQLA_REC_SUM view, 3.14

DBA_ADVISOR_SQLA_WK_MAP view, 3.15

DBA_ADVISOR_SQLA_WK_STMTS view, 3.16

DBA_ADVISOR_SQLW_JOURNAL view, 3.17

DBA_ADVISOR_SQLW_PARAMETERS view, 3.18

DBA_ADVISOR_SQLW_STMTS view, 3.19

DBA_ADVISOR_SQLW_SUM view, 3.20

DBA_ADVISOR_SQLW_TABLES view, 3.21

DBA_ADVISOR_SQLW_TEMPLATES view, 3.22

DBA_ADVISOR_TASKS view, 3.23

DBA_ADVISOR_TEMPLATES view, 3.24

DBA_ADVISOR_USAGE view, 3.25

DBA_ALERT_HISTORY view, 3.26

DBA_ALL_TABLES view, 3.27

DBA_APPLICATION_ROLES view, 3.28

DBA_APPLY view, 3.29

DBA_APPLY_CONFLICT_COLUMNS view, 3.30

DBA_APPLY_DML_HANDLERS view, 3.31

DBA_APPLY_ENQUEUE view, 3.32

DBA_APPLY_ERROR view, 3.33

DBA_APPLY_EXECUTE view, 3.34

DBA_APPLY_INSTANTIATED_GLOBAL view, 3.35

DBA_APPLY_INSTANTIATED_OBJECTS view, 3.36

DBA_APPLY_INSTANTIATED_SCHEMAS view, 3.37

DBA_APPLY_KEY_COLUMNS view, 3.38

DBA_APPLY_PARAMETERS view, 3.39

DBA_APPLY_PROGRESS view, 3.40

DBA_APPLY_TABLE_COLUMNS view, 3.41

DBA_AQ_AGENT_PRIVS view, 3.42

DBA_AQ_AGENTS view, 3.43

DBA_ASSOCIATIONS view, 3.44

DBA_ATTRIBUTE_TRANSFORMATIONS view, 3.45

DBA_AUDIT_EXISTS view, 3.46

DBA_AUDIT_OBJECT view, 3.47

DBA_AUDIT_POLICIES view, 3.48

DBA_AUDIT_POLICY_COLUMNS view, 3.49

DBA_AUDIT_SESSION view, 3.50

DBA_AUDIT_STATEMENT view, 3.51

DBA_AUDIT_TRAIL view, 3.52

DBA_AW_PS view, 3.53

DBA_AWS view, 3.54

DBA_BASE_TABLE_MVIEWS view, 3.55

DBA_BLOCKERS view, 3.56

DBA_CAPTURE view, 3.57

DBA_CAPTURE_EXTRA_ATTRIBUTES view, 3.58

DBA_CAPTURE_PARAMETERS view, 3.59

DBA_CAPTURE_PREPARED_DATABASE view, 3.60

DBA_CAPTURE_PREPARED_SCHEMAS view, 3.61

DBA_CAPTURE_PREPARED_TABLES view, 3.62

DBA_CATALOG view, 3.63

DBA_CLU_COLUMNS view, 3.64

DBA_CLUSTER_HASH_EXPRESSIONS view, 3.65

DBA_CLUSTERS view, 3.66

DBA_COL_COMMENTS view, 3.67

DBA_COL_PRIVS view, 3.68

DBA_COLL_TYPES view, 3.69

DBA_COMMON_AUDIT_TRAIL view, 3.70

DBA_CONS_OBJ_COLUMNS view, 3.71

DBA_CONSTRAINTS view, 3.72

DBA_CONTEXT view, 3.73

DBA_DATA_FILES view, 3.74

DBA_DATAPUMP_JOBS view, 3.75

DBA_DATAPUMP_SESSIONS view, 3.76

DBA_DB_LINKS view, 3.77

DBA_DDL_LOCKS view, 3.78

DBA_DEPENDENCIES view, 3.79

DBA_DIM_ATTRIBUTES view, 3.80

DBA_DIM_CHILD_OF view, 3.81

DBA_DIM_HIERARCHIES view, 3.82

DBA_DIM_JOIN_KEY view, 3.83

DBA_DIM_LEVEL_KEY view, 3.84

DBA_DIM_LEVELS view, 3.85

DBA_DIMENSIONS view, 3.86

DBA_DIRECTORIES view, 3.87

DBA_DML_LOCKS view, 3.88

DBA_DMT_FREE_SPACE view, 3.89

DBA_DMT_USED_EXTENTS view, 3.90

DBA_ENABLED_AGGREGATIONS view, 3.91

DBA_ENABLED_TRACES view, 3.92

DBA_ERRORS view, 3.93

DBA_EVALUATION_CONTEXT_TABLES view, 3.94

DBA_EVALUATION_CONTEXT_VARS view, 3.95

DBA_EVALUATION_CONTEXTS view, 3.96

DBA_EXP_FILES view, 3.97

DBA_EXP_OBJECTS view, 3.98

DBA_EXP_VERSION view, 3.99

DBA_EXTENTS view, 3.100

DBA_EXTERNAL_LOCATIONS view, 3.101

DBA_EXTERNAL_TABLES view, 3.102

DBA_FEATURE_USAGE_STATISTICS view, 3.103

DBA_FGA_AUDIT_TRAIL view, 3.104

DBA_FREE_SPACE view, 3.105

DBA_FREE_SPACE_COALESCED view, 3.106

DBA_HIGH_WATER_MARK_STATISTICS view, 3.107

DBA_HIST_ACTIVE_SESS_HISTORY view, 3.108

DBA_HIST_BASELINE view, 3.109

DBA_HIST_BG_EVENT_SUMMARY view, 3.110

DBA_HIST_BUFFER_POOL_STAT view, 3.111

DBA_HIST_CR_BLOCK_SERVER view, 3.112

DBA_HIST_CURRENT_BLOCK_SERVER view, 3.113

DBA_HIST_DATABASE_INSTANCE view, 3.114

DBA_HIST_DATAFILE view, 3.115

DBA_HIST_DB_CACHE_ADVICE view, 3.116

DBA_HIST_DLM_MISC view, 3.117

DBA_HIST_ENQUEUE_STAT view, 3.118

DBA_HIST_EVENT_NAME view, 3.119

DBA_HIST_FILEMETRIC_HISTORY view, 3.120

DBA_HIST_FILESTATXS view, 3.121

DBA_HIST_INSTANCE_RECOVERY view, 3.122

DBA_HIST_JAVA_POOL_ADVICE view, 3.123

DBA_HIST_LATCH view, 3.124

DBA_HIST_LATCH_CHILDREN view, 3.125

DBA_HIST_LATCH_MISSES_SUMMARY view, 3.126

DBA_HIST_LATCH_NAME view, 3.127

DBA_HIST_LATCH_PARENT view, 3.128

DBA_HIST_LIBRARYCACHE view, 3.129

DBA_HIST_LOG view, 3.130

DBA_HIST_METRIC_NAME view, 3.131

DBA_HIST_MTTR_TARGET_ADVICE view, 3.132

DBA_HIST_OPTIMIZER_ENV view, 3.133

DBA_HIST_OSSTAT view, 3.134

DBA_HIST_OSSTAT_NAME view, 3.135

DBA_HIST_PARAMETER view, 3.136

DBA_HIST_PARAMETER_NAME view, 3.137

DBA_HIST_PGA_TARGET_ADVICE view, 3.138

DBA_HIST_PGASTAT view, 3.139

DBA_HIST_RESOURCE_LIMIT view, 3.140

DBA_HIST_ROLLSTAT view, 3.141

DBA_HIST_ROWCACHE_SUMMARY view, 3.142

DBA_HIST_SEG_STAT view, 3.143

DBA_HIST_SEG_STAT_OBJ view, 3.144

DBA_HIST_SERVICE_NAME view, 3.145

DBA_HIST_SERVICE_STAT view, 3.146

DBA_HIST_SERVICE_WAIT_CLASS view, 3.147

DBA_HIST_SESSMETRIC_HISTORY view, 3.148

DBA_HIST_SGA view, 3.149

DBA_HIST_SGASTAT view, 3.150

DBA_HIST_SHARED_POOL_ADVICE view, 3.151

DBA_HIST_SNAP_ERROR view, 3.152

DBA_HIST_SNAPSHOT view, 3.153

DBA_HIST_SQL_PLAN view, 3.154

DBA_HIST_SQL_SUMMARY view, 3.155

DBA_HIST_SQL_WORKAREA_HSTGRM view, 3.156

DBA_HIST_SQLBIND view, 3.157

DBA_HIST_SQLSTAT view, 3.158

DBA_HIST_SQLTEXT view, 3.159

DBA_HIST_STAT_NAME view, 3.160

DBA_HIST_SYS_TIME_MODEL view, 3.161

DBA_HIST_SYSMETRIC_HISTORY view, 3.162

DBA_HIST_SYSMETRIC_SUMMARY view, 3.163

DBA_HIST_SYSSTAT view, 3.164

DBA_HIST_SYSTEM_EVENT view, 3.165

DBA_HIST_TABLESPACE_STAT view, 3.166

DBA_HIST_TBSPC_SPACE_USAGE view, 3.167

DBA_HIST_TEMPFILE view, 3.168

DBA_HIST_TEMPSTATXS view, 3.169

DBA_HIST_THREAD view, 3.170

DBA_HIST_UNDOSTAT view, 3.171

DBA_HIST_WAITCLASSMET_HISTORY view, 3.172

DBA_HIST_WAITSTAT view, 3.173

DBA_HIST_WR_CONTROL view, 3.174

DBA_IND_COLUMNS view, 3.175

DBA_IND_EXPRESSIONS view, 3.176

DBA_IND_PARTITIONS view, 3.177

DBA_IND_STATISTICS view, 3.178

DBA_IND_SUBPARTITIONS view, 3.179

DBA_INDEXES view, 3.180

collecting statistics for, 3.179

DBA_INDEXTYPE_ARRAYTYPES view, 3.181

DBA_INDEXTYPE_COMMENTS view, 3.182

DBA_INDEXTYPE_OPERATORS view, 3.183

DBA_INDEXTYPES view, 3.184

DBA_INTERNAL_TRIGGERS view, 3.185

DBA_JAVA_ARGUMENTS view, 3.186

DBA_JAVA_CLASSES view, 3.187

DBA_JAVA_DERIVATIONS view, 3.188

DBA_JAVA_FIELDS view, 3.189

DBA_JAVA_IMPLEMENTS view, 3.190

DBA_JAVA_INNERS view, 3.191

DBA_JAVA_LAYOUTS view, 3.192

DBA_JAVA_METHODS view, 3.193

DBA_JAVA_NCOMPS view, 3.194

DBA_JAVA_POLICY view, 3.195

DBA_JAVA_RESOLVERS view, 3.196

DBA_JAVA_THROWS view, 3.197

DBA_JOBS view, 3.198

DBA_JOBS_RUNNING view, 3.199

DBA_JOIN_IND_COLUMNS view, 3.200

DBA_KGLLOCK view, 3.201

DBA_LIBRARIES view, 3.202

DBA_LMT_FREE_SPACE view, 3.203

DBA_LMT_USED_EXTENTS view, 3.204

DBA_LOB_PARTITIONS view, 3.205

DBA_LOB_SUBPARTITIONS view, 3.206

DBA_LOB_TEMPLATES view, 3.207

DBA_LOBS view, 3.208

DBA_LOCK view, 3.209

DBA_LOCKS synonym, 3.211

DBA_LOCK_INTERNAL view, 3.210

DBA_LOCKS synonym for DBA_LOCK view, 3.211

DBA_LOG_GROUP_COLUMNS view, 3.212

DBA_LOG_GROUPS view, 3.213

DBA_LOGMNR_LOG view, 3.214

DBA_LOGMNR_PURGED_LOG view, 3.215

DBA_LOGMNR_SESSION view, 3.216

DBA_LOGSTDBY_EVENTS view, 3.217

DBA_LOGSTDBY_LOG view, 3.218

DBA_LOGSTDBY_NOT_UNIQUE view, 3.219

DBA_LOGSTDBY_PARAMETERS view, 3.220

DBA_LOGSTDBY_PROGRESS view, 3.221

DBA_LOGSTDBY_SKIP view, 3.222

DBA_LOGSTDBY_SKIP_TRANSACTION view, 3.223

DBA_LOGSTDBY_UNSUPPORTED view, 3.224

DBA_METHOD_PARAMS view, 3.225

DBA_METHOD_RESULTS view, 3.226

DBA_MVIEW_AGGREGATES view, 3.227

DBA_MVIEW_ANALYSIS view, 3.228

DBA_MVIEW_COMMENTS view, 3.229

DBA_MVIEW_DETAIL_RELATIONS view, 3.230

DBA_MVIEW_JOINS view, 3.231

DBA_MVIEW_KEYS view, 3.232

DBA_MVIEW_LOG_FILTER_COLS view, 3.233

DBA_MVIEW_LOGS view, 3.234

DBA_MVIEW_REFRESH_TIMES view, 3.235

DBA_MVIEWS view, 3.236

DBA_NESTED_TABLE_COLS view, 3.237

DBA_NESTED_TABLES view, 3.238

DBA_OBJ_AUDIT_OPTS view, 3.239

DBA_OBJ_COLATTRS view, 3.240

DBA_OBJECT_SIZE view, 3.241

DBA_OBJECT_TABLES view, 3.242

DBA_OBJECTS view, 3.243

DBA_OPANCILLARY view, 3.244

DBA_OPARGUMENTS view, 3.245

DBA_OPBINDINGS view, 3.246

DBA_OPERATOR_COMMENTS view, 3.247

DBA_OPERATORS view, 3.248

DBA_ORPHAN_KEY_TABLE view, 3.249

DBA_OUTLINE_HINTS view, 3.250

DBA_OUTLINES view, 3.251

DBA_OUTSTANDING_ALERTS view, 3.252

DBA_PART_COL_STATISTICS view, 3.253

DBA_PART_HISTOGRAMS view, 3.254

DBA_PART_INDEXES view, 3.255

DBA_PART_KEY_COLUMNS view, 3.256

DBA_PART_LOBS view, 3.257

DBA_PART_TABLES view, 3.258

DBA_PARTIAL_DROP_TABS view, 3.259

DBA_PENDING_CONV_TABLES view, 3.260

DBA_PENDING_TRANSACTIONS view, 3.261

DBA_PLSQL_OBJECT_SETTINGS view, 3.262

DBA_POLICIES view, 3.263

DBA_POLICY_CONTEXTS view, 3.264

DBA_POLICY_GROUPS view, 3.265

DBA_PRIV_AUDIT_OPTS view, 3.266

DBA_PROCEDURES view, 3.267

DBA_PROFILES view, 3.268

DBA_PROPAGATION view, 3.269

DBA_PROXIES view, 3.270

DBA_PUBLISHED_COLUMNS view, 3.271

DBA_QUEUE_SCHEDULES view, 3.272

DBA_QUEUE_TABLES view, 3.273

DBA_QUEUES view, 3.274

DBA_RCHILD view, 3.275

DBA_RECYCLEBIN view, 3.276

DBA_REDEFINITION_ERRORS view, 3.277

DBA_REDEFINITION_OBJECTS view, 3.278

DBA_REFRESH view, 3.279

DBA_REFRESH_CHILDREN view, 3.280

DBA_REFS view, 3.281

DBA_REGISTERED_ARCHIVED_LOG view, 3.282

DBA_REGISTERED_MVIEW_GROUPS view, 3.283

DBA_REGISTERED_MVIEWS view, 3.284

DBA_REGISTRY view, 3.285

DBA_REGISTRY_HIERARCHY view, 3.286

DBA_REPAIR_TABLE view, 3.287

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_RESUMABLE view, 3.288

DBA_REWRITE_EQUIVALENCES view, 3.289

DBA_RGROUP view, 3.290

DBA_ROLE_PRIVS view, 3.291

DBA_ROLES view, 3.292

DBA_ROLLBACK_SEGS view, 3.293

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 3.294

DBA_RSRC_CONSUMER_GROUPS view, 3.295

DBA_RSRC_GROUP_MAPPINGS view, 3.296

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 3.297

DBA_RSRC_MAPPING_PRIORITY view, 3.298

DBA_RSRC_PLAN_DIRECTIVES view, 3.299

DBA_RSRC_PLANS view, 3.300

DBA_RULE_SET_RULES view, 3.301

DBA_RULE_SETS view, 3.302

DBA_RULES view, 3.303

DBA_SCHEDULER_JOB_ARGS view, 3.304

DBA_SCHEDULER_JOB_CLASSES view, 3.305

DBA_SCHEDULER_JOB_LOG view, 3.306

DBA_SCHEDULER_JOB_RUN_DETAILS view, 3.307

DBA_SCHEDULER_JOBS view, 3.308

DBA_SCHEDULER_PROGRAM_ARGS view, 3.309

DBA_SCHEDULER_PROGRAMS view, 3.310

DBA_SCHEDULER_RUNNING_JOBS view, 3.311

DBA_SCHEDULER_SCHEDULES view, 3.312

DBA_SCHEDULER_WINDOW_DETAILS view, 3.313

DBA_SCHEDULER_WINDOW_GROUPS view, 3.314

DBA_SCHEDULER_WINDOW_LOG view, 3.315

DBA_SCHEDULER_WINDOWS view, 3.316

DBA_SCHEDULER_WINGROUP_MEMBERS view, 3.317

DBA_SEC_RELEVANT_COLS view, 3.318

DBA_SEGMENTS view, 3.319

DBA_SEQUENCES view, 3.320

DBA_SERVER_REGISTRY view, 3.321

DBA_SERVICES view, 3.322

DBA_SOURCE view, 3.323

DBA_SOURCE_TABLES view, 3.324

DBA_SQL_PROFILES view, 3.325

DBA_SQLJ_TYPE_ATTRS view, 3.326

DBA_SQLJ_TYPE_METHODS view, 3.327

DBA_SQLJ_TYPES view, 3.328

DBA_SQLSET view, 3.329

DBA_SQLSET_BINDS view, 3.330

DBA_SQLSET_REFERENCES view, 3.331

DBA_SQLSET_STATEMENTS view, 3.332

DBA_SQLTUNE_BINDS view, 3.333

DBA_SQLTUNE_PLANS view, 3.334

DBA_SQLTUNE_RATIONALE_PLAN view, 3.335

DBA_SQLTUNE_STATISTICS view, 3.336

DBA_STMT_AUDIT_OPTS view, 3.337

DBA_STORED_SETTINGS view, 3.338

DBA_STREAMS_ADMINISTRATOR view, 3.339

DBA_STREAMS_GLOBAL_RULES view, 3.340

DBA_STREAMS_MESSAGE_CONSUMERS view, 3.341

DBA_STREAMS_MESSAGE_RULES view, 3.342

DBA_STREAMS_NEWLY_SUPPORTED view, 3.343

DBA_STREAMS_RULES view, 3.344

DBA_STREAMS_SCHEMA_RULES view, 3.345

DBA_STREAMS_TABLE_RULES view, 3.346

DBA_STREAMS_TRANSFORM_FUNCTION view, 3.347

DBA_STREAMS_UNSUPPORTED view, 3.348

DBA_SUBPART_COL_STATISTICS view, 3.349

DBA_SUBPART_HISTOGRAMS view, 3.350

DBA_SUBPART_KEY_COLUMNS view, 3.351

DBA_SUBPARTITION_TEMPLATES view, 3.352

DBA_SUBSCRIBED_COLUMNS view, 3.353

DBA_SUBSCRIBED_TABLES view, 3.354

DBA_SUBSCRIPTIONS view, 3.355

DBA_SYNONYMS view, 3.356

DBA_SYS_PRIVS view, 3.357

DBA_TAB_COL_STATISTICS view, 3.358

DBA_TAB_COLS view, 3.359

DBA_TAB_COLUMNS view, 3.360

DBA_TAB_COMMENTS view, 3.361

DBA_TAB_HISTOGRAMS view, 3.362

DBA_TAB_MODIFICATIONS view, 3.363

DBA_TAB_PARTITIONS view, 3.364

DBA_TAB_PRIVS view, 3.365

DBA_TAB_STATISTICS view, 3.366

DBA_TAB_SUBPARTITIONS view, 3.367

DBA_TABLES view, 3.368

DBA_TABLESPACE_GROUPS view, 3.369

DBA_TABLESPACES view, 3.370

DBA_TEMP_FILES view, 3.371

DBA_THRESHOLDS view, 3.372

DBA_TRANSFORMATIONS view, 3.373

DBA_TRIGGER_COLS view, 3.374

DBA_TRIGGERS view, 3.375

DBA_TS_QUOTAS view, 3.376

DBA_TUNE_MVIEW view, 3.377

DBA_TYPE_ATTRS view, 3.378

DBA_TYPE_METHODS view, 3.379

DBA_TYPE_VERSIONS view, 3.380

DBA_TYPES view, 3.381

DBA_UNDO_EXTENTS view, 3.382

DBA_UNUSED_COL_TABS view, 3.383

DBA_UPDATABLE_COLUMNS view, 3.384

DBA_USERS view, 3.385

DBA_USTATS view, 3.386

DBA_VARRAYS view, 3.387

DBA_VIEWS view, 3.388

DBA_WAITERS view, 3.389

DBA_WARNING_SETTINGS view, 3.390

DBA_WORKSPACE_SESSIONS view, 2.1.2

DBA_XML_SCHEMAS view, 3.391

DBA_XML_TAB_COLS view, 3.392

DBA_XML_TABLES view, 3.393

DBA_XML_VIEW_COLS view, 3.394

DBA_XML_VIEWS view, 3.399

DBMS_ALERT_INFO view, 3.400

DBMS_LOCK_ALLOCATED view, 3.401

DBMSIOTC.SQL script, B.2

DBMSOTRC.SQL script, B.2

DBMSPOOL.SQL script, B.2

DBWR_IO_SLAVES initialization parameter, 1.56

DDL_WAIT_FOR_LOCKS initialization parameter, 1.57

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, 3.402

destination

archiving redo log files, 1.100

overriding default, 1.100

USER_DUMP_DEST, 1.222

DG_BROKER_CONFIG_FILEn initialization parameter, 1.58

DG_BROKER_START initialization parameter, 1.59

DICT synonym for DICTIONARY, 3.403

DICT_COLUMNS view, 3.404

DICTIONARY view, 3.405

DICT synonym, 3.403

disk drives

archiving destination, 1.100

DISK_ASYNCH_IO initialization parameter, 1.60

dispatcher processes

maximum number, 1.116

DISPATCHERS initialization parameter, 1.61

distinguished name, 1.170

DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.62

DML_LOCKS initialization parameter, 1.63

downgrading

scripts, B.4

dump files, 1.117

dynamic performance tables

CATALOG.SQL script, 4.1

public synonyms (V$), 4.1.1

views (V_$), 4.1.1

E

embedded initialization parameter files, 1.82

ENQUEUE_RESOURCES initialization parameter, 1.64

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

distributed recovery process, D

distributed transaction, D

DML, D

ENQUEUE_RESOURCES initialization parameter, 1.64

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

ERROR_SIZE view, 3.406

EVENT initialization parameter, 1.65

EXCEPTIONS view, 3.407

extent

allocating to instance, 1.85

F

FAL_CLIENT initialization parameter, 1.66

FAL_SERVER initialization parameter, 1.67

FAST_START_IO_TARGET initialization parameter, 1.68

FAST_START_MTTR_TARGET initialization parameter, 1.69

FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.70

FILE_MAPPING initialization parameter, 1.71

FILEIO_NETWORK_ADAPTERS initialization parameter, 1.72

filenames

case significance, 1.3.2.1.1

name and number, 1.75

FILESYSTEMIO_OPTIONS initialization parameter, 1.73

FIXED_DATE initialization parameter, 1.74

FLASHBACK_TRANSACTION_QUERY view, 3.395

free space list

locating space, 1.85

FREELIST GROUPS clause, 1.85

G

GC_FILES_TO_LOCKS initialization parameter, 1.75

GCS_SERVER_PROCESSES initialization parameter, 1.76

GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.77

GLOBAL_NAME view, 3.396

GLOBAL_NAMES initialization parameter, 1.78

GV$ views

for Real Application Clusters, 4.1.2

H

HASH_AREA_SIZE initialization parameter, 1.79

Heterogeneous Services

agents, 1.81

HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.80

HS_ALL_CAPS view, 3.397

HS_ALL_DD view, 3.398

HS_ALL_INITS view, 3.408

HS_AUTOREGISTER initialization parameter, 1.81

HS_BASE_CAPS view, 3.409

HS_BASE_DD view, 3.410

HS_CLASS_CAPS view, 3.411

HS_CLASS_DD view, 3.412

HS_CLASS_INIT view, 3.413

HS_EXTERNAL_OBJECT_PRIVILEGES view, 3.414

HS_EXTERNAL_OBJECTS view, 3.415

HS_EXTERNAL_USER_PRIVILEGES view, 3.416

HS_FDS_CLASS view, 3.417

HS_FDS_INST view, 3.418

HS_INST_CAPS view, 3.419

HS_INST_DD view, 3.420

HS_INST_INIT view, 3.421

I

IDEPTREE view, 3.422

IFILE initialization parameter, 1.3.2.1.1, 1.82

IND synonym for USER_INDEXES view, 3.423

INDEX_HISTOGRAM view, 3.424

INDEX_STATS view, 3.425

initialization parameter file

common file, 1.82

embedded, 1.82

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_TRAIL, 1.15

BACKGROUND_CORE_DUMP, 1.16

BACKGROUND_DUMP_DEST, 1.17

BACKUP_TAPE_IO_SLAVES, 1.18

basic, 1.2

BITMAP_MERGE_AREA_SIZE, 1.19

BLANK_TRIMMING, 1.20

case significance in filenames, 1.3.2.1.1

CIRCUITS, 1.21

CLUSTER_DATABASE, 1.22

CLUSTER_DATABASE_INSTANCES, 1.23

CLUSTER_INTERCONNECTS, 1.24

COMMIT_POINT_STRENGTH, 1.25

COMPATIBLE, 1.26

CONTROL_FILE_RECORD_KEEP_TIME, 1.27

CONTROL_FILES, 1.28

CORE_DUMP_DEST, 1.29

CPU_COUNT, 1.30

CREATE_BITMAP_AREA_SIZE, 1.31

CREATE_STORED_OUTLINES, 1.32

CURSOR_SHARING, 1.33

CURSOR_SPACE_FOR_TIME, 1.34

DB_BLOCK_BUFFERS, 1.36

DB_BLOCK_CHECKING, 1.37

DB_BLOCK_CHECKSUM, 1.38

DB_BLOCK_SIZE, 1.39

DB_CACHE_ADVICE, 1.40

DB_CACHE_SIZE, 1.41

DB_CREATE_FILE_DEST, 1.42

DB_CREATE_ONLINE_LOG_DEST_n, 1.43

DB_DOMAIN, 1.44

DB_FILE_MULTIBLOCK_READ_COUNT, 1.45

DB_FILE_NAME_CONVERT, 1.46

DB_FILES, 1.47

DB_FLASHBACK_RETENTION_TARGET, 1.48

DB_KEEP_CACHE_SIZE, 1.49

DB_NAME, 1.50

DB_nK_CACHE_SIZE, 1.35

DB_RECOVERY_FILE_DEST, 1.51

DB_RECOVERY_FILE_DEST_SIZE, 1.52

DB_RECYCLE_CACHE_SIZE, 1.53

DB_UNIQUE_NAME, 1.54

DB_WRITER_PROCESSES, 1.55

DBWR_IO_SLAVES, 1.56

DDL_WAIT_FOR_LOCKS, 1.57

derived, 1.1.1.1

DG_BROKER_CONFIG_FILEn, 1.58

DG_BROKER_START, 1.59

DISK_ASYNCH_IO, 1.60

DISPATCHERS, 1.61

display current settings, 1.4.3

DISTRIBUTED_LOCK_TIMEOUT, 1.62

DML_LOCKS, 1.63

embedded initialization parameter files, 1.3.2.1.1

ENQUEUE_RESOURCES, 1.64

EVENT, 1.65

FAL_CLIENT, 1.66

FAL_SERVER, 1.67

FAST_START_IO_TARGET, 1.68

FAST_START_MTTR_TARGET, 1.69

FAST_START_PARALLEL_ROLLBACK, 1.70

FILE_MAPPING, 1.71

FILEIO_NETWORK_ADAPTERS, 1.72

FILESYSTEMIO_OPTIONS, 1.73

FIXED_DATE, 1.74

functional category, 1.4.1

GC_FILES_TO_LOCKS, 1.75

GCS_SERVER_PROCESSES, 1.76

GLOBAL_CONTEXT_POOL_SIZE, 1.77

GLOBAL_NAMES, 1.78

HASH_AREA_SIZE, 1.79

HI_SHARED_MEMORY_ADDRESS, 1.80

HS_AUTOREGISTER, 1.81

IFILE, 1.3.2.1.1, 1.82

INSTANCE_GROUPS, 1.83

INSTANCE_NAME, 1.84

INSTANCE_NUMBER, 1.85

INSTANCE_TYPE, 1.86

JAVA_MAX_SESSIONSPACE_SIZE, 1.87

JAVA_POOL_SIZE, 1.88

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.89

JOB_QUEUE_PROCESSES, 1.90

LARGE_POOL_SIZE, 1.91

LDAP_DIRECTORY_ACCESS, 1.92

LICENSE_MAX_SESSIONS, 1.93

LICENSE_MAX_USERS, 1.94

LICENSE_SESSIONS_WARNING, 1.95

LOCAL_LISTENER, 1.96

LOCK_NAME_SPACE, 1.97

LOCK_SGA, 1.98

LOG_ARCHIVE_CONFIG, 1.99

LOG_ARCHIVE_DEST, 1.100

LOG_ARCHIVE_DEST_n, 1.101

LOG_ARCHIVE_DEST_STATE_n, 1.102

LOG_ARCHIVE_DUPLEX_DEST, 1.103

LOG_ARCHIVE_FORMAT, 1.104

LOG_ARCHIVE_LOCAL_FIRST, 1.105

LOG_ARCHIVE_MAX_PROCESSES, 1.106

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.107

LOG_ARCHIVE_TRACE, 1.108

LOG_BUFFER, 1.109

LOG_CHECKPOINT_INTERVAL, 1.110

LOG_CHECKPOINT_TIMEOUT, 1.111

LOG_CHECKPOINTS_TO_ALERT, 1.112

LOG_FILE_NAME_CONVERT, 1.113

LOGMNR_MAX_PERSISTENT_SESSIONS, 1.114

MAX_COMMIT_PROPAGATION_DELAY, 1.115

MAX_DISPATCHERS, 1.116

MAX_DUMP_FILE_SIZE, 1.117

MAX_ENABLED_ROLES, 1.118

MAX_SHARED_SERVERS, 1.119

modifiable, 1.4.2

NLS_CALENDAR, 1.120

NLS_COMP, 1.121

NLS_CURRENCY, 1.122

NLS_DATE_FORMAT, 1.123

NLS_DATE_LANGUAGE, 1.124

NLS_DUAL_CURRENCY, 1.125

NLS_ISO_CURRENCY, 1.126

NLS_LANGUAGE, 1.127

NLS_LENGTH_SEMANTICS, 1.128

NLS_NCHAR_CONV_EXCP, 1.129

NLS_NUMERIC_CHARACTERS, 1.130

NLS_SORT, 1.131

NLS_TERRITORY, 1.132

NLS_TIMESTAMP_FORMAT, 1.133

NLS_TIMESTAMP_TZ_FORMAT, 1.134

O7_DICTIONARY_ACCESSIBILITY, 1.135

OBJECT_CACHE_MAX_SIZE_PERCENT, 1.136

OBJECT_CACHE_OPTIMAL_SIZE, 1.137

OLAP_PAGE_POOL_SIZE, 1.138

OPEN_CURSORS, 1.139

OPEN_LINKS, 1.140

OPEN_LINKS_PER_INSTANCE, 1.141

operating system-dependent values, 1.1.1.2

OPTIMIZER_DYNAMIC_SAMPLING, 1.142

OPTIMIZER_FEATURES_ENABLE, 1.143

OPTIMIZER_INDEX_CACHING, 1.144

OPTIMIZER_INDEX_COST_ADJ, 1.145

OPTIMIZER_MODE, 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_CODE_TYPE, 1.158

PLSQL_COMPILER_FLAGS, 1.159

PLSQL_DEBUG, 1.160

PLSQL_NATIVE_LIBRARY_DIR, 1.161

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1.162

PLSQL_OPTIMIZE_LEVEL, 1.163

PLSQL_V2_COMPATIBILITY, 1.164

PLSQL_WARNINGS, 1.165

PRE_PAGE_SGA, 1.166

PROCESSES, 1.167

QUERY_REWRITE_ENABLED, 1.168

QUERY_REWRITE_INTEGRITY, 1.169

RDBMS_SERVER_DN, 1.170

READ_ONLY_OPEN_DELAYED, 1.171

RECOVERY_PARALLELISM, 1.172

REMOTE_ARCHIVE_ENABLE, 1.173

REMOTE_DEPENDENCIES_MODE, 1.174

REMOTE_LISTENER, 1.175

REMOTE_LOGIN_PASSWORDFILE, 1.176

REMOTE_OS_AUTHENT, 1.177

REMOTE_OS_ROLES, 1.178

REPLICATION_DEPENDENCY_TRACKING, 1.179

RESOURCE_LIMIT, 1.180

RESOURCE_MANAGER_PLAN, 1.181

RESUMABLE_TIMEOUT, 1.182

ROLLBACK_SEGMENTS, 1.183

SERIAL_REUSE, 1.184

SERVICE_NAMES, 1.185

SESSION_CACHED_CURSORS, 1.186

SESSION_MAX_OPEN_FILES, 1.187

SESSIONS, 1.188

SGA_MAX_SIZE, 1.189

SGA_TARGET, 1.190

SHADOW_CORE_DUMP, 1.191

SHARED_MEMORY_ADDRESS, 1.192

SHARED_POOL_RESERVED_SIZE, 1.193

SHARED_POOL_SIZE, 1.194

SHARED_SERVER_SESSIONS, 1.195

SHARED_SERVERS, 1.196

SKIP_UNUSABLE_INDEXES, 1.197

SMTP_OUT_SERVER, 1.198

SORT_AREA_RETAINED_SIZE, 1.199

SORT_AREA_SIZE, 1.200

specifying in initialization parameter files, 1.3.2.1

SPFILE, 1.201

SQL_TRACE, 1.202

SQL92_SECURITY, 1.203

SQLTUNE_CATEGORY, 1.204

STANDBY_ARCHIVE_DEST, 1.205

STANDBY_FILE_MANAGEMENT, 1.206

STAR_TRANSFORMATION_ENABLED, 1.207

STATISTICS_LEVEL, 1.208

STREAMS_POOL_SIZE, 1.209

TAPE_ASYNCH_IO, 1.210

THREAD, 1.211

TIMED_OS_STATISTICS, 1.212

TIMED_STATISTICS, 1.213

TRACE_ENABLED, 1.214

TRACEFILE_IDENTIFIER, 1.215

TRANSACTIONS, 1.216

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.217

UNDO_MANAGEMENT, 1.218

UNDO_RETENTION, 1.219

UNDO_TABLESPACE, 1.220

USE_INDIRECT_DATA_BUFFERS, 1.221

USER_DUMP_DEST, 1.222

UTL_FILE_DIR, 1.223

variable, 1.1.1.3

WORKAREA_SIZE_POLICY, 1.224

INITJVM.SQL script, B.5

INIT.ORA file. See initialization parameter file

IN-list iterators

optimizer use of, 1.144

inserts

locating free space, 1.85

INST_ID column, 4.1.2

INSTANCE clause

of ALTER TABLE

allocating extents, 1.85

INSTANCE_GROUPS initialization parameter, 1.83

INSTANCE_NAME initialization parameter, 1.84

INSTANCE_NUMBER initialization parameter, 1.85

INSTANCE_TYPE initialization parameter, 1.86

instances

checkpoint, 1.110

startup order, 1.85

I/O

reading multiple blocks, 1.45

redo log files, 1.109

J

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, 1.87

JAVA_POOL_SIZE, 1.88

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.89

Java scripts, B.5

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.87

JAVA_POOL_SIZE initialization parameter, 1.88

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.89

JOB_QUEUE_PROCESSES initialization parameter, 1.90

L

language

database default language, 1.127

LARGE_POOL_SIZE initialization parameter, 1.91

LDAP_DIRECTORY_ACCESS initialization parameter, 1.92

LICENSE_MAX_SESSIONS initialization parameter, 1.93

LICENSE_MAX_USERS initialization parameter, 1.94

LICENSE_SESSIONS_WARNING initialization parameter, 1.95

licenses

maximum sessions, 1.93

maximum users, 1.94

warning for concurrent user sessions, 1.95

limits on the database, A

linguistic sorts, 1.131

local currency, 1.122

LOCAL_LISTENER initialization parameter, 1.96

LOCK_NAME_SPACE initialization parameter, 1.97

LOCK_SGA initialization parameter, 1.98

locks

names, C.3

LOG_ARCHIVE_CONFIG initialization parameter, 1.99

LOG_ARCHIVE_DEST initialization parameter, 1.100

LOG_ARCHIVE_DEST_n initialization parameter, 1.101

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.102

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.103

LOG_ARCHIVE_FORMAT initialization parameter, 1.104

LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.105

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.106

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.107

LOG_ARCHIVE_TRACE initialization parameter, 1.108

LOG_BUFFER initialization parameter, 1.109

LOG_CHECKPOINT_INTERVAL initialization parameter, 1.110

LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.111

LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.112

LOG_FILE_NAME_CONVERT initialization parameter, 1.113

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1.114

lowercase significance, 1.3.2.1.1

M

MAP_OBJECT table, 3.426

MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1.115

MAX_DISPATCHERS initialization parameter, 1.116

MAX_DUMP_FILE_SIZE initialization parameter, 1.117

MAX_ENABLED_ROLES initialization parameter, 1.118

MAX_SHARED_SERVERS initialization parameter, 1.119

memory

amount used for sorting, 1.199

virtual, 1.1.1.3

monitor

performance, 1.110

multiple-process systems

number of processes, 1.167

N

NLS_CALENDAR initialization parameter, 1.120

NLS_COMP initialization parameter, 1.121

NLS_CURRENCY initialization parameter, 1.122

defined by NLS_TERRITORY, 1.132

NLS_DATABASE_PARAMETERS view, 3.427

NLS_DATE_FORMAT initialization parameter, 1.123

defined by NLS_NUMERIC_CHARACTERS, 1.130

defined by NLS_TERRITORY, 1.132

NLS_DATE_LANGUAGE initialization parameter, 1.124

NLS_DUAL_CURRENCY initialization parameter, 1.125

NLS_INSTANCE_PARAMETERS view, 3.428

NLS_ISO_CURRENCY initialization parameter, 1.126

defined by NLS_TERRITORY, 1.132

NLS_LANGUAGE initialization parameter, 1.127

NLS_LENGTH_SEMANTICS initialization parameter, 1.128

NLS_NCHAR_CONV_EXCP initialization parameter, 1.129

NLS_NUMERIC_CHARACTERS initialization parameter, 1.130

NLS_SESSION_PARAMETERS view, 3.429

NLS_SORT initialization parameter, 1.131

NLS_TERRITORY initialization parameter, 1.132

NLS_TIMESTAMP_FORMAT initialization parameter, 1.133

NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.134

numeric group separators, 1.130

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.135

OBJ synonym for USER_OBJECTS view, 3.430

OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.136

OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.137

objects

data dictionary, 2.1

OLAP_PAGE_POOL_SIZE initialization parameter, 1.138

online redo log

archiving mode, 1.100

block, 1.110

file size, 1.110

setting checkpoint interval, 1.110

OPEN_CURSORS initialization parameter, 1.139

OPEN_LINKS initialization parameter, 1.140

OPEN_LINKS_PER_INSTANCE initialization parameter, 1.141

operating system

authenticating remote clients, 1.177

authenticating users and passwords, 1.147

dependent parameters, 1.1.1.2

roles for remote clients, 1.178

optimization

trading cursor space for time, 1.34

OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.142

OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.143

OPTIMIZER_INDEX_CACHING initialization parameter, 1.144

OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.145

OPTIMIZER_MODE 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.177

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.176

PCM lock

mapping blocks to, 1.75

performance, 1.1.1.3

shared pool, 1.194

PGA_AGGREGATE_TARGET initialization parameter, 1.157

PLAN_TABLE table, 3.431

PLSQL_CODE_TYPE initialization parameter, 1.158

PLSQL_COMPILER_FLAGS initialization parameter, 1.159

PLSQL_DEBUG initialization parameter, 1.160

PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1.161

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1.162

PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.163

PLSQL_V2_COMPATIBILITY initialization parameter, 1.164

PLSQL_WARNINGS initialization parameter, 1.165

PLUGGABLE_SET_CHECK view, 3.432

PRE_PAGE_SGA initialization parameter, 1.166

privileges

remote login, 1.176

RESTRICTED_SESSION privilege, 1.93, 1.95

table-level select privileges, 1.203

procedures

shared pool, 1.194

processes

derived parameter values, 1.216

dispatcher process maximum number, 1.116

maximum shared server processes, 1.119

number of server processes, 1.87, 1.89, 1.195, 1.196

recovery, 1.172

trace files, 1.222

user processes, 1.167

PROCESSES initialization parameter, 1.167

PRODUCT_COMPONENT_VERSION view, 3.433

profiles

resource limits, 1.180, 1.181

PROXY_USERS view, 3.434

PSTUBTBL view, 3.435

PUBLIC clause

of ALTER DATABASE

thread of redo, 1.211

PUBLIC_DEPENDENCY view, 3.436

PUBLICSYN view, 3.437

Q

queries

dictionary views, 1.75

hints, 1.146

QUERY_REWRITE_ENABLED initialization parameter, 1.168

QUERY_REWRITE_INTEGRITY initialization parameter, 1.169

QUEUE_PRIVILEGES view, 3.438

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

RDBMS_SERVER_DN initialization parameter, 1.170

READ_ONLY_OPEN_DELAYED initialization parameter, 1.171

Real Application Clusters

dynamic performance views, 4.1.2

initialization parameters

CIRCUITS, 1.21

CLUSTER_DATABASE, 1.22

CLUSTER_DATABASE_INSTANCES, 1.23

CLUSTER_INTERCONNECTS, 1.24

DISPATCHERS, 1.61

FAST_START_PARALLEL_ROLLBACK, 1.70

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

RECOVERY_PARALLELISM initialization parameter, 1.172

RECYCLEBIN synonym for USER_RECYCLEBIN view, 3.439

redo logs

buffer size, 1.109

redo thread, 1.211

remote clients

authenticating, 1.177

remote logins, 1.176

REMOTE_ARCHIVE_ENABLE initialization parameter, 1.173

REMOTE_DEPENDENCIES_MODE initialization parameter, 1.174

REMOTE_LISTENER initialization parameter, 1.175

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.176

REMOTE_OS_AUTHENT initialization parameter, 1.177

REMOTE_OS_ROLES initialization parameter, 1.178

REPAIR_TABLE view. See DBA_REPAIR_TABLE view.

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.179

resource limits for profiles, 1.180, 1.181

RESOURCE_COST view, 3.440

RESOURCE_LIMIT initialization parameter, 1.180

RESOURCE_MANAGER_PLAN initialization parameter, 1.181

RESOURCE_MAP table, 3.441

RESUMABLE_TIMEOUT initialization parameter, 1.182

RMJVM.SQL script, B.5

ROLE_ROLE_PRIVS view, 3.442

ROLE_SYS_PRIVS view, 3.443

ROLE_TAB_PRIVS view, 3.444

ROLE_WM_PRIVS view, 2.1.2

roles, 1.148

remote clients, 1.178

ROLLBACK_SEGMENTS initialization parameter, 1.183

S

scripts

CATALOG.SQL, B.1

CATBLOCK.SQL, B.2

CATCLUST.SQL, B.1

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

D0902000.SQL, B.4

data dictionary, B.2

DBMSIOTC.SQL, B.2

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

U0800060.SQL, B.4

U0801070.SQL, B.4

U0900010.SQL, B.4

U0902000.SQL, B.4

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, 3.445

SERIAL_REUSE initialization parameter, 1.184

server parameter file

overview, 1.3

server processes

number, 1.87, 1.89, 1.195, 1.196

SERVICE_NAMES initialization parameter, 1.185

SESSION_CACHED_CURSORS initialization parameter, 1.186

SESSION_CONTEXT view, 3.446

SESSION_MAX_OPEN_FILES initialization parameter, 1.187

SESSION_PRIVS view, 3.447

SESSION_ROLES view, 3.448

SESSIONS initialization parameter, 1.188

SGA_MAX_SIZE initialization parameter, 1.189

SGA_TARGET initialization parameter, 1.190

SHADOW_CORE_DUMP initialization parameter, 1.191

shared server

SESSIONS initialization parameter, 1.188

shared server processes

maximum number, 1.119

SHARED_MEMORY_ADDRESS initialization parameter, 1.192

SHARED_POOL_RESERVED_SIZE initialization parameter, 1.193

SHARED_POOL_SIZE initialization parameter, 1.194

SHARED_SERVER_SESSIONS initialization parameter, 1.195

SHARED_SERVERS initialization parameter, 1.196

SHOW PARAMETERS command, 1.4.3

SKIP_UNUSABLE_INDEXES initialization parameter, 1.197

SMTP_OUT_SERVER initialization parameter, 1.198

SORT_AREA_RETAINED_SIZE initialization parameter, 1.199

SORT_AREA_SIZE initialization parameter, 1.200

sorting

maximum memory, 1.199

ORDER BY queries, 1.131

SOURCE_SIZE view, 3.449

SPFILE initialization parameter, 1.201

SQL scripts

creating the data dictionary, B.1

optional, B.2

required, B.1

SQL_TRACE initialization parameter, 1.202

SQL92_SECURITY initialization parameter, 1.203

SQLTUNE_CATEGORY initialization parameter, 1.204

STANDBY_ARCHIVE_DEST initialization parameter, 1.205

STANDBY_FILE_MANAGEMENT initialization parameter, 1.206

STAR_TRANSFORMATION_ENABLED initialization parameter, 1.207

starting up

instance number, 1.85

startup order, 1.85

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

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

DBWR buffers scanned, E.2

DBWR checkpoint buffers written, E.2

DBWR checkpoints, 1.110, 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 cr block log flush time, E.2, E.2

global cache cr block send time, 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

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 reads, E.2

physical reads direct, E.2

physical writes, E.2

physical writes direct, 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.213

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

STMT_AUDIT_OPTION_MAP table, 3.450

STREAMS_POOL_SIZE initialization parameter, 1.209

switch redo log file, 1.110

SYN synonym for USER_SYNONYMS view, 3.451

SYNONYMS view, 3.452

SYS_OBJECTS view, 3.457

SYSCATALOG view, 3.453

SYSFILES view, 3.454

SYSSEGOBJ view, 3.455

system global area, 1.1.1.3

buffer areas, 1.109

maximum concurrent transactions, 1.216

system performance, 1.1.1.3

SYSTEM_PRIVILEGE_MAP table, 3.456

T

TAB view, 3.458

TABLE_PRIVILEGE_MAP table, 3.459

tables

data dictionary, 2.1

DML locks, 1.63

locating free space, 1.85

TABQUOTAS view, 3.461

TABS synonym for USER_TABLES view, 3.460

tape archiving destination, 1.100

TAPE_ASYNCH_IO initialization parameter, 1.210

territory, 1.125, 1.132

THREAD initialization parameter, 1.211

TIMED_OS_STATISTICS initialization parameter, 1.212

TIMED_STATISTICS initialization parameter, 1.213

file read/write statistics, 4.85, 5.144

TO_CHAR function, 1.123

TO_DATE function, 1.123

trace files

destination, 1.222

maximum size, 1.117

TRACE_ENABLED initialization parameter, 1.214

TRACEFILE_IDENTIFIER initialization parameter, 1.215

transactions

concurrent, 1.216

data locking, 1.63

TRANSACTIONS initialization parameter, 1.216

DML locks, 1.63

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.217

TRUSTED_SERVERS view, 3.462

TS_PITR_CHECK view, 3.463

TS_PITR_OBJECTS TO_BE_DROPPED view, 3.464

U

U0800060.SQL script, B.4

U0801070.SQL script, B.4

U0900010.SQL script, B.4

U0902000.SQL script, B.4

UNDO_MANAGEMENT initialization parameter, 1.218

UNDO_RETENTION initialization parameter, 1.219

UNDO_TABLESPACE initialization parameter, 1.220

UNI_PLUGGABLE_SET_CHECK view, 3.465

updates

locating free space, 1.85

upgrading

scripts, B.4

uppercase characters, 1.3.2.1.1

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.221

user processes

trace files, 1.222

USER_ADVISOR_ACTIONS view, 3.466

USER_ADVISOR_FINDINGS view, 3.467

USER_ADVISOR_JOURNAL view, 3.468

USER_ADVISOR_LOG view, 3.469

USER_ADVISOR_OBJECTS view, 3.470

USER_ADVISOR_PARAMETERS view, 3.471

USER_ADVISOR_RATIONALE view, 3.472

USER_ADVISOR_RECOMMENDATIONS view, 3.473

USER_ADVISOR_SQLA_REC_SUM view, 3.474

USER_ADVISOR_SQLA_WK_MAP view, 3.475

USER_ADVISOR_SQLA_WK_STMTS view, 3.476

USER_ADVISOR_SQLW_JOURNAL view, 3.477

USER_ADVISOR_SQLW_PARAMETERS view, 3.478

USER_ADVISOR_SQLW_STMTS view, 3.479

USER_ADVISOR_SQLW_SUM view, 3.480

USER_ADVISOR_SQLW_TABLES view, 3.481

USER_ADVISOR_SQLW_TEMPLATES view, 3.482

USER_ADVISOR_TASKS view, 3.483

USER_ADVISOR_TEMPLATES view, 3.484

USER_ALL_TABLES view, 3.485

USER_AQ_AGENT_PRIVS view, 3.486

USER_ARGUMENTS view, 3.487

USER_ASSOCIATIONS view, 3.488

USER_ATTRIBUTE_TRANSFORMATIONS view, 3.489

USER_AUDIT_OBJECT view, 3.490

USER_AUDIT_POLICIES view, 3.491

USER_AUDIT_POLICY_COLUMNS view, 3.492

USER_AUDIT_SESSION view, 3.493

USER_AUDIT_STATEMENT view, 3.494

USER_AUDIT_TRAIL view, 3.495

USER_AW_PS view, 3.496

USER_AWS view, 3.497

USER_BASE_TABLE_MVIEWS view, 3.498

USER_CATALOG view, 3.499

CAT synonym, 2.211

USER_CLU_COLUMNS view, 3.500

USER_CLUSTER_HASH_EXPRESSIONS view, 3.501

USER_CLUSTERS view, 3.502

CLU synonym, 2.216

USER_COL_COMMENTS view, 3.503

USER_COL_PRIVS view, 3.504

USER_COL_PRIVS_MADE view, 3.505

USER_COL_PRIVS_RECD view, 3.506

USER_COLL_TYPES view, 3.507

USER_CONS_COLUMNS view, 3.508

USER_CONS_OBJ_COLUMNS view, 3.509

USER_CONSTRAINTS view, 3.510

USER_DATAPUMP_JOBS view, 3.511

USER_DB_LINKS view, 3.512

USER_DEPENDENCIES view, 3.513

USER_DIM_ATTRIBUTES view, 3.514

USER_DIM_CHILD_OF view, 3.515

USER_DIM_HIERARCHIES view, 3.516

USER_DIM_JOIN_KEY view, 3.517

USER_DIM_LEVEL_KEY view, 3.518

USER_DIM_LEVELS view, 3.519

USER_DIMENSIONS view, 3.520

USER_DUMP_DEST initialization parameter, 1.222

USER_ERRORS view, 3.521

USER_EVALUATION_CONTEXT_TABLES view, 3.522

USER_EVALUATION_CONTEXT_VARS view, 3.523

USER_EVALUATION_CONTEXTS view, 3.524

USER_EXTENTS view, 3.525

USER_EXTERNAL_LOCATIONS view, 3.526

USER_EXTERNAL_TABLES view, 3.527

USER_FREE_SPACE view, 3.528

USER_IND_COLUMNS view, 3.529

USER_IND_EXPRESSIONS view, 3.530

USER_IND_PARTITIONS view, 3.531

USER_IND_STATISTICS view, 3.532

USER_IND_SUBPARTITIONS view, 3.533

USER_INDEXES view, 3.534

IND synonym, 3.423

USER_INDEXTYPE_ARRAYTYPES view, 3.535

USER_INDEXTYPE_COMMENTS view, 3.536

USER_INDEXTYPE_OPERATORS view, 3.537

USER_INDEXTYPES view, 3.538

USER_INTERNAL_TRIGGERS view, 3.539

USER_JAVA_ARGUMENTS view, 3.540

USER_JAVA_CLASSES view, 3.541

USER_JAVA_DERIVATIONS view, 3.542

USER_JAVA_FIELDS view, 3.543

USER_JAVA_IMPLEMENTS view, 3.544

USER_JAVA_INNERS view, 3.545

USER_JAVA_LAYOUTS view, 3.546

USER_JAVA_METHODS view, 3.547

USER_JAVA_NCOMPS view, 3.548

USER_JAVA_POLICY view, 3.549

USER_JAVA_RESOLVERS view, 3.550

USER_JAVA_THROWS view, 3.551

USER_JOBS view, 3.552

USER_JOIN_IND_COLUMNS view, 3.553, 3.553

USER_LIBRARIES view, 3.554

USER_LOB_PARTITIONS view, 3.555

USER_LOB_SUBPARTITIONS view, 3.556

USER_LOB_TEMPLATES view, 3.557

USER_LOBS view, 3.558

USER_LOG_GROUP_COLUMNS view, 3.559

USER_LOG_GROUPS view, 3.560

USER_METHOD_PARAMS view, 3.561

USER_METHOD_RESULTS view, 3.562

USER_MVIEW_AGGREGATES view, 3.563

USER_MVIEW_ANALYSIS view, 3.564

USER_MVIEW_COMMENTS view, 3.565

USER_MVIEW_DETAIL_RELATIONS view, 3.566

USER_MVIEW_JOINS view, 3.567

USER_MVIEW_KEYS view, 3.568

USER_MVIEW_LOGS view, 3.569

USER_MVIEW_REFRESH_TIMES view, 3.570

USER_MVIEWS view, 3.571

USER_NESTED_TABLE_COLS view, 3.572

USER_NESTED_TABLES view, 3.573

USER_OBJ_AUDIT_OPTS view, 3.574

USER_OBJ_COLATTRS view, 3.575

USER_OBJECT_SIZE view, 3.576

USER_OBJECT_TABLES view, 3.577

USER_OBJECTS view, 3.578

OBJ synonym, 3.430

USER_OPANCILLARY view, 3.579

USER_OPARGUMENTS view, 3.580

USER_OPBINDINGS view, 3.581

USER_OPERATOR_COMMENTS view, 3.582

USER_OPERATORS view, 3.583

USER_OUTLINE_HINTS view, 3.584

USER_OUTLINES view, 3.585

USER_PART_COL_STATISTICS view, 3.586

USER_PART_HISTOGRAMS view, 3.587

USER_PART_INDEXES view, 3.588

USER_PART_KEY_COLUMNS view, 3.589

USER_PART_LOBS view, 3.590

USER_PART_TABLES view, 3.591

USER_PARTIAL_DROP_TABS view, 3.592

USER_PASSWORD_LIMITS view, 3.593

USER_PENDING_CONV_TABLES view, 3.594

USER_PLSQL_OBJECT_SETTINGS view, 3.595

USER_POLICIES view, 3.596

USER_POLICY_CONTEXTS view, 3.597

USER_POLICY_GROUPS view, 3.598

USER_PROCEDURES view, 3.599

USER_PROXIES view, 3.600

USER_PUBLISHED_COLUMNS view, 3.601

USER_QUEUE_SCHEDULES view, 3.602

USER_QUEUE_TABLES view, 3.603

USER_QUEUES view, 3.604

USER_RECYCLEBIN view, 3.605

RECYCLEBIN synonym, 3.439

USER_REFRESH view, 3.606

USER_REFRESH_CHILDREN view, 3.607

USER_REFS view, 3.608

USER_REGISTERED_MVIEWS view, 3.609

USER_REGISTRY view, 3.610

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, 3.611

USER_RESUMABLE view, 3.612

USER_REWRITE_EQUIVALENCES view, 3.613

USER_ROLE_PRIVS view, 3.614

USER_RSRC_CONSUMER_GROUP_PRIVS view, 3.615

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 3.616

USER_RULE_SET_RULES view, 3.617

USER_RULE_SETS view, 3.618

USER_RULES view, 3.619

USER_SCHEDULER_JOB_ARGS view, 3.620

USER_SCHEDULER_JOB_LOG view, 3.621

USER_SCHEDULER_JOB_RUN_DETAILS view, 3.622

USER_SCHEDULER_JOBS view, 3.623

USER_SCHEDULER_PROGRAM_ARGS view, 3.624

USER_SCHEDULER_PROGRAMS view, 3.625

USER_SCHEDULER_RUNNING_JOBS view, 3.626

USER_SCHEDULER_SCHEDULES view, 3.627

USER_SEC_RELEVANT_COLS view, 3.628

USER_SEGMENTS view, 3.629

USER_SEQUENCES view, 3.630

SEQ synonym, 3.445

USER_SOURCE view, 3.631

USER_SOURCE_TABLES view, 3.632

USER_SQLJ_TYPE_ATTRS view, 3.633

USER_SQLJ_TYPE_METHODS view, 3.634

USER_SQLJ_TYPES view, 3.635

USER_SQLSET view, 3.636

USER_SQLSET_BINDS view, 3.637

USER_SQLSET_REFERENCES view, 3.638

USER_SQLSET_STATEMENTS view, 3.639

USER_SQLTUNE_BINDS view, 3.640

USER_SQLTUNE_PLANS view, 3.641

USER_SQLTUNE_RATIONALE_PLAN view, 3.642

USER_SQLTUNE_STATISTICS view, 3.643

USER_STORED_SETTINGS view, 3.644

USER_SUBPART_COL_STATISTICS view, 3.645

USER_SUBPART_HISTOGRAMS view, 3.646

USER_SUBPART_KEY_COLUMNS view, 3.647

USER_SUBPARTITION_TEMPLATES view, 3.648

USER_SUBSCRIBED_COLUMNS view, 3.649

USER_SUBSCRIBED_TABLES view, 3.650

USER_SUBSCRIPTIONS view, 3.651

USER_SYNONYMS view, 3.652

SYN synonym, 3.451

USER_SYS_PRIVS view, 3.653

USER_TAB_COL_STATISTICS view, 3.654

USER_TAB_COLS view, 3.655

USER_TAB_COLUMNS view, 3.656

COLS synonym, 2.218

USER_TAB_COMMENTS view, 3.657

USER_TAB_HISTOGRAMS view, 3.658

USER_TAB_MODIFICATIONS view, 3.659

USER_TAB_PARTITIONS view, 3.660

USER_TAB_PRIVS view, 3.661

USER_TAB_PRIVS_MADE view, 3.662

USER_TAB_PRIVS_RECD view, 3.663

USER_TAB_STATISTICS view, 3.664

USER_TAB_SUBPARTITIONS view, 3.665

USER_TABLES view, 3.666

TABS synonym, 3.460

USER_TABLESPACES view, 3.667

USER_TRANSFORMATIONS view, 3.668

USER_TRIGGER_COLS view, 3.669

USER_TRIGGERS view, 3.670

USER_TS_QUOTAS view, 3.671

USER_TUNE_MVIEW view, 3.672

USER_TYPE_ATTRS view, 3.673

USER_TYPE_METHODS view, 3.674

USER_TYPE_VERSIONS view, 3.675

USER_TYPES view, 3.676

USER_UNUSED_COL_TABS view, 3.677

USER_UPDATABLE_COLUMNS view, 3.678

USER_USERS view, 3.679

USER_USTATS view, 3.680

USER_VARRAYS view, 3.681

USER_VIEWS view, 3.682

USER_WARNING_SETTINGS view, 3.683

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, 3.684

USER_XML_TAB_COLS view, 3.685

USER_XML_TABLES view, 3.686

USER_XML_VIEW_COLS view, 3.687

USER_XML_VIEWS view, 3.688

USERLOCK.SQL script, B.2

users

authenticating, 1.147

multiple, 1.63

UTL_FILE_DIR initialization parameter, 1.223

UTLBSTAT.SQL script, B.2

UTLCHN1.SQL script, B.2

UTLCONST.SQL script, B.2

UTLDTREE.SQL script, 3.402, 3.422, 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, 4.3

V$ACTIVE_INSTANCES view, 4.4

V$ACTIVE_SERVICES view, 4.5

V$ACTIVE_SESS_POOL_MTH view, 4.6

V$ACTIVE_SESSION_HISTORY view, 4.7

V$ALERT_TYPES view, 4.8

V$AQ view, 4.9

V$ARCHIVE view, 4.10

V$ARCHIVE_DEST view, 4.11

V$ARCHIVE_DEST_STATUS view, 4.12

V$ARCHIVE_GAP view, 4.13

V$ARCHIVE_PROCESSES view, 4.14

V$ARCHIVED_LOG view, 4.15

V$ASM_ALIAS view, 4.16

V$ASM_CLIENT view, 4.17

V$ASM_DISK view, 4.18

V$ASM_DISKGROUP view, 4.19

V$ASM_FILE view, 4.20

V$ASM_OPERATION view, 4.21

V$ASM_TEMPLATE view, 4.22

V$BACKUP view, 4.23

V$BACKUP_ASYNC_IO view, 4.24

V$BACKUP_CORRUPTION view, 4.25

V$BACKUP_DATAFILE view, 4.26

V$BACKUP_DEVICE view, 4.27

V$BACKUP_FILES view, 4.28

V$BACKUP_PIECE view, 4.29

V$BACKUP_REDOLOG view, 4.30

V$BACKUP_SET view, 4.31

V$BACKUP_SPFILE view, 4.32

V$BACKUP_SYNC_IO view, 4.33

V$BGPROCESS view, 4.34

V$BH view, 4.35

V$BLOCK_CHANGE_TRACKING view, 4.36

V$BUFFER_POOL view, 4.37

V$BUFFER_POOL_STATISTICS view, 4.38

V$BUFFERED_PUBLISHERS view, 4.39

V$BUFFERED_QUEUES view, 4.40

V$BUFFERED_SUBSCRIBERS view, 4.41

V$CACHE view, 4.42

V$CACHE_LOCK view, 4.43

V$CACHE_TRANSFER view, 4.44

V$CIRCUIT view, 4.45

V$CLASS_CACHE_TRANSFER view, 4.46

V$CLIENT_STATS view, 4.47

V$CONTEXT view, 4.48

V$CONTROLFILE view, 4.49

V$CONTROLFILE_RECORD_SECTION view, 4.50

V$COPY_CORRUPTION view, 4.51

V$CR_BLOCK_SERVER view, 4.52

V$CURRENT_BLOCK_SERVER view, 4.53

V$DATABASE view, 4.54

V$DATABASE_BLOCK_CORRUPTION view, 4.55

V$DATABASE_INCARNATION view, 4.56

V$DATAFILE view, 4.57

V$DATAFILE_COPY view, 4.58

V$DATAFILE_HEADER view, 4.59

V$DATAGUARD_CONFIG view, 4.60

V$DATAGUARD_STATUS view, 4.61

V$DB_CACHE_ADVICE view, 4.62

V$DB_OBJECT_CACHE view, 4.63

V$DB_PIPES view, 4.64

V$DBFILE view, 4.65

V$DBLINK view, 4.66

V$DELETED_OBJECT view, 4.67

V$DISPATCHER view, 4.68

V$DISPATCHER_CONFIG view, 4.69

V$DISPATCHER_RATE view, 4.70

V$ENABLEDPRIVS view, 4.71

V$ENQUEUE_LOCK view, 4.72

V$ENQUEUE_STAT view, 4.73

V$EVENT_HISTOGRAM view, 4.74

V$EVENT_NAME view, 4.75

V$EVENTMETRIC view, 4.76

V$EXECUTION view, 4.77

V$FALSE_PING view, 4.78

V$FAST_START_SERVERS view, 4.79

V$FAST_START_TRANSACTIONS view, 4.80

V$FILE_CACHE_TRANSFER view, 4.81

V$FILE_HISTOGRAM view, 4.82

V$FILEMETRIC view, 4.83

V$FILEMETRIC_HISTORY view, 4.84

V$FILESTAT view, 4.85

V$FIXED_TABLE view, 4.86

V$FIXED_VIEW_DEFINITION view, 4.87

V$FLASHBACK_DATABASE_LOG view, 4.88

V$FLASHBACK_DATABASE_STAT view, 4.89

V$GC_ELEMENT view, 4.90

V$GC_ELEMENTS_WITH_COLLISIONS view, 4.91

V$GCSHVMASTER_INFO view, 4.92

V$GCSPFMASTER_INFO view, 4.93

V$GES_BLOCKING_ENQUEUE view, 4.94

V$GES_CONVERT_LOCAL view, 4.95

V$GES_CONVERT_REMOTE view, 4.96

V$GES_ENQUEUE view, 4.97

V$GES_LATCH view, 4.98

V$GES_RESOURCE view, 4.99

V$GES_STATISTICS view, 4.100

V$GLOBAL_BLOCKED_LOCKS view, 4.101

V$GLOBAL_TRANSACTION view, 4.102

V$HS_AGENT view, 4.103

V$HS_PARAMETER view, 4.104

V$HS_SESSION view, 4.105

V$HVMASTER_INFO view, 4.106

V$INDEXED_FIXED_COLUMN view, 4.107

V$INSTANCE view, 4.108

V$INSTANCE_RECOVERY view, 4.109

V$JAVA_LIBRARY_CACHE_MEMORY view, 4.110

V$JAVA_POOL_ADVICE view, 4.111

V$LATCH view, 4.112

V$LATCH_CHILDREN view, 4.113

V$LATCH_MISSES view, 4.114

V$LATCH_PARENT view, 4.115

V$LATCHHOLDER view, 4.116

V$LATCHNAME view, 4.117

V$LIBRARY_CACHE_MEMORY view, 4.118

V$LIBRARYCACHE view, 4.119

V$LICENSE view, 4.120

V$LOADISTAT view, 4.121

V$LOADPSTAT view, 4.122

V$LOCK view, 4.123

V$LOCK_ACTIVITY view, 4.124

V$LOCKED_OBJECT view, 4.125

V$LOG view, 4.126

V$LOG_HISTORY view, 4.127

V$LOGFILE view, 4.128

V$LOGHIST view, 4.129

V$LOGMNR_CONTENTS view, 4.130

V$LOGMNR_DICTIONARY view, 4.131

V$LOGMNR_LOGS view, 4.132

V$LOGMNR_PARAMETERS view, 4.133

V$LOGSTDBY view, 4.134

V$LOGSTDBY_STATS view, 4.135

V$MANAGED_STANDBY view, 4.136

V$MAP_COMP_LIST view, 4.137

V$MAP_ELEMENT view, 4.138

V$MAP_EXT_ELEMENT view, 4.139

V$MAP_FILE view, 4.140

V$MAP_FILE_EXTENT view, 4.141

V$MAP_FILE_IO_STACK view, 4.142

V$MAP_LIBRARY view, 4.143

V$MAP_SUBELEMENT view, 4.144

V$METRICNAME view, 4.145

V$MTTR_TARGET_ADVICE view, 4.146

V$MVREFRESH view, 4.147

V$MYSTAT view, 4.148

V$NLS_PARAMETERS view, 5.1

V$NLS_VALID_VALUES view, 5.2

V$OBJECT_DEPENDENCY view, 5.3

V$OBJECT_USAGE view, 5.4

V$OBSOLETE_BACKUP_FILES view, 5.5

V$OBSOLETE_PARAMETER view, 5.6

V$OFFLINE_RANGE view, 5.7

V$OPEN_CURSOR view, 5.8

V$OPTION view, 5.9

V$OSSTAT view, 5.10

V$PARALLEL_DEGREE_LIMIT_MTH view, 5.11

V$PARAMETER view, 5.12

V$PARAMETER2 view, 5.13

V$PGA_TARGET_ADVICE view, 5.14

V$PGA_TARGET_ADVICE_HISTOGRAM view, 5.15

V$PGASTAT view, 5.16

V$PQ_SESSTAT view, 5.17

V$PQ_SLAVE view, 5.18

V$PQ_SYSSTAT view, 5.19

V$PQ_TQSTAT view, 5.20

V$PROCESS view, 5.21

V$PROPAGATION_RECEIVER view, 5.22

V$PROPAGATION_SENDER view, 5.23

V$PROXY_ARCHIVEDLOG view, 5.24

V$PROXY_DATAFILE view, 5.25

V$PWFILE_USERS view, 5.26

V$PX_PROCESS view, 5.27

V$PX_PROCESS_SYSSTAT view, 5.28

V$PX_SESSION view, 5.29

V$PX_SESSTAT view, 5.30

V$QUEUE view, 5.31

V$QUEUEING_MTH view, 5.32

V$RECOVER_FILE view, 5.33

V$RECOVERY_FILE_DEST view, 5.34

V$RECOVERY_FILE_STATUS view, 5.35

V$RECOVERY_LOG view, 5.36

V$RECOVERY_PROGRESS view, 5.37

V$RECOVERY_STATUS view, 5.38

V$REPLPROP view, 5.39

V$REPLQUEUE view, 5.40

V$REQDIST view, 5.41

V$RESERVED_WORDS view, 5.42

V$RESOURCE view, 5.43

V$RESOURCE_LIMIT view, 5.44

V$RMAN_CONFIGURATION view, 5.45

V$RMAN_OUTPUT view, 5.46

V$RMAN_STATUS view, 5.47

V$ROLLNAME view, 5.48

V$ROLLSTAT view, 5.49

V$ROWCACHE view, 5.50

V$ROWCACHE_PARENT view, 5.51

V$ROWCACHE_SUBORDINATE view, 5.52

V$RSRC_CONSUMER_GROUP view, 5.53

V$RSRC_CONSUMER_GROUP_CPU_MTH view, 5.54

V$RSRC_PLAN view, 5.55

V$RSRC_PLAN_CPU_MTH view, 5.56

V$RULE view, 5.57

V$RULE_SET view, 5.58

V$RULE_SET_AGGREGATE_STATS view, 5.59

V$SEGMENT_STATISTICS view, 5.60

V$SEGSTAT view, 5.61

V$SEGSTAT_NAME view, 5.62

V$SERV_MOD_ACT_STATS view, 5.63

V$SERVICE_EVENT view, 5.64

V$SERVICE_STATS view, 5.65

V$SERVICE_WAIT_CLASS view, 5.66

V$SERVICEMETRIC view, 5.67

V$SERVICEMETRIC_HISTORY view, 5.68

V$SERVICES view, 5.69

V$SES_OPTIMIZER_ENV view, 5.70

V$SESS_IO view, 5.71

V$SESS_TIME_MODEL view, 5.72

V$SESSION view, 5.73

V$SESSION_CONNECT_INFO view, 5.74

V$SESSION_CURSOR_CACHE view, 5.75

V$SESSION_EVENT view, 5.76, C.1

V$SESSION_LONGOPS view, 5.77

V$SESSION_OBJECT_CACHE view, 5.78

V$SESSION_WAIT view, 5.79, C.1

V$SESSION_WAIT_CLASS view, 5.80

V$SESSION_WAIT_HISTORY view, 5.81

V$SESSMETRIC view, 5.82

V$SESSTAT view, 5.83, E, E.1

V$SGA view, 5.84

V$SGA_CURRENT_RESIZE_OPS view, 5.85

V$SGA_DYNAMIC_COMPONENTS view, 5.86

V$SGA_DYNAMIC_FREE_MEMORY view, 5.87

V$SGA_RESIZE_OPS view, 5.88

V$SGAINFO view, 5.89

V$SGASTAT view, 5.90

V$SHARED_POOL_ADVICE view, 5.91

V$SHARED_POOL_RESERVED view, 5.92

V$SHARED_SERVER view, 5.93

V$SHARED_SERVER_MONITOR view, 5.94

V$SORT_SEGMENT view, 5.95

V$SPPARAMETER view, 5.96

V$SQL view, 5.97

V$SQL_BIND_CAPTURE view, 5.98

V$SQL_BIND_DATA view, 5.99

V$SQL_BIND_METADATA view, 5.100

V$SQL_CURSOR view, 5.101

V$SQL_OPTIMIZER_ENV view, 5.102

V$SQL_PLAN view, 5.103

V$SQL_PLAN_STATISTICS view, 5.104

V$SQL_PLAN_STATISTICS_ALL view, 5.105

V$SQL_REDIRECTION view, 5.106

V$SQL_SHARED_CURSOR view, 5.107

V$SQL_SHARED_MEMORY view, 5.108

V$SQL_WORKAREA view, 5.109

V$SQL_WORKAREA_ACTIVE view, 5.110

V$SQL_WORKAREA_HISTOGRAM view, 5.111

V$SQLAREA view, 5.112

V$SQLTEXT view, 5.113

V$SQLTEXT_WITH_NEWLINES view, 5.114

V$STANDBY_LOG view, 5.115

V$STATISTICS_LEVEL view, 5.116

V$STATNAME view, 5.117, E.1

V$STREAMS_APPLY_COORDINATOR view, 5.118

V$STREAMS_APPLY_READER view, 5.119

V$STREAMS_APPLY_SERVER view, 5.120

V$STREAMS_CAPTURE view, 5.121

V$SUBCACHE view, 5.122

V$SYS_OPTIMIZER_ENV view, 5.123

V$SYS_TIME_MODEL view, 5.124

V$SYSAUX_OCCUPANTS view, 5.125

V$SYSMETRIC view, 5.126

V$SYSMETRIC_HISTORY view, 5.127

V$SYSMETRIC_SUMMARY view, 5.128

V$SYSSTAT view, 5.129, E

V$SYSTEM_CURSOR_CACHE view, 5.130

V$SYSTEM_EVENT view, 5.131, C.1

V$SYSTEM_PARAMETER view, 5.132

V$SYSTEM_PARAMETER2 view, 5.133

V$SYSTEM_WAIT_CLASS view, 5.134

V$TABLESPACE view, 5.135

V$TEMP_CACHE_TRANSFER view, 5.136

V$TEMP_EXTENT_MAP view, 5.137

V$TEMP_EXTENT_POOL view, 5.138

V$TEMP_HISTOGRAM view, 5.139

V$TEMP_SPACE_HEADER view, 5.140

V$TEMPFILE view, 5.141

V$TEMPORARY_LOBS view, 5.142

V$TEMPSEG_USAGE view, 5.143

V$TEMPSTAT view, 5.144

V$THREAD view, 5.145

V$THRESHOLD_TYPES view, 5.146

V$TIMER view, 5.147

V$TIMEZONE_NAMES view, 5.148

V$TRANSACTION view, 5.149

V$TRANSACTION_ENQUEUE view, 5.150

V$TRANSPORTABLE_PLATFORM view, 5.151

V$TYPE_SIZE view, 5.152

V$UNDOSTAT view, 5.153

V$VERSION view, 5.154

V$VPD_POLICY view, 5.155

V$WAITCLASSMETRIC view, 5.156

V$WAITCLASSMETRIC_HISTORY view, 5.157

V$WAITSTAT view, 5.158

views

data dictionary views, 2

data files, 1.75

W

wait events

alter system set dispatchers, C.4.1

batched allocate scn lock request, C.4.2

BFILE check if exists, C.4.3

BFILE check if open, C.4.4

BFILE closure, C.4.5

BFILE get length, C.4.6

BFILE get name object, C.4.7

BFILE get path object, C.4.8

BFILE internal seek, C.4.9

BFILE open, C.4.10

BFILE read, C.4.11

buffer busy waits, C.4.12

buffer deadlock, C.4.13

buffer for checkpoint, C.4.14

buffer latch, C.4.15

buffer read retry, C.4.16

checkpoint completed, C.4.17

checkpoint range buffer not saved, C.4.18

controlfile parallel write, C.4.19

controlfile sequential read, C.4.20

controlfile single write, C.4.21

conversion file read, C.4.22

db file parallel read, C.4.23

db file parallel write, C.4.24

db file scattered read, C.4.25

db file sequential read, C.4.26

db file single write, C.4.27

DFS db file lock, C.4.28

DFS lock handle, C.4.29

direct path read, C.4.30

direct path write, C.4.31

dispatcher shutdown, C.4.32

dispatcher timer, C.4.33

duplicate cluster key, C.4.34

enqueue, C.4.35

file identify, C.4.36

file open, C.4.37

free buffer waits, C.4.38

free global transaction table entry, C.4.39

free process state object, C.4.40

global cache busy, C.4.41

global cache freelist wait, C.4.43

global cache lock cleanup, C.4.42

global cache null to s, C.4.44

global cache null to x, C.4.45

global cache open s, C.4.46

global cache open x, C.4.47

global cache s to x, C.4.48

inactive session, C.4.49

inactive transaction branch, C.4.50

index block split, C.4.51

instance recovery, C.4.52

instance state change, C.4.53

io done, C.4.54

kcl bg acks, C.4.55

latch activity, C.4.56

latch free, C.4.57

library cache load lock, C.4.58

library cache lock, C.4.59

library cache pin, C.4.60

lock manager wait for remote message, C.4.61

log buffer space, C.4.62

log file parallel write, C.4.63

log file sequential read, C.4.64

log file single write, C.4.65

log file switch (archiving needed), C.4.66

log file switch (checkpoint incomplete), C.4.67

log file switch (clearing log file), C.4.68

log file switch completion, C.4.69

log file sync, C.4.70

log switch/archive, C.4.71

on-going SCN fetch to complete, C.4.72

pending global transaction(s), C.4.73

pipe get, C.4.74

pipe put, C.4.75

PL/SQL lock timer, C.4.76

pmon timer, C.4.77

process startup, C.4.78

PX dequeue wait, C.4.79

PX qref latch, C.4.80

PX server shutdown, C.4.81

PX signal server, C.4.82

queue messages, C.4.83

rdbms ipc message, C.4.84

rdbms ipc message block, C.4.85

rdbms ipc reply, C.4.86

redo wait, C.4.87

row cache lock, C.4.88

scginq AST call, C.4.89

single-task message, C.4.90

smon timer, C.4.91

SQL*Net break/reset to client, C.4.92

SQL*Net break/reset to dblink, C.4.93

SQL*Net message from client, C.4.94

SQL*Net message from dblink, C.4.95

SQL*Net message to client, C.4.96

SQL*Net message to dblink, C.4.97

SQL*Net more data from client, C.4.98

SQL*Net more data from dblink, C.4.99

SQL*Net more data to client, C.4.100

SQL*Net more data to dblink, C.4.101

switch logfile command, C.4.102

timer in sksawat, C.4.103

transaction, C.4.104

unbound tx, C.4.105

undo segment extension, C.4.106

undo segment recovery, C.4.107

undo segment tx slot, C.4.108

virtual circuit status, C.4.109

WMON goes to sleep, C.4.110

write complete waits, C.4.111

writes stopped by instance recovery or database suspension, C.4.112

WM_INSTALLATION view, 2.1.2

WM_REPLICATION_INFO view, 2.1.2

WORKAREA_SIZE_POLICY initialization parameter, 1.224