objective
measurements, 155
Performance page, 130
performance tuning
basics, 154
read operations, minimizing, 292
persistent beans, 323
PGA (Program Global Area), 76, 176
private SQL area, 180
sort area, 181
system resources, 179
phantom reads, 190
physical databases, 33
physical files, 36, 48
ping, 216
PITR (point-in-time recovery), 280
PKI (Public Key Infrastructure), 148
PL/SQL
stored procedures, 10
triggers, 108
PL/SQL expressions, 98
PL/SQL Function Result Cache in shared
pool area, 51
Index | 381
PLAN_TABLE, 118
PMON (Process Monitor), 53
point-in-time recovery (PITR), 280
policy, 143
polymorphism, 321
pools, sizing, 162
portals
pages, 337
portlets, 337
Pribyl, Bill, 145
primary keys, 5
business relationships, identify, 103
constraints, 105
private SQL areas, 180
private synonyms, 99
privileges, 140
Procedural Gateways, 308
procedures (see stored procedures)
Process Monitor (PMON), 53
PROCESSES, 38
processes and threads, 54
production tests, 118
Program Global Area (see PGA)
programming tools, 9
projects
causes of failure, 249
effective strategy, 251
requirements for success, 249
prompt for default security settings, 139
propagation, 219
pseudocolumns, 86
Public Key Infrastructure (PKI), 148
PUBLIC pseudorole, 141
public synonyms, 99
publish-and-subscribe functionality, Oracle8i
AQ, 220
publishers, 315
publishing solutions, 242
Q
QMN (Queue Monitor), 54
Query Management Facility, 3
query optimization, 109, 120
cost-based optimizer, 110
decision support queries, 230, 233
execution path, 109
optimizer tool, 5
ORDER BY conditions, 109
parallelizable operations, 173
rule-based optimizer, 109
Queue Monitor (QMN), 54
R
RAC (see Real Application Clusters)
RAC Guard, 27, 272
RAD (Rapid Application Development), 30
RAID (Redundant Array of Inexpensive
Disks)
basics, 163, 262
control files, need for backup, 39
interactions, 169
levels, 263
most relevant to performance, 163
selection, 263
RAID-S arrays, 166
range-range partitioning, 236
ranking functions, 233
Rapid Application Development (RAD), 30
RAW, 86
RAW datatype, 86
RDBMS (relational database management
systems)
Oracle products family, 7
READ COMMITTED isolation level, 191
read locks, 188
read operations, example, 196
read-only tablespaces, 279
REAL, 85
Real Application Clusters (RAC)
availability, 217, 270
basics, 26, 215, 269
Cache Fusion support, 216
hardware failover, compared to, 269
history, 296
node failure management, 271
parallelism, 170
physical distancing of clusters, 282
recovery phases, 271
Transparent Application Failover
(TAF), 272
Real Application Testing Option, 27, 131
realms, 152
Real-Time Decisions (RTD), 235
RECO (Recover), 53
records, 4
Recover (RECO), 53
recovery, 24
backups, using, 276
complete database recovery, 276
fault-tolerant disk arrays and, 162
instance failures, 133
operations, 134
overview, 135
PITR, 280
382 | Index
recovery (continued)
planning, 275
preparations, 133
targeted and rollforward, 276
testing, 135, 275
Recovery Manager (see RMAN)
RECYCLE buffer pool, 50
redo log buffer
defined, 51
size and performance, 178
redo logs
archives, 45, 48, 162, 284
checkpoint records, 259
cold backups and, 276
defined, 42
device assignment, 161
fast commits and, 79
filenames, 44
mirroring to remote site, 285
multiplexing, 43
naming conventions, 45
online, 46
sequence numbers, 44
suppression of logging, 42
threading, 43
Redundant Array of Inexpensive Disks (see
RAID)
REF datatype, 320
refresh, 200
relational database management systems (see
RDBMS)
relational databases, 2, 5
Relational Online Analytical Processing
(ROLAP), 245
Relational Software, Incorporated (RSI), 2
relationships, 103
REMOTE_LISTENER, 38
replication, 218, 311
bandwidth and, 286
overhead, 288
reporting functions, 233, 242, 244
Reports
basics, 244
Server, 336
Services, 339
request queues, 74
resource delivery, 299
resource manager, 185
resource utilization, 184
RESTRICTED SESSION, 143
resumable space allocation, 60, 61
RETENTION AREA, 135
Reuter, Andreas, 202
reverse key indexes, 94
REVOKE command, 142
RFID, 345
RMAN (Recovery Manager)
basics, 24, 278
incremental backups, 278
options, 134
ROLAP (Relational Online Analytical
Processing), 245
roles, 141
rollback, 78, 200, 261
ROLLBACK statements, 187
segments
basics, 78
Flashback Query and, 79
undo information, 192
rollforward, 259
rolling upgrade, 59, 300
round-trip engineering, 30
ROWID pseudocolumn, 86
rows, 90
RSI (Relational Software, Incorporated), 2
RTD (Real-Time Decisions), 235
RULE mode, 115
rule-based optimizer, 109
rules, 101
Rules Manager, 100
run queue, 182
runs, 181
S
SANs (storage area networks), 165
Schema page, 131
schemas, 4, 98
SCN (System Change Number), 78, 192, 280
scripts, database creation, 63
Secure Backup Express (XE), 135
Secure Enterprise Search, 13
Secure Keys, 327
security
administration, 139
advanced options, 28, 148
applications, 146
auditing, 138, 150
compliance, 151
data access restrictions, 144
database features, 27
distributed management, 147
identity management, 141, 338
multitiered implementations, 147
Oracle Application Server, 338
Index | 383
???out of the box??? default prompt, 143
patching, automated, 138
privileges, 141
third-party authentication services, 148
user accounts, 147
view-based, 144
security ???rolling patch,??? 138
security policies, 145
Segment Advisor, 125, 158
segments, 41, 132
SELECT
basics, 234
model clause, 234
security privileges, 141
self-managing features, 2
sequences, 5, 98
SERIALIZABLE isolation level, 191
serialization, 190
server, 71
Server page, 130
server processes, 70
dedicated, 73
PGA and, 179
service management, 300
service names, 64
resolution, 64
(see also naming services)
Service Registry
advertisements, 16
basics, 348
publishing, 16
Service Requests (SRs), 137
Service-Oriented Architecture (SOA), 323
session beans, 323
session memory, 76
SESSIONS, 38
SET ROLE command, using in
applications, 146
SGA (System Global Area)
components, 50
defined, 176
memory
allocation, initialization
parameters, 176
components, 48
resources, 176, 179
pools, 51
session data, for storage of, 76
SGA_TARGET, 49
shadow processes, 70
shared locks, 188
shared pool
basics, 51
size and performance, 177
shared servers, 74, 212
connection process, 75
data dictionary information, 76
initialization parameters, 74
model, 74
shared SQL
basics, 211
bind variables, 214
SHARED_SERVERS, 38
SHUTDOWN, 142
shutting down, databases, 69
Sigma Dynamics, 235
SIMPLE_INTEGER, 85
single database block I/Os, 160
single source code model, 8
SIP Servlet Container, 17
sizing the sort area, 181
SMALLINT, 85
SMON (System Monitor), 53
SMP (Symmetric Multiprocessing)
systems, 293
CPU quantity and system bus, 294
defined, 169
snowflake schemas, 231
SOA (Service-Oriented Architecture), 323
SOA Suite for Middleware, 16, 345, 347
Software and Support page, 131
software, additional needs, 236
sort area, sizing, 181
spatial
information systems and Oracle, 13
Spatial Option, 235
SPFILE, 37
backup, 276
system parameter storage, 68
spindles, 166
SQL (Structured Query Language)
access to and from non-Oracle
databases, 306
bad, 182
basics, 5
defined, 10
DML, 77
plan baselines, 117
statements
parsing and optimizing, 80
table order and optimization, 110
tuning, 120
384 | Index
SQL Advisor
combined functionality, 183
defined, 120
performance, 124
tuning applications, 157
SQL EXPLAIN PLAN statement, 118
SQL Performance Impact Advisor, 124
SQL Repair Advisor, 125
SQL Test Case Builder, 138
SQL UPDATE, 194
SQL*Analyzer tool, 117
SQL*Loader, direct path load, 240
SQL*Net, configuration, 63
SQL*Plus, PL/SQL blocks and, 10
SQLJ, 322
SQLNET file, 68
SRs (Service Requests), 137
stack, 256
stack space, 180
Standalone Management Packs, 126
Standard Edition, 333
Standard Edition One, 333
standby databases, 217, 282
Data Guard, 25
potential data losses with site failure, 284
star queries, 21
star schemas, 229
access facts along ???look-up??? values, 223
cost-based query optimization, 230
starting up databases, 68
STARTUP, 68, 142
state, 76
storage area networks (SANs), 165
storage management, 158, 168
Storagetek dedicated storage
subsystems, 165
stored outlines, 117, 212
stored procedures
based systems (TP-Lite), 208
basics, 207
defined, 5
granting security privileges directly, 146
PL/SQL, 207
variables, datatype attribute, 82
Streams, 316
AQ (Advanced Queuing), 19, 218
bandwidth and, 286
cascading failures, 218
change data capture, 19
change data capture, enabling, 218
data
capture, 19
consumption, 19
staging, 19
data divergence, 288
data tolerance, 286
database administrators, 287
direct system dependencies,
avoiding, 218
distance between sites, 286
export options, 288
hub-and-spoke architecture, 219
integration problems, 219
intersystem communication, 218
messaging, 218
network and site stability, 287
new system connection, 220
performance requirements, 286
propagation, 219
redundant data, 287
replication, 218, 286
asynchronous, 287
log-based, 19
lost data, 287
synchronous, 287
spokes and, 220
system failures, 218
system interfaces, 219
transaction
overhead, 288
queue, 287
triggers, 287
warehousing, 219
streams pool, 52
Streams Tuning Advisor, 125
striped disk arrays, 165, 168
loss of disks, 39
Oracle I/O, interaction, 168
striping
defined, 167
with parity, 263
Structured Query Language (see SQL)
subscribers, 315
summary tables, 232
support services available through Oracle
Corporation, 137
Support Workbench, 138
surge protection, 342
Symmetric Multiprocessing (SMP) systems
(see SMP)
Index | 385
symmetric replication, 239
synchronized sites, 311
synchronous replication, 286, 287
synchronous writing, 44
synonyms, 5, 98
SYS and SYSTEM user accounts, 140
System Change Number (SCN), 78, 192, 280
system crashes, 257
error messages, 258
preparation for, 262
System Global Area (see SGA)
system memory, types, 291, 301, 303
System Monitor (SMON), 53
System Monitoring plug-ins, 126
system overhead, 162
T
tables
data dictionary, 54
defined, 90
design, 102
external tables, defined, 90
fragmentation resolution, 132
index scans, 175
index-organized tables (IOTs), 93
parent-child relationship, 106
performance, impact on
reorganization, 132
tablespaces, 34, 35
batch operations and, 60
big files, 35
locally managed, 35
segregation of I/O, 161
tabs, 130
TAF (Transparent Application Failover), 217
configurations, 274
failover-aware applications, for
developing, 273
high availability benefits, 272
implementation, 274
JDBC support of, 274
ODBC support of, 274
tape drives, 136
TARs (Technical Assistance Requests), 137
TDE (Transparent Data Encryption), 149
Technical Assistance Requests (TARs), 137
technical requirement solutions, 222
Text Management, 324
thin client (DHTML), 242
third normal form (3NF), 102
third-generation languages (3GLs), 10, 11
third-party naming services, 65
threads, 43
processes and, 54
redo log files, 43
three-dimensional geometry objects, 329
three-state logic, 89
three-tier systems, 208
TimesTen, 17
TKPROF utility, 119, 120
TNS_ADMIN environment variable and
Oracle Net, 67
TNSNAMES file, 64, 67
TopLink, 335
Total Recall Option, 279, 281
TP (transaction processing) monitors, 208,
309
services, 208
TP-Lite, 208
Transaction Processing, Concepts and
Techniques, 202
transaction processing (TP) monitors, 208,
309
transactions, 7
ACID properties, 202
basics, 202
commitment, 258
consistent, 202
defined, 77, 187
distributed, 17
durable, 202
isolation, 189, 191, 202
locks, and FOR UPDATE clause, 189
routing, three-tier systems, 209
step-by-step example, 80
steps for, 81
transient failure recovery, 266
Transparent Application Failover (see TAF)
Transparent Data Encryption (TDE), 149
Transparent Gateways, 18, 239, 306
defined, 307
transportable tablespaces, 18, 239, 317
trickle feed, 238
triggers
compound, 108
database-level event, 108
defined, 107, 108
events, 107
INSTEAD OF, 108
procedural languages for writing, 108
restrictions, 108
row and statement level activation, 107
schema-level event, 108
vs.
Pages:
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779