, 204
history of, 201
Oracle features for, 211, 218
Oracle products and, 205
system architectures, 206
systems, contrasted with data
warehouses, 223
two-tier client/server, 206
OMFs (Oracle Managed Files), 35
online datafile backups, 133
online redo log files, 46
online transaction processing (see OLTP)
open connectivity, 307
Open DataBase Connectivity (ODBC), 11
OPEN_CURSORS, 38
opening, databases, 69
operating system audit trail, 150
Operating System Management Packs, 126
operational data store (ODS), 226
operators, 330
OPS (Oracle Parallel Server), 26, 170, 215,
296
Optimal Flexible Architecture (OFA), 58
Optimal Flexible Architecture for a Growing
Oracle Database, 58
optimize phase, 214
OPTIMIZER_MODE, 114
ORA_ROWSCN, 87
ORA-01034: Oracle not available
message, 258
ORA-03113: End-of-file on communication
channel message, 258
Oracle
architecture, 33, 290
auditing, 139
binary XML, 235
capabilities, 331
client/server communication,
configuring, 63
compliance, 139
concurrency, multiuser, 186
content management suite, 12
data structures, 82
datatypes, extended, 318
distributed data and databases, 305
high availability, 253
history, 1, 7
I/O management, 50
installation, 56, 57, 59
installation and running, 56
Java support, 322
locking model and, 228
management, 122
multiple versions on one server, 58
object technologies, supported, 221
OLTP, basics, 201
parallelism, support for, 170
performance, 154
security, 139
single source code model, 8
supported operating systems, 6
transaction processing, 201
warehousing, 222
Oracle Application Server
components, 334
installation, 334
security, 338
Web Cache, 341
Oracle Application Server Containers, 335
Oracle Application Server Portal, 15, 337
Oracle Application Server Web Cache, 15
Oracle Audit Vault Server, 153
Oracle Berkeley DB, 31
Oracle Business Intelligence Enterprise
Edition Suite (OBI EE), 22
Oracle Call Interface (OCI), 11
Oracle Corporation, 5
Oracle data dictionary, 54
Index | 377
Oracle Data Guard, 282
Oracle Database 10g
advanced queuing, 19
Automated Storage Management
(ASM), 27
automatically and dynamically size pools
in SGA, 162
configuration, 15
Data Guard
basics, 26
management, 284
grid computing, 2
deployment models, 8
history, 7
high-speed data pump, 18
large objects, space limitation, 10
management, self-tuning, 23
OMFs (Oracle Managed Files), 35
Real Application Clusters (RAC), 26
redo logs, device assignment, 162
secure backup, 25, 149
self-managing features, 2
Streams, 19
transportable tablespaces, 18
web services, 323
workspace enhancements, 200
Oracle Database 10g Release 2
Advanced Security Option (ASO), 148
backups, third-party utilities, 135
data, extended logic, 100
encryption, 149
heterogeneous services, 19
instances, clustered and nonclustered
applications, 343
integration, 340
management beans, 341
multitier security, 148
partition pruning, 97
performance, improved, 235
portal, 337
queuing, nonpersistent message, 314
Real Application Clusters (RAC)
Cache Fusion support, 217
reorganize partitions online, 97
Streams, 316
tablespaces, 35
write operations, 194
Oracle Database 11g
Advanced Compression Options, 301
advisors, 124
Application Express (ApEx), 331
Application Server
application server editions, 333
basics, 333
ASM improvements, 300
auditing on by default, 139, 150
automated memory management of SGA
and PGA size, 124
Automatic Database Diagnostic Monitor
(ADDM), 157, 159
automatic storage management, 266
Automatic Workload Repository, 156
background processes, 52
backups
large files, 172
secure backup, 149
cached results, 51
configuration automation, 66
consoles, 129
creation, 63
Data Guard
management, 284
standby enhancements, 282
Data Mining Option, enhancements, 247
Database Change Notification, 316
database OLAP option query, rewrite and
improved manageability, 245
Database Replay, 118
Database Resource Manager (DRM), 184
development, 7
disks, deployment strategy, 301
encryption, tablespaces, 149
enhancements, high availability, 218
fast mirror resynchronization, 266
fault diagnosability infrastructure, 125
features
self-management, 124
self-tuning, 124
Flashback
compliance issues, 153
Data Archive, 153
transaction commands, 279, 281
transactions, 80
Fusion Middleware, 332
grid computing, 304, 317
individual row change notification, 316
inheritance support, 321
initialization parameters, 37
installation, 56
interval partitioning, 25
invisible indexes, 92, 96
manageability functionality, 130
medical imaging standard support, 326
378 | Index
Oracle Database 11g (continued)
memory management, automatic, 49, 76,
157, 176
MEMORY_TARGET, 49, 52
messaging server, 315
Multimedia enhancements, 322, 325
object-relational enhancements, 321, 329
OLTP enhancements, 218
Oracle Internet Directory (OID), 64, 68
Partition Advisor, 97, 120
partitioning
automatic range creation, 236
composite, 96
compound, 107
enhancements, 236
interval, 96
pruning, 97
triggers, 108
performance
basics, 160
improvement, 235
PGA (Program Global Area)
memory allocation
sort area, sizing, 181
PL/SQL expressions, sequencing, 98
PL/SQL Function Result Cache in shared
pool area, 51
problems, reporting, 138
production tests, 118
profiling, automatic, 157
prompt for default security settings, 139
query, results caching, 179
Real Application Testing Option, 27, 131
redo log archiving, 259, 285
resource manager, 185
service management, multitier, 300
Service-Oriented Architecture (SOA),
providers, 323
SGA, sort area, sizing, 181
SGA_TARGET, 49
SOA Suite, 345, 347
spatial enhancements, 322, 324, 328
SQL Advisor, 157, 183
SQL Advisor tool, 120
SQL Performance Impact Advisor, 124
SQL performance improvement, 183
SQL plan baselines, 117
standby database, 283
storage management, 158
storage management capabilities, 168
Streams
enhancement, 316
functionality in grid computing, 316
summary of new features, 349
tabs, 130
three-dimensional geometry objects, 329
Total Recall Option, 279, 281
transactions, 7
changes, store and track, 279
data reversion, 281
management, 158
transient failure recovery, 266
transparent data encryption, 28
Transparent Gateway
extended targets, 307
query performance, 316
Undo Advisor, 125
UNDO_MANAGEMENT, 38
upgrades, 59
virtual table columns, 91
web service support, 329
workload capture, 118
workspace, enhancements, 200
Oracle Database Configuration Assistant, 62
Oracle Database Vault Option, 28, 151
Oracle Designer, 30, 228
Oracle Discoverer, Administration
Edition, 30
Oracle Enterprise Edition, 7
Spatial option, 13
Oracle Enterprise Manager (see EM)
Oracle Enterprise Manager Grid
Control, 156
Oracle Essentials, xi, xvi
Oracle Export utility, 288
Oracle Express Edition, 8
Oracle Forms Developer, 29
Oracle HTTP Server (OHS), 334
Oracle Identity Management (OIM), 147
Oracle Information Appliance Initiative, 301
Oracle installer
basics, 56
OFA standards, embedding, 58
Oracle Universal Installer, 56
Oracle Intelligent Agent, 67
Oracle Internet Directory (OID), 14, 64, 68,
147, 338
Oracle Java Virtual Machine (JVM), 323
Oracle JDeveloper, 29
Oracle JVM (Java Virtual Machine), 323
Oracle Lite, 32
Oracle Managed Files (OMFs), 35
Oracle Management Agents, 127
Oracle Management Repository, 128
Oracle Management Service (OMS), 128
Oracle messaging, 19
Index | 379
Oracle Multimedia, 12, 235, 322, 324
Oracle Names, 64
Oracle Net, 63
client/server connections, 72
configuration, 63
configuration files, 67
creating, 66
syntax, 66
Connection Manager (CMAN), 212
connection pooling, 212
service names, resolving, 64
multiple options, using, 65
supported protocols, 64
Oracle Net Listener, 72
Oracle Net Manager, 66
Oracle Net services, 64
Oracle Optimized Warehouse Initiative, 301
Oracle Parallel Fail Safe, 272
Oracle Parallel Server (OPS), 170, 215, 296
Oracle Personal Edition, 8
Oracle PL/SQL for DBAs, 145
Oracle PL/SQL Programming, 145
Oracle products, 7
Oracle Reports Developer, 29
Oracle Secure Backup, 25
Oracle Sensor Edge Server, 345
Oracle Spatial Option
enhancements, 322, 328
Multimedia and, 324
object types, 329
Oracle SQL Developer, 29
Oracle Standard Edition, 7
Oracle Standard Edition One, 7
Oracle Streams, 19
Oracle Technology Network (OTN), 357
Oracle Text, supported formats, 325
Oracle Type Translator (OTT), 321
Oracle Universal Installer, 56
Oracle Wallets, 148
Oracle Wireless, 16
Oracle Worldwide Customer Support
Services, 137
ORACLE_HOME environment variables, 58
Oracle7, 110
Oracle8
ANALYZE command, 112
cost-based optimization, 111
datatypes, user-defined, 87
extensibility options, 12
large pool, 76
NOLOGGING keyword, 42
Partitioning option, 96
PITR, tablespace level, 280
TAF (Transparent Application
Failover), 272, 274
triggers, PL/SQL, 108
Oracle8i, 8
AQ enhancements, publish-and-subscribe
capabilities, 315
checkpoint frequency variance, 260
deferred rollback, enhancements, 261
DRM (Database Resource Manager), 214
function-based indexes, 95
Java, 10, 56
JServer, 323
materialized views, 91
Objects and Extensibility features, 319
OLTP enhancements, 206
redo log archiving, 284
TAF (Transparent Application Failover)
enhancements, 273
transportable tablespaces, 18
triggers, Java, 108
Oracle9i
AnyType datatype, 88
AQ
enhancements, 313
XML support, 19
CREATE TABLE.
Pages:
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779