..AS SELECT online
operation, 132
Data Guard
basics, 26
future enhancements, 283
database block sizes, 40
datatype
conversions, 87
user-defined, 88
DRM (Database Resource Manager), 215
Flashback Query, 79
granule, 49
inheritance support, 321
instance recovery enhancements, 260
IOT (index organized table)
enhancements, 93
Java and, 10
logical standby, 217
LogMiner, 277
memory allocation, dynamic resizing
of, 176
Microsoft Transaction Server
transactions, 309
Multimedia, 12, 235, 324
NCHAR, NVARCHAR2, specifying
datatype length, 84
380 | Index
Oracle9i (continued)
OLTP enhancements, 206
OMFs (Oracle Managed Files), 35
Oracle JVM, 323
Oracle Net, 64
Oracle Net Manager, 66
parameters, setting, 68
persistent beans, support, 323
RAC Guard, 27, 272
Real Application Clusters (RAC), 26, 193,
215
recovery process, enhancements, 276
resumable space allocation, 60
RMAN, 134
rollback segments, automatic
management, 78
SGA, changing the size of, 49
shared server, 212
Unicode 3.0 support, 12
workspaces, 198
XMLType datatype, 87
Oracle9iAS (Oracle9i Application Server), 71
Oracle9iAS Portal, 30, 31
OracleAS Wireless
mobile enablers, 338
modes, 337
request information, 337
send to wireless users, 337
wireless contact maintenance, 338
OracleDatabase 11g
query, optimization, 230
OTT (Oracle Type Translator), 321
P
pages, 337
parallel bitmap star joins, 21
parallel execution (PE) processes (see PE)
Parallel Fail Safe, 27, 272
parallelization, 20
block-range, 170
databases, large, 169
index scans, 175
operations available, 172
partition-based, 174
self-tuning adaptive, 174
subpartitions, 175
tables and, 175
parity, 263
parse
excessive, 183
phase, 214
partial restore and rollforward recovery, 276
Partition Advisor, 97
partitioning
compound, 107
of data structures, 96
options, 25
parallelism, 170, 175
Partitioning option, uses, 236
pruning, 97
tables and block-range parallelism, 171
triggers, 108
passwords
backup of files, 276
usernames, 140
PE (parallel execution) processes
block ranges, 170
management, 173
PeopleSoft support, 327
performance, 155
application design and, 159
evaluation, 156
machine resources and, 158
memory and, 176
monitoring, Unix and Windows NT, 159
potential bottlenecks, 158
problem resolution, 159
RAID, 163
servers and, 156
tuning basics, 154
user satisfaction vs.
Pages:
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779