Morales T., Lorentz D.
Table of contents :
Send Us Your Comments……Page 37
Preface……Page 39
1 Initialization Parameters……Page 47
Initialization Parameter File……Page 48
Rules Governing Parameter Files……Page 49
Using Special Characters in Parameter Values……Page 51
Changing Parameter Values……Page 52
Types of Parameters……Page 56
When Parameters Are Set Incorrectly……Page 58
Reading the Parameter Descriptions……Page 59
Parameter Descriptions……Page 60
AQ_TM_PROCESSES……Page 61
ARCHIVE_LAG_TARGET……Page 62
AUDIT_TRAIL……Page 63
BACKGROUND_DUMP_DEST……Page 64
BACKUP_TAPE_IO_SLAVES……Page 65
BLANK_TRIMMING……Page 66
BUFFER_POOL_KEEP……Page 67
BUFFER_POOL_RECYCLE……Page 68
CIRCUITS……Page 69
CLUSTER_DATABASE_INSTANCES……Page 70
CLUSTER_INTERCONNECTS……Page 71
COMMIT_POINT_STRENGTH……Page 72
COMPATIBLE……Page 73
CONTROL_FILES……Page 74
CPU_COUNT……Page 75
CREATE_BITMAP_AREA_SIZE……Page 76
CURSOR_SHARING……Page 77
CURSOR_SPACE_FOR_TIME……Page 78
DB_BLOCK_BUFFERS……Page 79
DB_BLOCK_CHECKSUM……Page 81
DB_BLOCK_SIZE……Page 82
DB_CACHE_ADVICE……Page 83
DB_CREATE_FILE_DEST……Page 84
DB_DOMAIN……Page 85
DB_FILE_MULTIBLOCK_READ_COUNT……Page 86
DB_FILE_NAME_CONVERT……Page 87
DB_FILES……Page 89
DB_NAME……Page 90
DB_RECYCLE_CACHE_SIZE……Page 91
DBLINK_ENCRYPT_LOGIN……Page 92
DISK_ASYNCH_IO……Page 93
DISPATCHERS……Page 94
DML_LOCKS……Page 98
DRS_START……Page 99
ENQUEUE_RESOURCES……Page 100
FAL_CLIENT……Page 101
FAST_START_IO_TARGET……Page 102
FAST_START_MTTR_TARGET……Page 103
FIXED_DATE……Page 104
GC_FILES_TO_LOCKS……Page 105
GLOBAL_NAMES……Page 107
HASH_JOIN_ENABLED……Page 108
HS_AUTOREGISTER……Page 109
IFILE……Page 110
INSTANCE_NAME……Page 111
INSTANCE_NUMBER……Page 112
JAVA_POOL_SIZE……Page 113
JOB_QUEUE_PROCESSES……Page 114
LARGE_POOL_SIZE……Page 115
LICENSE_MAX_SESSIONS……Page 116
LICENSE_SESSIONS_WARNING……Page 117
LOCAL_LISTENER……Page 118
LOCK_SGA……Page 119
LOG_ARCHIVE_DEST……Page 120
LOG_ARCHIVE_DEST_n……Page 121
LOG_ARCHIVE_DEST_STATE_n……Page 123
LOG_ARCHIVE_DUPLEX_DEST……Page 124
LOG_ARCHIVE_FORMAT……Page 125
LOG_ARCHIVE_MAX_PROCESSES……Page 126
LOG_ARCHIVE_MIN_SUCCEED_DEST……Page 127
LOG_ARCHIVE_START……Page 128
LOG_ARCHIVE_TRACE……Page 129
LOG_BUFFER……Page 130
LOG_CHECKPOINT_INTERVAL……Page 131
LOG_CHECKPOINT_TIMEOUT……Page 132
LOG_CHECKPOINTS_TO_ALERT……Page 133
LOG_FILE_NAME_CONVERT……Page 134
LOGMNR_MAX_PERSISTENT_SESSIONS……Page 135
MAX_COMMIT_PROPAGATION_DELAY……Page 136
MAX_DUMP_FILE_SIZE……Page 137
MAX_ROLLBACK_SEGMENTS……Page 138
MTS_CIRCUITS……Page 139
MTS_DISPATCHERS……Page 140
MTS_MAX_DISPATCHERS……Page 144
MTS_SERVERS……Page 145
MTS_SESSIONS……Page 146
NLS_CALENDAR……Page 147
NLS_CURRENCY……Page 148
NLS_DATE_LANGUAGE……Page 149
NLS_ISO_CURRENCY……Page 150
NLS_LENGTH_SEMANTICS……Page 151
NLS_NCHAR_CONV_EXCP……Page 152
NLS_SORT……Page 153
NLS_TERRITORY……Page 154
NLS_TIMESTAMP_FORMAT……Page 155
O7_DICTIONARY_ACCESSIBILITY……Page 156
OBJECT_CACHE_MAX_SIZE_PERCENT……Page 157
OPEN_CURSORS……Page 158
OPEN_LINKS……Page 159
OPEN_LINKS_PER_INSTANCE……Page 160
OPTIMIZER_FEATURES_ENABLE……Page 161
OPTIMIZER_INDEX_CACHING……Page 162
OPTIMIZER_MAX_PERMUTATIONS……Page 163
OPTIMIZER_MODE……Page 164
ORACLE_TRACE_COLLECTION_NAME……Page 165
ORACLE_TRACE_COLLECTION_SIZE……Page 166
ORACLE_TRACE_ENABLE……Page 167
ORACLE_TRACE_FACILITY_NAME……Page 168
OS_AUTHENT_PREFIX……Page 169
OS_ROLES……Page 170
PARALLEL_ADAPTIVE_MULTI_USER……Page 171
PARALLEL_BROADCAST_ENABLED……Page 172
PARALLEL_EXECUTION_MESSAGE_SIZE……Page 173
PARALLEL_MAX_SERVERS……Page 174
PARALLEL_MIN_PERCENT……Page 175
PARALLEL_MIN_SERVERS……Page 176
PARTITION_VIEW_ENABLED……Page 177
PGA_AGGREGATE_TARGET……Page 178
PLSQL_COMPILER_FLAGS……Page 179
PLSQL_NATIVE_LIBRARY_DIR……Page 180
PLSQL_NATIVE_LINKER……Page 181
PLSQL_NATIVE_MAKE_UTILITY……Page 182
PRE_PAGE_SGA……Page 183
PROCESSES……Page 184
QUERY_REWRITE_ENABLED……Page 185
RDBMS_SERVER_DN……Page 186
READ_ONLY_OPEN_DELAYED……Page 187
REMOTE_DEPENDENCIES_MODE……Page 188
REMOTE_LISTENER……Page 189
REMOTE_LOGIN_PASSWORDFILE……Page 190
REMOTE_OS_ROLES……Page 191
REPLICATION_DEPENDENCY_TRACKING……Page 192
RESOURCE_MANAGER_PLAN……Page 193
ROLLBACK_SEGMENTS……Page 194
ROW_LOCKING……Page 195
SERIAL _REUSE……Page 196
SERVICE_NAMES……Page 197
SESSION_MAX_OPEN_FILES……Page 198
SESSIONS……Page 199
SHADOW_CORE_DUMP……Page 200
SHARED_POOL_RESERVED_SIZE……Page 201
SHARED_POOL_SIZE……Page 202
SORT_AREA_RETAINED_SIZE……Page 203
SORT_AREA_SIZE……Page 205
SPFILE……Page 206
SQL_TRACE……Page 207
STANDBY_ARCHIVE_DEST……Page 208
STANDBY_PRESERVES_NAMES……Page 209
STAR_TRANSFORMATION_ENABLED……Page 210
THREAD……Page 211
TIMED_OS_STATISTICS……Page 212
TIMED_STATISTICS……Page 213
TRACE_ENABLED……Page 214
TRANSACTION_AUDITING……Page 215
TRANSACTIONS……Page 216
UNDO_MANAGEMENT……Page 217
UNDO_RETENTION……Page 218
UNDO_TABLESPACE……Page 219
USER_DUMP_DEST……Page 220
UTL_FILE_DIR……Page 221
WORKAREA_SIZE_POLICY……Page 222
2 Static Data Dictionary Views……Page 223
ALL_ALL_TABLES……Page 226
ALL_ARGUMENTS……Page 228
ALL_ASSOCIATIONS……Page 229
ALL_BASE_TABLE_MVIEWS……Page 230
ALL_CLUSTER_HASH_EXPRESSIONS……Page 231
ALL_CLUSTERS……Page 232
ALL_COL_PRIVS……Page 233
ALL_COL_PRIVS_MADE……Page 234
ALL_COLL_TYPES……Page 235
ALL_CONS_COLUMNS……Page 236
ALL_CONSTRAINTS……Page 237
ALL_CONTEXT……Page 238
ALL_DEF_AUDIT_OPTS……Page 239
ALL_DEPENDENCIES……Page 240
ALL_DIM_CHILD_OF……Page 241
ALL_DIM_JOIN_KEY……Page 242
ALL_DIM_LEVELS……Page 243
ALL_DIRECTORIES……Page 244
ALL_EXTERNAL_TABLES……Page 245
ALL_IND_COLUMNS……Page 246
ALL_IND_EXPRESSIONS……Page 247
ALL_IND_PARTITIONS……Page 248
ALL_IND_SUBPARTITIONS……Page 250
ALL_INDEXES……Page 252
ALL_INDEXTYPE_OPERATORS……Page 255
ALL_INDEXTYPES……Page 256
ALL_JOBS……Page 257
ALL_JOIN_IND_COLUMNS……Page 258
ALL_LIBRARIES……Page 259
ALL_LOB_PARTITIONS……Page 260
ALL_LOB_SUBPARTITIONS……Page 261
ALL_LOBS……Page 262
ALL_LOG_GROUPS……Page 264
ALL_METHOD_RESULTS……Page 265
ALL_MVIEW_AGGREGATES……Page 266
ALL_MVIEW_ANALYSIS……Page 267
ALL_MVIEW_JOINS……Page 269
ALL_MVIEW_KEYS……Page 270
ALL_MVIEW_REFRESH_TIMES……Page 271
ALL_MVIEWS……Page 272
ALL_NESTED_TABLES……Page 275
ALL_OBJECT_TABLES……Page 276
ALL_OBJECTS……Page 278
ALL_OPANCILLARY……Page 279
ALL_OPBINDINGS……Page 280
ALL_OPERATORS……Page 281
ALL_OUTLINES……Page 282
ALL_PART_COL_STATISTICS……Page 283
ALL_PART_HISTOGRAMS……Page 284
ALL_PART_INDEXES……Page 285
ALL_PART_KEY_COLUMNS……Page 286
ALL_PART_LOBS……Page 287
ALL_PART_TABLES……Page 288
ALL_POLICIES……Page 290
ALL_PROCEDURES……Page 291
ALL_PUBLISHED_COLUMNS……Page 292
ALL_QUEUE_TABLES……Page 293
ALL_QUEUES……Page 294
ALL_REFRESH……Page 295
ALL_REFRESH_CHILDREN……Page 296
ALL_REFS……Page 297
ALL_REGISTERED_MVIEWS……Page 298
ALL_REGISTERED_SNAPSHOTS……Page 299
ALL_SNAPSHOT_LOGS……Page 300
ALL_SOURCE……Page 301
ALL_SQLJ_TYPE_ATTRS……Page 302
ALL_SQLJ_TYPE_METHODS……Page 303
ALL_STORED_SETTINGS……Page 304
ALL_SUBPART_COL_STATISTICS……Page 305
ALL_SUBPART_HISTOGRAMS……Page 306
ALL_SUBSCRIBED_COLUMNS……Page 307
ALL_SUBSCRIPTIONS……Page 308
ALL_SUMDELTA……Page 309
ALL_TAB_COL_STATISTICS……Page 310
ALL_TAB_COLUMNS……Page 311
ALL_TAB_HISTOGRAMS……Page 313
ALL_TAB_MODIFICATIONS……Page 314
ALL_TAB_PARTITIONS……Page 315
ALL_TAB_PRIVS_MADE……Page 317
ALL_TAB_SUBPARTITIONS……Page 318
ALL_TABLES……Page 320
ALL_TRIGGERS……Page 323
ALL_TYPE_ATTRS……Page 324
ALL_TYPE_METHODS……Page 325
ALL_TYPES……Page 326
ALL_UPDATABLE_COLUMNS……Page 327
ALL_USTATS……Page 328
ALL_VARRAYS……Page 329
AUDIT_ACTIONS……Page 330
CHAINED_ROWS……Page 331
CHANGE_SETS……Page 332
CODE_PIECES……Page 333
DATABASE_PROPERTIES……Page 334
DBA_2PC_PENDING……Page 335
DBA_AUDIT_EXISTS……Page 336
DBA_AUDIT_OBJECT……Page 337
DBA_AUDIT_STATEMENT……Page 339
DBA_AUDIT_TRAIL……Page 341
DBA_CLU_COLUMNS……Page 343
DBA_CONSTRAINTS……Page 344
DBA_DDL_LOCKS……Page 345
DBA_DIM_HIERARCHIES……Page 346
DBA_DML_LOCKS……Page 347
DBA_EXP_FILES……Page 348
DBA_EXTENTS……Page 349
DBA_FREE_SPACE_COALESCED……Page 350
DBA_IND_PARTITIONS……Page 351
DBA_INTERNAL_TRIGGERS……Page 352
DBA_KGLLOCK……Page 353
DBA_LOCK_INTERNAL……Page 354
DBA_LOG_GROUPS……Page 355
DBA_MVIEW_DETAIL_RELATIONS……Page 356
DBA_MVIEWS……Page 357
DBA_OBJ_AUDIT_OPTS……Page 358
DBA_OPANCILLARY……Page 359
DBA_ORPHAN_KEY_TABLE……Page 360
DBA_PART_INDEXES……Page 361
DBA_POLICIES……Page 362
DBA_PROXIES……Page 363
DBA_PUBLISHED_COLUMNS……Page 364
DBA_QUEUE_SCHEDULES……Page 365
DBA_QUEUE_TABLES……Page 366
DBA_REFS……Page 367
DBA_REGISTERED_SNAPSHOTS……Page 368
DBA_REPAIR_TABLE……Page 369
DBA_RESUMABLE……Page 370
DBA_ROLE_PRIVS……Page 372
DBA_RSRC_CONSUMER_GROUP_PRIVS……Page 373
DBA_RSRC_MANAGER_SYSTEM_PRIVS……Page 374
DBA_RSRC_PLAN_DIRECTIVES……Page 375
DBA_RSRC_PLANS……Page 376
DBA_SEGMENTS……Page 377
DBA_SNAPSHOTS……Page 378
DBA_STMT_AUDIT_OPTS……Page 379
DBA_SUBSCRIBED_COLUMNS……Page 380
DBA_SYS_PRIVS……Page 381
DBA_TAB_PARTITIONS……Page 382
DBA_TABLESPACES……Page 383
DBA_TEMP_FILES……Page 384
DBA_TRANSFORMATIONS……Page 385
DBA_TYPE_METHODS……Page 386
DBA_UPDATABLE_COLUMNS……Page 387
DBA_USTATS……Page 388
DBMS_ALERT_INFO……Page 389
DICT_COLUMNS……Page 390
FILE_LOCK……Page 391
FILE_PING……Page 392
HS_ALL_CAPS……Page 394
HS_BASE_CAPS……Page 395
HS_CLASS_DD……Page 396
HS_EXTERNAL_OBJECT_PRIVILEGES……Page 397
HS_FDS_CLASS……Page 398
HS_INST_DD……Page 399
IDEPTREE……Page 400
INDEX_STATS……Page 401
NLS_DATABASE_PARAMETERS……Page 402
PARSED_SIZE……Page 403
PLAN_TABLE……Page 404
PLUGGABLE_SET_CHECK……Page 405
PROXY_USERS……Page 406
PUBLICSYN……Page 407
RESOURCE_COST……Page 408
ROLE_TAB_PRIVS……Page 409
SESSION_ROLES……Page 410
SYSFILES……Page 411
TABLE_PRIVILEGE_MAP……Page 412
TABQUOTAS……Page 413
TS_PITR_CHECK……Page 414
UNI_PLUGGABLE_SET_CHECK……Page 415
USER_AUDIT_OBJECT……Page 416
USER_CLU_COLUMNS……Page 417
USER_COL_PRIVS_RECD……Page 418
USER_DIM_ATTRIBUTES……Page 419
USER_DIMENSIONS……Page 420
USER_IND_COLUMNS……Page 421
USER_INDEXTYPE_OPERATORS……Page 422
USER_LOB_PARTITIONS……Page 423
USER_MVIEW_AGGREGATES……Page 424
USER_MVIEW_KEYS……Page 425
USER_OBJECTS……Page 426
USER_OUTLINE_HINTS……Page 427
USER_PART_LOBS……Page 428
USER_PROXIES……Page 429
USER_QUEUES……Page 430
USER_RESOURCE_LIMITS……Page 431
USER_SEGMENTS……Page 432
USER_SQLJ_TYPE_ATTRS……Page 433
USER_SUBPART_KEY_COLUMNS……Page 434
USER_TAB_COLUMNS……Page 435
USER_TAB_PRIVS……Page 436
USER_TRANSFORMATIONS……Page 437
USER_UNUSED_COL_TABS……Page 438
USER_VIEWS……Page 439
About Dynamic Performance Views……Page 441
GV$ Views……Page 442
V$AQ……Page 444
V$ARCHIVE_DEST……Page 445
V$ARCHIVE_PROCESSES……Page 446
V$ARCHIVED_LOG……Page 447
V$BACKUP_ASYNC_IO……Page 449
V$BACKUP_CORRUPTION……Page 450
V$BACKUP_DATAFILE……Page 451
V$BACKUP_PIECE……Page 452
V$BACKUP_REDOLOG……Page 453
V$BACKUP_SET……Page 454
V$BACKUP_SYNC_IO……Page 455
V$BGPROCESS……Page 456
V$BH……Page 457
V$BSP……Page 458
V$BUFFER_POOL……Page 459
V$BUFFER_POOL_STATISTICS……Page 460
V$CACHE……Page 461
V$CACHE_LOCK……Page 463
V$CACHE_TRANSFER……Page 464
V$CIRCUIT……Page 465
V$CLASS_CACHE_TRANSFER……Page 466
V$CLASS_PING……Page 467
V$COMPATSEG……Page 468
V$CONTROLFILE_RECORD_SECTION……Page 469
V$CR_BLOCK_SERVER……Page 470
V$DATABASE……Page 471
V$DATAFILE……Page 473
V$DATAFILE_COPY……Page 474
V$DATAFILE_HEADER……Page 476
V$DB_OBJECT_CACHE……Page 477
V$DBFILE……Page 478
V$DELETED_OBJECT……Page 479
V$DISPATCHER……Page 480
V$DISPATCHER_RATE……Page 481
V$DLM_ALL_LOCKS……Page 485
V$DLM_CONVERT_LOCAL……Page 486
V$DLM_CONVERT_REMOTE……Page 487
V$DLM_LOCKS……Page 488
V$DLM_RESS……Page 489
V$ENQUEUE_LOCK……Page 490
V$ENQUEUE_STAT……Page 491
V$FALSE_PING……Page 492
V$FAST_START_SERVERS……Page 493
V$FILE_CACHE_TRANSFER……Page 494
V$FILE_PING……Page 495
V$FIXED_TABLE……Page 497
V$GES_BLOCKING_ENQUEUE……Page 498
V$GES_CONVERT_LOCAL……Page 499
V$GES_ENQUEUE……Page 500
V$GLOBAL_BLOCKED_LOCKS……Page 501
V$HS_AGENT……Page 502
V$HS_SESSION……Page 503
V$INSTANCE……Page 504
V$INSTANCE_RECOVERY……Page 505
V$LATCH_CHILDREN……Page 507
V$LATCH_PARENT……Page 508
V$LIBRARYCACHE……Page 509
V$LOADCSTAT……Page 510
V$LOCK……Page 511
V$LOCK_ACTIVITY……Page 513
V$LOCK_ELEMENT……Page 514
V$LOG……Page 515
V$LOG_HISTORY……Page 516
V$LOGMNR_CONTENTS……Page 517
V$LOGMNR_DICTIONARY……Page 519
V$LOGMNR_PARAMETERS……Page 520
V$NLS_PARAMETERS……Page 521
V$OBJECT_DEPENDENCY……Page 522
V$OFFLINE_RANGE……Page 523
V$PARALLEL_DEGREE_LIMIT_MTH……Page 524
V$PARAMETER2……Page 525
V$PGASTAT……Page 526
V$PING……Page 527
V$PQ_SLAVE……Page 528
V$PQ_SYSSTAT……Page 529
V$PQ_TQSTAT……Page 530
V$PROCESS……Page 531
V$PROXY_ARCHIVEDLOG……Page 532
V$PROXY_DATAFILE……Page 533
V$PWFILE_USERS……Page 534
V$PX_PROCESS_SYSSTAT……Page 535
V$PX_SESSION……Page 536
V$QUEUEING_MTH……Page 537
V$RECOVERY_LOG……Page 538
V$RECOVERY_STATUS……Page 539
V$RESERVED_WORDS……Page 540
V$RESOURCE_LIMIT……Page 541
V$ROLLNAME……Page 542
V$ROWCACHE……Page 543
V$ROWCACHE_PARENT……Page 544
V$RSRC_CONSUMER_GROUP……Page 545
V$RSRC_CONSUMER_GROUP_CPU_MTH……Page 546
V$RSRC_PLAN_CPU_MTH……Page 547
V$SESSION……Page 548
V$SESSION_CONNECT_INFO……Page 552
V$SESSION_EVENT……Page 553
V$SESSION_LONGOPS……Page 554
V$SESSION_OBJECT_CACHE……Page 555
V$SESSION_WAIT……Page 556
V$SESSTAT……Page 557
V$SHARED_POOL_RESERVED……Page 558
V$SHARED_SERVER……Page 559
V$SHARED_SERVER_MONITOR……Page 560
V$SORT_USAGE……Page 561
V$SQL……Page 562
V$SQL_BIND_DATA……Page 564
V$SQL_BIND_METADATA……Page 565
V$SQL_PLAN……Page 566
V$SQL_SHARED_CURSOR……Page 568
V$SQL_WORKAREA……Page 570
V$SQL_WORKAREA_ACTIVE……Page 571
V$SQLAREA……Page 572
V$SQLTEXT_WITH_NEWLINES……Page 574
V$STATNAME……Page 575
V$SYSSTAT……Page 576
V$SYSTEM_EVENT……Page 577
V$SYSTEM_PARAMETER……Page 578
V$SYSTEM_PARAMETER2……Page 579
V$TEMP_CACHE_TRANSFER……Page 580
V$TEMP_EXTENT_POOL……Page 581
V$TEMP_PING……Page 582
V$TEMP_SPACE_HEADER……Page 583
V$TEMPSTAT……Page 584
V$THREAD……Page 585
V$TRANSACTION……Page 586
V$TYPE_SIZE……Page 588
V$UNDOSTAT……Page 589
V$VPD_POLICY……Page 590
V$WAITSTAT……Page 591
4 Database Limits……Page 593
Physical Database Limits……Page 594
Logical Database Limits……Page 595
Process and Runtime Limits……Page 596
5 SQL Scripts……Page 599
Creating the Data Dictionary……Page 600
Creating Additional Data Dictionary Structures……Page 601
The “NO” Scripts……Page 604
Migration Scripts……Page 605
Java Scripts……Page 606
A Oracle Wait Events……Page 607
Wait Events and Parameters……Page 608
Parameter Descriptions……Page 615
Wait Event Descriptions……Page 617
BFILE check if open……Page 618
BFILE get path object……Page 619
BFILE read……Page 620
buffer for checkpoint……Page 621
buffer read retry……Page 622
control file parallel write……Page 623
control file single write……Page 624
db file parallel write……Page 625
db file single write……Page 626
DFS lock handle……Page 627
direct path write……Page 628
enqueue……Page 629
free global transaction table entry……Page 630
global cache lock busy……Page 631
global cache lock null to x……Page 632
global cache lock open x……Page 633
inactive transaction branch……Page 634
instance state change……Page 635
latch activity……Page 636
library cache load lock……Page 637
library cache pin……Page 638
log file parallel write……Page 639
log file switch (archiving needed)……Page 640
log switch/archive……Page 641
parallel execution dequeue wait……Page 642
parallel execution signal server……Page 643
pipe put……Page 644
process startup……Page 645
rdbms ipc reply……Page 646
single-task message……Page 647
SQL*Net break/reset to dblink……Page 648
SQL*Net message to dblink……Page 649
SQL*Net more data to client……Page 650
transaction……Page 651
undo segment tx slot……Page 652
writes stopped by instance recovery or database suspension……Page 653
B Oracle Enqueue Names……Page 655
Statistics Descriptions……Page 659
Index……Page 679
Reviews
There are no reviews yet.