performance tuning
P
basics, 154
read operations, minimizing, 292
pages, 337
persistent beans, 323
parallel bitmap star joins, 21
PGA (Program Global Area), 76, 176
parallel execution (PE) processes (see PE)
private SQL area, 180
Parallel Fail Safe, 27, 272
sort area, 181
parallelization, 20
system resources, 179
block-range, 170
phantom reads, 190
databases, large, 169
physical databases, 33
index scans, 175
physical files, 36, 48
operations available, 172
ping, 216
partition-based, 174
PITR (point-in-time recovery), 280
self-tuning adaptive, 174
PKI (Public Key Infrastructure), 148
subpartitions, 175
PL/SQL
tables and, 175
stored procedures, 10
parity, 263
triggers, 108
parse
PL/SQL expressions, 98
excessive, 183
PL/SQL Function Result Cache in shared
phase, 214
pool area, 51
380
|
Index
PLAN_TABLE, 118
R
PMON (Process Monitor), 53
RAC (see Real Application Clusters)
point-in-time recovery (PITR), 280
RAC Guard, 27, 272
policy, 143
RAD (Rapid Application Development), 30
polymorphism, 321
RAID (Redundant Array of Inexpensive
pools, sizing, 162
Disks)
portals
basics, 163, 262
pages, 337
control files, need for backup, 39
portlets, 337
interactions, 169
Pribyl, Bill, 145
levels, 263
primary keys, 5
most relevant to performance, 163
business relationships, identify, 103
selection, 263
constraints, 105
RAID-S arrays, 166
private SQL areas, 180
range-range partitioning, 236
private synonyms, 99
ranking functions, 233
privileges, 140
Rapid Application Development (RAD), 30
Procedural Gateways, 308
RAW, 86
procedures (see stored procedures)
RAW datatype, 86
Process Monitor (PMON), 53
RDBMS (relational database management
PROCESSES, 38
systems)
processes and threads, 54
Oracle products family, 7
production tests, 118
READ COMMITTED isolation level, 191
Program Global Area (see PGA)
read locks, 188
programming tools, 9
read operations, example, 196
projects
read-only tablespaces, 279
causes of failure, 249
REAL, 85
effective strategy, 251
Real Application Clusters (RAC)
requirements for success, 249
availability, 217, 270
prompt for default security settings, 139
basics, 26, 215, 269
propagation, 219
Cache Fusion support, 216
pseudocolumns, 86
hardware failover, compared to, 269
Public Key Infrastructure (PKI), 148
history, 296
PUBLIC pseudorole, 141
node failure management, 271
public synonyms, 99
parallelism, 170
publish-and-subscribe functionality, Oracle8i
physical distancing of clusters, 282
AQ, 220
recovery phases, 271
publishers, 315
Transparent Application Failover
publishing solutions, 242
(TAF), 272
Real Application Testing Option, 27, 131
Q
realms, 152
QMN (Queue Monitor), 54
Real-Time Decisions (RTD), 235
Query Management Facility, 3
RECO (Recover), 53
query optimization, 109, 120
records, 4
cost-based optimizer, 110
Recover (RECO), 53
decision support queries, 230, 233
recovery, 24
execution path, 109
backups, using, 276
optimizer tool, 5
complete database recovery, 276
ORDER BY conditions, 109
fault-tolerant disk arrays and, 162
parallelizable operations, 173
instance failures, 133
rule-based optimizer, 109
operations, 134
Queue Monitor (QMN), 54
overview, 135
PITR, 280
Index
|
381
recovery
(continued)
Reuter, Andreas, 202
planning, 275
reverse key indexes, 94
preparations, 133
REVOKE command, 142
targeted and rollforward, 276
RFID, 345
testing, 135, 275
RMAN (Recovery Manager)
Recovery Manager (see RMAN)
basics, 24, 278
RECYCLE buffer pool, 50
incremental backups, 278
redo log buffer
options, 134
defined, 51
ROLAP (Relational Online Analytical
size and performance, 178
Processing), 245
redo logs
roles, 141
archives, 45, 48, 162, 284
rollback, 78, 200, 261
checkpoint records, 259
ROLLBACK statements, 187
cold backups and, 276
segments
defined, 42
basics, 78
device assignment, 161
Flashback Query and, 79
fast commits and, 79
undo information, 192
filenames, 44
rollforward, 259
mirroring to remote site, 285
rolling upgrade, 59, 300
multiplexing, 43
round-trip engineering, 30
naming conventions, 45
ROWID pseudocolumn, 86
online, 46
rows, 90
sequence numbers, 44
RSI (Relational Software, Incorporated), 2
suppression of logging, 42
RTD (Real-Time Decisions), 235
threading, 43
RULE mode, 115
Redundant Array of Inexpensive Disks (see
rule-based optimizer, 109
RAID)
rules, 101
REF datatype, 320
Rules Manager, 100
refresh, 200
run queue, 182
relational database management systems (see
runs, 181
RDBMS)
relational databases,
2, 5
S
Relational Online Analytical Processing
SANs (storage area networks), 165
(ROLAP), 245
Schema page, 131
Relational Software, Incorporated (RSI), 2
schemas, 4, 98
relationships, 103
SCN (System Change Number), 78, 192, 280
REMOTE_LISTENER, 38
scripts, database creation, 63
replication, 218, 311
Secure Backup Express (XE), 135
bandwidth and, 286
Secure Enterprise Search, 13
overhead, 288
Secure Keys, 327
reporting functions, 233, 242, 244
security
Reports
administration, 139
basics, 244
advanced options, 28, 148
Server, 336
applications, 146
Services, 339
auditing, 138, 150
request queues, 74
compliance, 151
resource delivery, 299
data access restrictions, 144
resource manager, 185
database features, 27
resource utilization, 184
distributed management, 147
RESTRICTED SESSION, 143
identity management, 141, 338
resumable space allocation, 60, 61
multitiered implementations, 147
RETENTION AREA, 135
Oracle Application Server, 338
382
|
Index
“out of the box” default prompt, 143
shared pool
patching, automated, 138
basics, 51
privileges, 141
size and performance, 177
third-party authentication services, 148
shared servers, 74, 212
user accounts, 147
connection process, 75
view-based, 144
data dictionary information, 76
security “rolling patch,” 138
initialization parameters, 74
security policies, 145
model, 74
Segment Advisor, 125, 158
shared SQL
segments, 41, 132
basics, 211
SELECT
bind variables, 214
basics, 234
SHARED_SERVERS, 38
model clause, 234
SHUTDOWN, 142
security privileges, 141
shutting down, databases, 69
self-managing features, 2
Sigma Dynamics, 235
sequences, 5, 98
SIMPLE_INTEGER, 85
SERIALIZABLE isolation level, 191
single database block I/Os, 160
serialization, 190
single source code model, 8
server, 71
SIP Servlet Container, 17
Server page, 130
sizing the sort area, 181
server processes, 70
SMALLINT, 85
dedicated, 73
SMON (System Monitor), 53
PGA and, 179
SMP (Symmetric Multiprocessing)
service management, 300
systems, 293
service names, 64
CPU quantity and system bus, 294
resolution, 64
defined, 169
(see also naming services)
snowflake schemas, 231
Service Registry
SOA (Service-Oriented Architecture), 323
advertisements, 16
SOA Suite for Middleware, 16, 345, 347
basics, 348
Software and Support page, 131
publishing, 16
software, additional needs, 236
Service Requests (SRs), 137
sort area, sizing, 181
Service-Oriented Architecture (SOA), 323
spatial
session beans, 323
information systems and Oracle, 13
session memory, 76
Spatial Option, 235
SESSIONS, 38
SPFILE, 37
SET ROLE command, using in
backup, 276
applications, 146
system parameter storage, 68
SGA (System Global Area)
spindles, 166
components, 50
SQL (Structured Query Language)
defined, 176
access to and from non-Oracle
memory
databases, 306
allocation, initialization
bad, 182
parameters, 176
basics, 5
components, 48
defined, 10
resources, 176, 179
DML, 77
pools, 51
plan baselines, 117
session data, for storage of, 76
statements
SGA_TARGET, 49
parsing and optimizing, 80
shadow processes, 70
table order and optimization, 110
shared locks, 188
tuning, 120
Index
|
383
SQL Advisor
data
combined functionality, 183
capture, 19
defined, 120
consumption, 19
performance, 124
staging, 19
tuning applications, 157
data divergence, 288
SQL EXPLAIN PLAN statement, 118
data tolerance, 286
SQL Performance Impact Advisor, 124
database administrators, 287
SQL Repair Advisor, 125
direct system dependencies,
SQL Test Case Builder, 138
avoiding, 218
SQL UPDATE, 194
distance between sites, 286
SQL*Analyzer tool, 117
export options, 288
SQL*Loader, direct path load, 240
hub-and-spoke architecture, 219
SQL*Net, configuration, 63
integration problems, 219
SQL*Plus, PL/SQL blocks and, 10
intersystem communication, 218
SQLJ, 322
messaging, 218
SQLNET file, 68
network and site stability, 287