backups
history, 7
large files, 172
high-speed data pump, 18
secure backup, 149
large objects, space limitation, 10
cached results, 51
management, self-tuning, 23
configuration automation, 66
OMFs (Oracle Managed Files), 35
consoles, 129
Real Application Clusters (RAC), 26
creation, 63
redo logs, device assignment, 162
Data Guard
secure backup, 25, 149
management, 284
self-managing features, 2
standby enhancements, 282
Streams, 19
Data Mining Option, enhancements, 247
transportable tablespaces, 18
Database Change Notification, 316
web services, 323
database OLAP option query, rewrite and
workspace enhancements, 200
improved manageability, 245
Oracle Database 10g Release 2
Database Replay, 118
Advanced Security Option (ASO), 148
Database Resource Manager (DRM), 184
backups, third-party utilities, 135
development, 7
data, extended logic, 100
disks, deployment strategy, 301
encryption, 149
encryption, tablespaces, 149
heterogeneous services, 19
enhancements, high availability, 218
instances, clustered and nonclustered
fast mirror resynchronization, 266
applications, 343
fault diagnosability infrastructure, 125
integration, 340
features
management beans, 341
self-management, 124
multitier security, 148
self-tuning, 124
partition pruning, 97
Flashback
performance, improved, 235
compliance issues, 153
portal, 337
Data Archive, 153
queuing, nonpersistent message, 314
transaction commands, 279, 281
Real Application Clusters (RAC)
transactions, 80
Cache Fusion support, 217
Fusion Middleware, 332
reorganize partitions online, 97
grid computing, 304, 317
Streams, 316
individual row change notification, 316
tablespaces, 35
inheritance support, 321
write operations, 194
initialization parameters, 37
Oracle Database 11g
installation, 56
Advanced Compression Options, 301
interval partitioning, 25
advisors, 124
invisible indexes, 92, 96
Application Express (ApEx), 331
manageability functionality, 130
medical imaging standard support, 326
Index
|
377
Oracle Database 11g
(continued)
summary of new features, 349
memory management, automatic, 49, 76,
tabs, 130
157, 176
three-dimensional geometry objects, 329
MEMORY_TARGET, 49, 52
Total Recall Option, 279, 281
messaging server, 315
transactions, 7
Multimedia enhancements, 322, 325
changes, store and track, 279
object-relational enhancements, 321, 329
data reversion, 281
OLTP enhancements, 218
management, 158
Oracle Internet Directory (OID), 64, 68
transient failure recovery, 266
Partition Advisor, 97, 120
transparent data encryption, 28
partitioning
Transparent Gateway
automatic range creation, 236
extended targets, 307
composite, 96
query performance, 316
compound, 107
Undo Advisor, 125
enhancements, 236
UNDO_MANAGEMENT, 38
interval, 96
upgrades, 59
pruning, 97
virtual table columns, 91
triggers, 108
web service support, 329
performance
workload capture, 118
basics, 160
workspace, enhancements, 200
improvement, 235
Oracle Database Configuration Assistant, 62
PGA (Program Global Area)
Oracle Database Vault Option, 28, 151
memory allocation
Oracle Designer, 30, 228
sort area, sizing, 181
Oracle Discoverer, Administration
PL/SQL expressions, sequencing, 98
Edition, 30
PL/SQL Function Result Cache in shared
Oracle Enterprise Edition, 7
pool area, 51
Spatial option, 13
problems, reporting, 138
Oracle Enterprise Manager (see EM)
production tests, 118
Oracle Enterprise Manager Grid
profiling, automatic, 157
Control, 156
prompt for default security settings, 139
Oracle Essentials, xi, xvi
query, results caching, 179
Oracle Export utility, 288
Real Application Testing Option, 27, 131
Oracle Express Edition, 8
redo log archiving, 259, 285
Oracle Forms Developer, 29
resource manager, 185
Oracle HTTP Server (OHS), 334
service management, multitier, 300
Oracle Identity Management (OIM), 147
Service-Oriented Architecture (SOA),
Oracle Information Appliance Initiative, 301
providers, 323
Oracle installer
SGA, sort area, sizing, 181
basics, 56
SGA_TARGET, 49
OFA standards, embedding, 58
SOA Suite, 345, 347
Oracle Universal Installer, 56
spatial enhancements, 322, 324, 328
Oracle Intelligent Agent, 67
SQL Advisor, 157, 183
Oracle Internet Directory (OID), 14, 64, 68,
SQL Advisor tool, 120
147, 338
SQL Performance Impact Advisor, 124
Oracle Java Virtual Machine (JVM), 323
SQL performance improvement, 183
Oracle JDeveloper, 29
SQL plan baselines, 117
Oracle JVM (Java Virtual Machine), 323
standby database, 283
Oracle Lite, 32
storage management, 158
Oracle Managed Files (OMFs), 35
storage management capabilities, 168
Oracle Management Agents, 127
Streams
Oracle Management Repository, 128
enhancement, 316
Oracle Management Service (OMS), 128
functionality in grid computing, 316
Oracle messaging, 19
378
|
Index
Oracle Multimedia, 12, 235, 322, 324
PITR, tablespace level, 280
Oracle Names, 64
TAF (Transparent Application
Oracle Net, 63
Failover), 272, 274
client/server connections, 72
triggers, PL/SQL, 108
configuration, 63
Oracle8i, 8
configuration files, 67
AQ enhancements, publish-and-subscribe
creating, 66
capabilities, 315
syntax, 66
checkpoint frequency variance, 260
Connection Manager (CMAN), 212
deferred rollback, enhancements, 261
connection pooling, 212
DRM (Database Resource Manager), 214
service names, resolving, 64
function-based indexes, 95
multiple options, using, 65
Java, 10, 56
supported protocols, 64
JServer, 323
Oracle Net Listener, 72
materialized views, 91
Oracle Net Manager, 66
Objects and Extensibility features, 319
Oracle Net services, 64
OLTP enhancements, 206
Oracle Optimized Warehouse Initiative, 301
redo log archiving, 284
Oracle Parallel Fail Safe, 272
TAF (Transparent Application Failover)
Oracle Parallel Server (OPS), 170, 215, 296
enhancements, 273
Oracle Personal Edition, 8
transportable tablespaces, 18
Oracle PL/SQL for DBAs, 145
triggers, Java, 108
Oracle PL/SQL Programming, 145
Oracle9i
Oracle products, 7
AnyType datatype, 88
Oracle Reports Developer, 29
AQ
Oracle Secure Backup, 25
enhancements, 313
Oracle Sensor Edge Server, 345
XML support, 19
Oracle Spatial Option
CREATE TABLE...AS SELECT online
enhancements, 322, 328
operation, 132
Multimedia and, 324
Data Guard
object types, 329
basics, 26
Oracle SQL Developer, 29
future enhancements, 283
Oracle Standard Edition, 7
database block sizes, 40
Oracle Standard Edition One, 7
datatype
Oracle Streams, 19
conversions, 87
Oracle Technology Network (OTN), 357
user-defined, 88
Oracle Text, supported formats, 325
DRM (Database Resource Manager), 215
Oracle Type Translator (OTT), 321
Flashback Query, 79
Oracle Universal Installer, 56
granule, 49
Oracle Wallets, 148
inheritance support, 321
Oracle Wireless, 16
instance recovery enhancements, 260
Oracle Worldwide Customer Support
IOT (index organized table)
Services, 137
enhancements, 93
ORACLE_HOME environment variables, 58
Java and, 10
Oracle7, 110
logical standby, 217
Oracle8
LogMiner, 277
ANALYZE command, 112
memory allocation, dynamic resizing
cost-based optimization, 111
of, 176
datatypes, user-defined, 87
Microsoft Transaction Server
extensibility options, 12
transactions, 309
large pool, 76
Multimedia, 12, 235, 324
NOLOGGING keyword, 42
NCHAR, NVARCHAR2, specifying
Partitioning option, 96
datatype length, 84
Index
|
379
Oracle9i
(continued)
partial restore and rollforward recovery, 276
OLTP enhancements, 206
Partition Advisor, 97
OMFs (Oracle Managed Files), 35
partitioning
Oracle JVM, 323
compound, 107
Oracle Net, 64
of data structures, 96
Oracle Net Manager, 66
options, 25
parameters, setting, 68
parallelism, 170, 175
persistent beans, support, 323
Partitioning option, uses, 236
RAC Guard, 27, 272
pruning, 97
Real Application Clusters (RAC), 26, 193,
tables and block-range parallelism, 171
215
triggers, 108
recovery process, enhancements, 276
passwords
resumable space allocation, 60
backup of files, 276
RMAN, 134
usernames, 140
rollback segments, automatic
PE (parallel execution) processes
management, 78
block ranges, 170
SGA, changing the size of, 49
management, 173
shared server, 212
PeopleSoft support, 327
Unicode 3.0 support, 12
performance, 155
workspaces, 198
application design and, 159
XMLType datatype, 87
evaluation, 156
Oracle9iAS (Oracle9i Application Server), 71
machine resources and, 158
Oracle9iAS Portal, 30, 31
memory and, 176
OracleAS Wireless
monitoring, Unix and Windows NT, 159
mobile enablers, 338
potential bottlenecks, 158
modes, 337
problem resolution, 159
request information, 337
RAID, 163
send to wireless users, 337
servers and, 156
wireless contact maintenance, 338
tuning basics, 154
OracleDatabase 11g
user satisfaction vs. objective
query, optimization, 230
measurements, 155
OTT (Oracle Type Translator), 321
Performance page, 130