Symbols
.cshrc 34
.profile 34
/etc/group 33
/etc/init.d directory 7
/etc/passwd 34
/etc/system 33
Numerics
3GL 181
3GL external routine 182
A
activate standby server 395
active processes 339
ADD DATAFILE 101
ADD PARTITION 230
add partitions 215
ADD_LOGFILE procedure 331, 333
Administrative Tools 304
admintool 34
advanced replication 432, 434, 466, 487–494
AFTER option 143
AFTER ROW trigger 436
ALTER DATABASE 18, 106–107, 117, 121–122
ALTER DATABASE ARCHIVELOG 271, 274, 377, 409
ALTER DATABASE DATAFILE 110
ALTER DATABASE DATAFILE … AUTOEXTEND 110
ALTER DATABASE OPEN 119
ALTER SESSION 225
ALTER SYSTEM 300, 420
ALTER SYSTEM ARCHIVE 378
ALTER SYSTEM RESUME 298–299
ALTER SYSTEM SUSPEND 298–299
ALTER TABLE 84, 225–226, 233, 259
ALTER TABLE 105
ALTER TABLE … MOVE 88
ALTER TABLESPACE 92, 96, 101, 110, 112, 276
ALTER TABLESPACE BEGIN BACKUP 270
ALTER TABLESPACE END BACKUP 270
ANALYZE 329
ANALYZE TABLE 75
API
third party 262
apply archived logs 385
ARCHIVE LOG
generating new 422
archive log files 271
ARCHIVE LOG LIST 271, 274
archive logs 389, 402
archive logs transfer 384
archive logs transfer (continued)
automating 398–403
archive processes
increasing 299–300
archived logs 387, 392, 394, 405, 420
apply 385
transferred 405
archiving
enable 271, 378
arithmetic expression 82
asynchronous 315, 493
asynchronous I/O 113, 263, 265
asynchronous replication 466
AT command 283
AUTOALLOCATE 138–139
AUTOEXTEND 110–112
automated log transfers 416, 420
automatic refresh 441
enable 439
automatic startup 6
autonomous 203
autonomous PL/SQL block 141
implementing 201–205
autonomous transaction 201, 204
AUTONOMOUS_TRANSAC-TION 201–202
availability 212, 217, 219, 237, 239, 254
higher 91
available products 36
B
backup 262
cold 262, 264
hot 262, 264
incremental 262, 264
operating system 264
parallel 265, 291
recovery to a point in time 286
tablespace 268
using export/import utility 288–291
without recovery catalog 269
backup and restores
parallelization of 262
backup options 262–265
backup script 281
balance the I/O 121
basic replication 435
BEFORE option 143
benchmarks 318
BFILE 48
bidirectional 433
bidirectional asynchronous replication 443–459
bidirectional replication 432
bind-array buffer 349
binding 207
BITMAP_MERGE_AREA_SIZE 55
bitmapped index 46, 56–59, 80
creating 54–56, 59
storage 55
BLOB 47
block
data space 73
block contention 303
block header size 71, 73
block size 125, 128, 302–304
blocks
required for index 74
break mirrors 298
B-Tree index 60, 80
buffer cache ratio 303
buffer pool properties 311
buffer pools
DEFAULT 308
KEEP 308
RECYCLE 308
BUFFER_POOL 308–309
BUFFER_POOL_KEEP 308
BUFFER_POOL_RECYCLE 308
bulk binding methods
comparing 207
bulk binds using PL/SQL 207–210
BULK COLLECT 207
C
C function 80
C program 182
calculating row space 71
cancel RECOVERY 386, 395, 424
cardinality 59
CASCADE CONSTRAINTS 84
CATALOG.SQL 12
CATREP.SQL 444
CATRMAN.SQL 266
chained rows
eliminating 74–78
viewing 74–78
channels 291
CHECKPOINT 84
checkpoint 337
checksum 295–296
clauses
BUFFER_POOL 309
CLOBs 47
CLOSE_CURSOR function 177
cluster key 64–65
cluster table 46, 65
clustered index
creating 64–68
clustered table 66, 218
clusters, hash 68
COALESCE 96
coalesce free extents 138
coalesce free space 91, 94–97
code
hiding 168–170
cold backup 262, 264
COLLECT.SH 321–322
column groups 467
characteristics 467
create 468
columns
dropping 46, 83–86
commands
ALTER DATABASE 18, 106, 122
commands (continued)
ALTER SESSION 225
ALTER TABLE 84, 233
ALTER TABLESPACE 92, 96, 101, 276
ANALYZE 329
ANALYZE TABLE 75
AT 283
COALESCE 96
CREATE CONTROLFILE SQL 17
CREATE INDEX 239
CREATE TABLE 104, 213, 251
CREATE TRIGGER 143
CREATE USER 108
crontab 284–285
DBV 123
diskperf 324
DROP TABLESPACE 295
ENABLE/DISABLE ROW MOVEMENT 259
EXCHANGE PARTITION 226
format 113
FREE 509
groupadd 500
ps 320, 346
RECOVER DATAFILE 287, 294
sar 318
SET CONSTRAINT 53
SHOW PARAMETERS 21
top 507
useradd 500
UTLCHAIN.SQL 75
vmstat 508
XHOST 35
COMMIT 203
commit the transaction 473
committed transaction recovery 393
committed transactions 147, 398, 406, 424
comparing tables 474–477
complete refresh 436
complex snapshot 436
composite partitioning 212, 254, 256
characteristics 254
compression 276
COMPUTE STATISTICS 329
configuration tools 37
conflict resolution methods 466–474
earliest timestamp 467
latest timestamp 467
conflicts
delete 467
uniqueness 467
update 466
CONSTRAINT 50
constraints
DEFERRABLE 50–51
INITIALLY DEFERRED 51
INITIALLY IMMEDIATE 51
NON-DEFERRABLE 50–51
UNIQUE 51
control files 391, 413
backing up to trace 18
create 350, 378, 410
dump to trace 19
multiple 17
recovering 18
recreating 16
COPY command 434
cost-based optimizer 80
cpio 276
CPU usage 320, 340
crash 395
create a view 151
CREATE BITMAP INDEX 55
CREATE CLUSTER 64, 83
CREATE CONTROLFILE 17, 20
CREATE DATABASE LINK 437
CREATE INDEX 63, 87, 239, 353
Create Index dialog 246
CREATE LIBRARY statement 183
create package 462
Create Partition window 216
CREATE SEQUENCE 172
statement 170
CREATE SESSION 288
CREATE SNAPSHOT 437
CREATE TABLE 102, 104, 213, 216, 251, 260
CREATE TABLE … AS SELECT 105, 357
CREATE TABLE AS SELECT 432
CREATE TABLESPACE 110
create tablespace 404
CREATE TABLESPACE … AUTOEXTEND 111
CREATE TRIGGER command 143
CREATE USER 108
create user-defined functions 141
CREATE_BITMAP_AREA_SIZE 55
CREATE_DATABASE.SQL 11
CREATEDB.SQL 4
creating a database 2, 8–14, 37
CRON 398
crontab command 284–285
CURRVAL 170
D
data
distributing on CD 134–137
validating 423
data blocks 113
data dictionary 91, 138
data distribution
on CD-ROM 91
Data Manager 351
Data Migration Assistant 37
data on CD-ROM 134
data redundancy 314
data segments 225
EXCHANGE 227
data structure integrity 296–297
data warehousing 128, 298
applications 46, 80, 212
database
backup 408
creating 2, 8–14
custom 3
large 54
test xvi, 2, 8
typical 3
Database Assistant 8
database backup
scheduled OS method 283–285
UNIX 280–282
Windows NT 277–280
database backup in parallel 291–293
database file 37, 263
database I/O 338
balancing 325–328
database link
create 437
database options 14–16
database recovery to a point in time 286–287
database reports 23–32
database trigger 143, 147
database tuning
UNIX 318–323
Windows NT 323–325
database writer 92, 337
datafile 100, 106–107, 110–113, 120, 123, 286, 381
converting to raw 117
missing 293
move 121–123
not fragmented 113
datafile offline 294
datafile recovery 293–295
DB_BLOCK_BUFFERS 308
DB_BLOCK_CHECKSUM 295
DB_BLOCK_LRU_LATCHES 308
DB_BLOCK_SIZE 71
DB_FILE_NAME_CONVERT 381, 404, 414
DB_VERIFY 296–297
DBA & operator group 33
DBA_DATA_FILES 29, 131
dba_data_files 25, 120
DBA_IND_COLUMNS 250
DBA_IND_PARTITIONS 250
dba_indexes 28
DBA_JOBS 196
DBA_JOBS system table 197
DBA_JOBS_RUNNING 196
DBA_PART_COLUMNS 250
DBA_PART_INDEXES 247, 250
DBA_SEGMENTS 228
DBA_TAB_PARTITION 235
dba_tables 27
DBA_TABLESPACES 29, 133
dba_tablespaces 26
dba_ts_quotas 124
dba_users 27
DBMS_ALERT package 188, 190–191
DBMS_ALERT.REGISTER 189
DBMS_ALERT.SIGNAL procedure 190
DBMS_JOB 192
DBMS_JOB package 192, 201
DBMS_JOB.CHANGE procedure 199–200
DBMS_LOB 47, 49
DBMS_LOGMNR package 331
DBMS_OUTPUT package 208
DBMS_OUTPUT.PUT_LINE 177
DBMS_RECTIFIER_DIFF 474, 476
DBMS_RECTIFIER_DIFF. RECTIFY 478
DBMS_ROWID package 312, 314
DBMS_SNAPSHOT package 436
DBMS_SQL 141, 174, 205
DBMS_SQL package 142, 174–175
DBMS_SQL.COLUMN_VALUE 177
DBMS_SQL.DEFINE_COLUMN 177
DBMS_SQL.EXECUTE 177
DBMS_SQL.FETCH_ROWS 177
DBMS_SQL.OPEN_CURSOR 177
DBMS_TTS 130
DBNAME 11
changing 19–20
DBV 123
dbv 296
dbverf73 296
dbverf80 296
DBWn 337
dd command 117, 119
DDL 344
deadlock 485
DEFAULT buffer pools 308
DEFERRABLE 50–51
deferred constraints 46–53
improved performance 50
deferred transactions 465
DEFINE_COLUMN function 175
DEGREE 353
degree of parallelism 366
delete conflicts 467
delete statement 146
destination map 484
direct path loading 348
advantages 349
directories
/etc/init.d 7
rc0.d 8
dirty buffers 337
DISABLE PARALLEL DML 360
Disk Administrator 115, 304
disk array 375
disk cache 326
disk I/O 325
disk partitions 107
create 113
disk slices 99
disk statistics 324
disk stripe 315
disk-array 393–394
diskperf 324
DISPLAY 34
DISTRIBUTED_TIMEOUT_ LOCK 486
DLL 181
DML 344
DML operations, large 87
DML S-lock 86
DML statements 459
DOCUMENT.SQL 23, 28, 32
drop a column 46
DROP COLUMN 84, 86
DROP PARTITION 232, 245
DROP TABLESPACE 295
DROP UNUSED COLUMN 84
DSS 302, 308
DSS applications 60
dump control file to trace 19
Dynamic Link Library 181
dynamic SQL 141, 175, 205–206
dynamic SQL using PL/SQL
executing 174–178
writing 205–207
E
enable 216
enable archiving 271, 378
ENABLE PARALLEL DML 359
ENABLE/DISABLE ROW MOVEMENT 259
enabling standby 392
END BACKUP 277
Enterprise Backup Utility 263–264
equipartitioned 250
error messages
ORA-00372 93
ORA-00376 218
ORA-01109 418
ORA-01110 93, 136
ORA-01141 122
ORA-01157 136
ORA-01403 472
ORA-01495 75
ORA-01502 245
ORA-01511 122
ORA-01628 125
ORA-01630 125
ORA-01631 125
ORA-01632 125
ORA-01659 94
ORA-01776 152
ORA-12012 196
ORA-14024 241
ORA-14038 243
ORA-14074 231
ORA-14255 256
ORA-14400 213, 216
ORA-14402 216, 259
ORA-27072 306
Oracle data block corrupted 295
ESTIMATE STATISTICS 329
estimate table size 70–72
EXCHANGE 229
EXCHANGE data segments 228
exchange data segments 220
EXCHANGE option 225
EXCHANGE PARTITION 226
Exchange Partition dialog 229
EXECUTE IMMEDIATE 205
EXPLAIN PLAN 328, 356, 361–362, 367
export 220, 288, 433
export utility 102, 288, 511, 514
export/import 128, 263
export/import utility 84, 106, 264
exporting data from Windows NT 514
EXTENT MANAGEMENT 138
extents 139
initial 100
next 100
extents allocation 340
EXTENTS_USER_REP.SQL 126
external procedure 142, 181, 185
registering 184
external procedure call 141, 181–185
F
fast refresh 436
FAST_START_IO_TARGET 337
FETCH INTO 208
FIBRE channel 393
file locations 36
file locations window 42
file system datafile 117–119
fixed parity 316
FOPEN 179
FOR … LOOP statement 207
FOR EACH ROW option 144
FOR LOOP 208
FORALL 207
FORALL statement 207–208
force refresh 436
format 113
format utility 306
forms of replication 432–435
FREE 509
FTP 379, 390, 411
FTP command 132
full table scan 344, 358
function-based index 46
advantages 80
cost-based optimizer 80
creating 46, 80–82
restrictions 80
functions
user-defined 186–188
G
generate sequence numbers 170
generating 170–172
GET_LINE 180
global database name 44, 446
global index
limitations 243
global partitioned index 239
creating 243–246
GNU C compiler 509
group, adding LINUX 500
group, creating 481
GROUPADD 33
groupadd 500
groups
DBA & operator group 33
H
hardware requirements
LINUX 496
Oracle8i 32
Oracle8i Windows NT 41
Solaris 32
hash cluster 68, 82
creating 68–70
improved performance 68
hash cluster table 46
hash function 68, 250
hash joins 344
hash key 68, 70
hash partition 212, 254, 256
inserting data 252
hash partitioned tables 251
creating 250–254
hide PL/SQL code 141
high availability 212, 371–374, 436
high I/O bandwidth 343
high performance loading 351
higher performance 212
higher reliability 137
hit ratio 339
home directory 3
Home Selector 23
homes, multiple 2
horizontal replication 488
hot database backup 262, 264, 270
UNIX 274–277
Windows NT 270–273
hot standby database 374
I
I/O balancing 328
I/O bottleneck 328
I/O statistics 328
UNIX 326
images
storing 47
import 290, 433
import utility 135, 222, 288
importing into LINUX 514
INAME option 168
INCLUDING 61
INCLUDING CONTENTS 295
incremental backup 262, 264
index entry
estimating space 73
index key 239
INDEX tablespace 315, 317
index type 242
indexed columns
space required 73
indexes
bitmapped 46, 80
B-Tree index 60
creating online 86–88
estimating space for 72
function-based 46
local 243
local nonprefixed 240
nonpartitioned 239
nonprefixed 239, 246
parallel 352–355
partitioned 46, 239
prefixed 239, 243, 246
prefixed global 246
reverse-key 46–63
index-organized table 46, 60–62
INIT.ORA 11, 21, 295, 381, 391, 417
edit 413
initial extent 100
initialization parameters 20–21
INITIALLY DEFERRED 51
INITIALLY DEFERRED DEFERRABLE 52
INITIALLY IMMEDIATE 51
installation types 36
installing Oracle8
Windows NT 2, 6
instance recovery 337
INSTEAD OF functionality 151
INSTEAD OF trigger 141, 150, 152, 154–155
testing 154
integrated backup 262
INTEREST.SQL 168
internalization of PL/SQL 488
internalized triggers 432
internationalization 142
inventory location 36
iostat 319
J
JAVA 32, 82
JAVA function 80
Java-based installer 2
JOB QUEUE 445
job queue 191–195, 320, 436
monitoring 195–199
submitting jobs 192
JOB_QUEUE_INTERVAL 192, 439
JOB_QUEUE_PROCESSES 192, 439
jobs
managing 199–201
JOBS.SQL 197
K
KDBT 71
KEEP buffer pool 308
L
large object 46
creating 47–50
large tables 46
LARGE_POOL_SIZE 367
last committed 393
less fragmentation 137
linguistic sorts 80
LINUX 496
basic requirements 496–497
LINUX kernel 498–499
LINUX systems
preinstalled 498
LISTENER.ORA 505
LOB 46
creating 47–50
local index 241, 243
local nonprefixed index 240
creating 242
local partitioned index 243
creating 239–243
local prefixed index
creating 241
locally managed tablespace 137–139
locks 339
log entries 331–336
log file 333, 404
Log Miner 331
session 333
log writer 300
LOG_ARCHIVE_DEST 417
LOG_ARCHIVE_MAX_ PROCESSES 300
LOG_FILE_NAME_CONVERT 381, 404, 414
Logical Unit 393
LOGMNR_START 335
low cardinality 54, 57, 59
LUN (Logical Unit) 393
M
manageability 113, 212, 219
managed recovery 405, 418, 423, 429
MANUAL RECOVERY 423
manual refresh 442
Massively Parallel Processor (MPP) 343
master group 454
creating 454, 463, 493
master sites 445, 489
maximum extents 125, 128
maximum parallel servers 345
MAXSIZE 110, 112
MAXVALUE 213, 216
option 230
merging partitions 258–259
Microsoft C compiler 182
migrated rows 329
eliminating 74
migrating 37, 513
migrating database from UNIX to LINUX 511
minimum parallel servers 345
mirrored volume 393
mirroring 298, 314
mirrors
break 298
missing datafile 293
missing transactions 387, 397
MON_BUFFERS.SQL 309
MON_CHAIN.SQL 76
mon_chain.sql 76
MON_DBIO.SQL 326
MON_FILEIO.SQL 97
mon_free_space.sql 95
MON_PART_INDEXES.SQL 247, 250
MON_PART_TAB_STRUCT 237
MON_PART_TAB_STRUCT.SQL 235
MON_PART_TABLES 235
mon_rowid.sql 313
MON_ROWS.SQL 120
MON_SEQ.SQL 173
MON_SOURCE.SQL 164–166
MON_SP.SQL 162–163
MON_TRIGGERS.SQL 149–150
MON_VERSION.SQL 15
MOUNT 122
mount 35
MOUNT standby database 382
move a datafile 121–123
MPP 343
mpstat 319
multimaster 493
multiple buffer pool 308–311
multiple instances 22–23
multiple Oracle homes 2
multiple processes 343
N
NCLOB 47
nested loop join 344
netstat 320
network requirements
LINUX 497
new master
adding 463
NEW_LINE 179
NEW_TABLE.SQL 103
next extent 100
NEXTVAL 170
NOLOGGING 104
nonclustered tables 213, 239
NON-DEFERRABLE 50–51
nonpartitioned index 239
nonpartitioned table 46
moving 88–89
nonprefixed indexes 239, 246
NOREVERSE keyword 63
number of blocks required for rows 72
number of rows in a block
calculating 72
O
object types 142
OCI 47
Ocopy80 273
OEM 66, 69, 91, 107, 111, 147, 161, 351
OEM utility 93
OFA-compliant 503
OLTP 302, 308
on LINUX 507–509
OPEN_CURSOR procedure 175
operating system backup 264
operating system requirements
LINUX 497
OPS 62, 374
Optimizer 238, 328, 368
options
ADD DATAFILE 101
ADD PARTITION 230
AFTER 143
AUTOEXTEND 111–112
BEFORE 143
COMPUTE STATISTICS 329
CONSTRAINT 50
CREATE INDEX 353
DEGREE 353
DROP COLUMN 84, 86
DROP PARTITION 232
END BACKUP 277
ESTIMATE STATISTICS 329
EXCHANGE 225, 229
FOR EACH ROW 144
INCLUDING CONTENTS 295
MAXSIZE 112
MAXVALUE 230
MOUNT 122
NOLOGGING 104
PARALLEL 57, 104, 348
RENAME FILE 123
UNLIMITED 112
UNRECOVERABLE 104, 350
ORA-00372 93
ORA-00376 218
ORA-01109 418
ORA-01110 93, 136
ORA-01141 122
ORA-01157 136
ORA-01403 472
ORA-01495 75
ORA-01502 245
ORA-01511 122
ORA-01628 125
ORA-01630 125
ORA-01631 125
ORA-01632 125
ORA-01659 94
ORA-01776 152
ORA-12012 196
ORA-14024 241
ORA-14038 243
ORA-14074 231
ORA-14255 256
ORA-14400 213, 216
ORA-14402 216, 259
ORA-19510 116
ORA-27041 136
ORA-27072 306
Oracle block size 303
Oracle data blocks 113
corrupted 295
Oracle Data Manager 221
Oracle Data Migration Assistant 37
Oracle Database Assistant 8
Oracle datafile 328
Oracle Enterprise Manager 351, 488
Oracle Fail Safe 371–372
Oracle home directory 3
Oracle I/O statistics 328
Oracle Installer 5
LINUX 501
Oracle Net8
LINUX 505–507
Oracle Parallel Server 62, 371, 374
Oracle processes 6, 504
Oracle Recovery Manager 262, 265–270
Oracle Replication Manager 448, 481, 489
Oracle Replication Server 371–372, 432
Oracle Schema Manager 229
Oracle Services 5
Oracle SGA 308
Oracle Standby Server 373
Oracle Storage Manager 93
Oracle Universal Installer 32
Oracle user 34
Oracle version 14
ORACLE_HOME 22, 501
ORACLE_SID 22–23, 501
Oracle8
installing on Windows NT 2, 6
Oracle8 ConText Cartridge 60
Oracle8 on LINUX
installing 497–505
Oracle8 Replication Manager 445
Oracle8i
hardware requirements 32
installing on UNIX 32–38
installing on Windows NT 38, 42–44
Oracle8i Enterprise Edition 39, 42
ORATAB file 6–7
ORGANIZATION INDEX 61
OS backup 264
OSDBA 33
OSOPERATOR 33
OUI 32
P
package body 462
packaged function
autonomous transaction 202
PARALLEL 104, 348
parallel backup 291
PARALLEL clause 364, 367
parallel data manipulation 359
parallel declaration 356, 361, 363, 365
parallel degree 365
parallel delete 359, 362–364
parallel DML 86, 88, 343, 358–360, 363, 365
parallel execution 343–346, 356–357
enable 345
parallel hints 356, 361–364
parallel index 352–355
parallel insert 359, 364–366
parallel load 347–351
restrictions 347
parallel loader 351
execute 351
PARALLEL option 57
parallel query 368
Parallel Query Option 343, 359
parallel query tuning 366–369
parallel scan 367
parallel server 352
parallel update 359–360, 362
PARALLEL_ADAPTIVE_MULTI_USER 367
PARALLEL_AUTOMATIC_ TUNING 366–367
PARALLEL_COMBINED_WITH_CHILD 355
PARALLEL_COMBINED_WITH_PARENT 355, 368
PARALLEL_MAX_SERVERS 345, 367
PARALLEL_MIN_SERVERS 345
PARALLEL_SERVER_IDLE_TIME 345–346
PARALLEL_TO_PARALLEL 354
PARALLEL_TO_SERIAL 354, 361, 368
parallelism 254, 262–263
parallelization of backup and restores 262
parallelize 105
backup 265
recovery 265
parameters
BUFFER_POOL 308
DISPLAY 34
INIT.ORA 295
REMOTE_LOGIN_PASS-WORDFILE 267
USER_DUMP_DEST 18–19
UTL_FILE_DIR 178, 332
parity 314
fixed 316
PARTITION 253
partition 99, 113, 116, 130, 212, 214, 216, 225, 258, 305
raw 116
partition aware 212, 222, 238
partition columns 215
partition command 306
partition elimination 237–238
partition key 219, 235
partition properties 215–216
partition pruning 237–239
partition table 219, 230
partition view 212, 223, 225
converting to partitioned table
225–230
creating 223–225
drawbacks 223
PARTITION_VIEW_ ENABLED 224
partitioned columns 240, 250
partitioned index 46, 239
monitoring 247–250
partitioned key 221
partitioned table 46, 213, 221–222, 225, 360, 362
creating 213, 227
generating report 235
monitoring 234–237
partitioning 120, 212, 218
composite 212
deciding which tables 219
hash 212
range 212
partitioning key 250
partitions
adding 215, 230
dropping 232
merging 256–259
moving 232
number of 250
renaming 233
row movement between 259–260
specifying number 251
splitting 233, 256
truncate 232
password file
generating 266
PCTFREE 71, 73
PCTTHRESHOLD 61
performance 91, 113, 302, 357, 507–509
Performance Monitor 323–324
Windows NT 326
performance query 328–331
PL/SQL 47, 78, 82, 141, 174, 178, 207
read and write external file 178
PL/SQL block 205, 207
autonomous transaction 202
PL/SQL code
encrypted 168
hiding 168–170
PL/SQL functions 80, 142
PL/SQL8
features 141–142
PLAN.SQL 330
plug in the tablespace 132
point-in-time recovery 287
populate a table 78
PQO 343, 359
PRAGMA 201
prefixed 239
prefixed global index 246
prefixed index 240, 243, 246
primary database 374, 388, 392–393, 396, 399, 402–404,
414, 419, 424–425
primary database server 383, 385–386
configuring 407
primary server 381
PRO*C 509–511
PROC_EXTRACT_ORDER procedure 184
PROC_ORDER stored procedure 158
procedural replication 459–466
procedure 332
production database 406
propagation 481
propagator 447
ps command 320, 346
purge job scheduling 490
purge schedule 448
PUT_LINE procedures 179–180
Q
query slaves 368
QUOTA UNLIMITED 108
R
RAID 326, 394
RAID implementation 314
RAID levels 314–317
data redundancy 314
mirroring 314
parity 314
striping 314
RAID0 315, 351
RAID1
mirroring 315
RAID3
fixed parity 316
striping 316
RAID5
redundancy 317
striping 317
random access 303
range partition 212–213, 254, 256
range partitioned table
converting to 219
creating 212–218
managing 230–233
range-based partition table
creating 257
raw device 91, 107, 112, 117–119, 304
advantages 113
disadvantages 113
raw partition 113–114, 116, 305
rc0.d directory 8
read and write external file using PL/SQL 178
READ_ONLY_OPEN _DELAYED 136
READ-ONLY 393, 427, 429
read-only 92, 374, 421
read-only database 371, 383, 423
read-only mode 427–430
read-only tablespace 91–94
read-write 92
REBUILD ONLINE 86
RECOVER CANCEL 429
RECOVER DATAFILE 287, 294
RECOVER MANAGED STANDBY DATABASE 428
RECOVER STANDBY DATABASE 385, 395, 399, 428
recover the database 393
recovering the standby server 388
recovering the standby database 392, 404
recovery 262
recovery catalog 265, 268
Recovery Manager 262–263
recovery to a point in time 286
rectify tables 477–479
RECYCLE buffer pool 308
Red Hat LINUX 499
redo entries
viewing 334
redo logs 270, 286, 315, 340, 390, 393–394, 396, 403, 406,
422, 426
archive 409
reset 287
redo logs verification 295
redundancy 317
referential integrity 347
refresh group 441
registering the external procedure 184
registry
Windows NT 4
REMOTE_LOGIN_PASSWORDFILE 267
RENAME FILE 123
RENAME FILE option 121
rename tablespace 91
replicated objects 447
replication 432–435
advanced 432, 434, 466, 487–494
asynchronous 466
basic 435
COPY command 434
CREATE TABLE AS SELECT 432
export 433
import 433
row-level 459
snapshot 434
triggers 434
replication activity
resume 454
replication administrator 447
Replication Manager 488
replication model 448
replication support
generating 454, 463
RESIZE option 106
resume/suspend database 297–299
RETURNING INTO 208
REVERSE keyword 63
reverse-key index 46–63
RMAN 262–263, 265, 291
ROLLBACK 147, 203
rollback segments 12–14, 99, 340
root.sh 37
row movement 259–260
disable 260
enable 260
row space
calculating 71
ROWID 119–121, 311
extended character format 312
information 314
restricted character format 311
ROWID format 311–314
ROWID_TO_RESTRICTED 314
row-level replication 459
rows
chained 74
migrated 74
number in datafile 119–121
number of blocks required 72
S
sar command 318
scalability 91, 142
schedule service 283
scheduled links 447
screens
available products 36
configuration tools 37
create database 37
database file 37
file locations 36
installation types 36
inventory location 36
scripts
CREATE_DATABASE.SQL 11
CREATEDB.SQL 4
DOCUMENT.SQL 23, 32
EXTENTS_USER_REP.SQL 126
JOBS.SQL 197
MON_BUFFERS.SQL 309
MON_CHAIN.SQL 76
MON_DBIO.SQL 326
MON_FILEIO.SQL 97
MON_PART_INDEXES.SQL 247, 250
MON_PART_TAB_STRUCT 237
MON_ROWS.SQL 120
scripts (continued)
MON_SEQ.SQL 173
MON_SOURCE.SQL 164–166
MON_SP.SQL 162–163
MON_TRIGGERS.SQL 149–150
MON_VERSION.SQL 15
PLAN.SQL 330
SCSI 393
SELECT INTO 208
semaphores 33
SEQUENCE 171
sequence 170, 173
sequence numbers 141, 158, 170–172
generated report 173–174
sequence table 171
sequential access 303
SERIAL_TO_PARALLEL 354
Server Manager 22
session hit ratio 340
SET CONSTRAINT 51, 53
SET UNUSED COLUMN 84
SGA 22, 54, 59
shared memory 33
SHOW PARAMETERS 21
SID 44
SIGNAL procedure 189
simple snapshot 436
single-table hash cluster 46, 82
creating 82–83
site priority 467
S-LOCK 87
SMON process 97
SMP 343
snapshot 218, 434
automatic refresh 441
complete refresh 436
complex 435–436
create 438
fast refresh 436
force refresh 436
manual refresh 442
read-only 435–443
refresh 441
refresh group 441
simple 436
testing 440
snapshot log 436
snapshot log (continued)
create 437
snapshot refresh 435
snapshot site
create 437
SNP background processes 191
software requirements
Oracle8i Windows NT 41
Solaris 302
hardware requirements 32
Solaris 2.6 32
Solaris 2.7 32
sort algorithm 337
sort improvement 337–338
SORT_DIRECT_WRITES 338
SORT_MULTIBLOCK_READ_ COUNT 338
SORT_READ_FAC 338
space, estimating amount needed 70–72
space used 59
splitting partitions 256
spreading the I/O 250
SQL function 80
SQL*Loader 348
SQL*Net 506
SQL*Plus 507
standby 378
standby control file 389
standby database 137–138, 371, 374, 378, 382–389, 391,
393, 396–399, 402–404, 406, 414–415,
420–421, 424, 426–430
hot 374
managed recovery mode 405–427
mount 414
standby database server 383, 390
setting up database 395
setup 381, 413
validity of 403
standby in recovery mode 383, 416
standby mode 425
standby server
activate 395
recover 388
STANDBY_ARCHIVE_DEST 418
STANDBY_ME.CMD 402
STAR TRANSFORMATION 59
START_LOGMNR 332, 334
startup
automatic 6
statements
ALTER SYSTEM RESUME 298
ALTER SYSTEM SUSPEND 298
ALTER TABLE 225, 259
ALTER TABLE … MOVE 88
ALTER TABLESPACE BEGIN BACKUP 270
ALTER TABLESPACE END BACKUP 270
CASCADE CONSTRAINTS 84
CHECKPOINT 84
CREATE CONTROLFILE 20
CREATE DATABASE LINK 437
CREATE INDEX 63, 87
CREATE SEQUENCE 170, 172
CREATE TABLE 102, 260
DROP COLUMN 84
DROP UNUSED COLUMN 84
RECOVER STANDBY DATABASE 385
SET CONSTRAINT 51
SET UNUSED COLUMN 84
stored function 186
stored procedures 141, 143, 155–161, 166, 188, 194, 206
autonomous transaction 201
creating 158
executing 161
generated report 162–163
PROC_ORDER 158
viewing source code 164–165
stripe a tablespace 91, 97–101
striping 314, 316–317
SUBMIT procedure 192
subpartitions 254
suspend replication activity 484
swap space 32
symbolic link 114–115
creating 307
Symmetric Multiprocessor Processor (SMP) 343
synchronous 493
synchronous bidirectional replication 479–487
synchronous replication 479, 481, 484, 487
enable 484
System Global Area 22
system tables 23
T
table
drop 102
table access 341
TABLE PARTITION 228
table partitions 219, 243
storing 220
tables
cluster 46, 65
clustered 66, 218
comparing 474–477
hash cluster 46
index-organized 46, 60–62
large 46, 212, 218–219, 238
moving 102–106
nonclustered 213, 239
nonpartitioned 46
partitioned 46, 213
rectify 477–479
single-table hash cluster 46
tablespace 91, 99, 105, 107, 110–111, 116–117, 121,
128, 130, 135, 139, 212, 302
automatically extend 91, 110–112
backup 268
creating 115, 307, 404
creating new 101
move 88
on raw device 91
read-only 91–94
renaming 91
resize 106
striping 91, 97–101
temporary 12, 14
user 12
tablespace freespace 339
tablespace on raw device 112–116
creating 304–308
tablespace quota 125
for users 108–109
tablespace size
decreasing 106–107
tablespace storage 224
tablespace usage 123–125
TEMP tablespace 315
temporary log 399
temporary tablespace 12, 14
test database xvi, 2, 8
test table
creating 78–80
third party API 262
threads 346
TNSNAMES.ORA 417, 506
top 507
transaction recovery 375
transfer archive logs 384
TRANSPORT_ SET_ VIOLATIONS 130
TRANSPORT_SET_CHECK 130
transportable tablespace 91, 128–134, 137
restrictions 128
transportable tablespace set
generating 131
trigger 203–204
AFTER ROW 436
creating 145, 190
disable 144
enable 144
trigger restriction 144
triggered action 144
triggering statement 144, 154
triggers 141, 212, 434
autonomous transaction 201
generated report 148–150
INSTEAD OF 150–155
triple mirroring 298
ts_quota_rep.sql 124
tuning database 302
UNIX 318–323
Windows NT 323–325
two-phase commit 466
U
undocumented Oracle parameters 341
UNION ALL 225
UNIQUE constraint 51
uniqueness conflict 467
UNIX 302
backup script 281
installing Oracle8i 32–38
UNIX kernel
configuring 33
UNIX to LINUX 511
UNIX tools 118, 318–323
unlimited extents 125–126, 128
UNLIMITED option 110, 112
UNLIMITED usage 108
UNRECOVERABLE 104, 348, 350, 403
update conflicts 466
updateable snapshots 432
user
adding LINUX 500
user tablespace 12
USER_DUMP_DEST 18–19
USER_JOBS 196
USER_JOBS system table 196
USER_OBJECTS 29, 162
USER_SOURCE 164
USER_TRIGGERS 148, 150
useradd 34, 500
user-defined functions
creating 186–188
USERS_SEQUENCES 173
UTL_FILE 178, 181
UTL_FILE package 166, 178–179
UTL_FILE PL/SQL system package 166
UTL_FILE.FCLOSE 167
UTL_FILE.FFLUSH 167
UTL_FILE.FOPEN 167
UTL_FILE.PUT 167
UTL_FILE_DIR 178, 332
UTLCHAIN.SQL 75–76
UTLXPLAN.SQL 329
V
V$ tables 339
V$ARCHIVE 383
V$ARCHIVED_LOG 415, 421–422
v$buffer_pool 310
V$DATABASE 383
v$database 24
V$FILE_STAT 326
V$FILESTAT 98
V$LOG 382–383
v$log log 25
V$LOG_HISTORY 399
v$logfile 25
V$LOGMNR_CONTENTS 333
V$LOGMNR_CONTENTS table
querying 335
V$OPTION 15, 28
v$option 24
v$parameter 410
V$SGA 29
v$sga 25
V$TYPE_SIZE 71
V$VERSION 15, 28
v$version 24
validating data 423
VALUES LESS THAN 213
Veritas 393
versions
Oracle 14
view
create 151
vmstat 319, 508
W
WAITANY procedure 189
WAITONE 189
waits 340
Windows NT 302
exporting data 514
Oracle processes 6
Windows NT registry 4
Windows NT to LINUX 513
Windows NT tools 323–325
wrap 168, 170
wrapper procedure 459
write performance 315
WRITE_TO_FILE 166
X
XHOST 35