Oracle Database 11g (eBook)

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Contents at a Glance 5
Contents 6
About the Authors 17
Acknowledgments 18
Introduction 20
Change Management 20
Enhanced Database Automation 20
Performance Management 21
Enhanced Fault Diagnosis Capability 21
Data Guard Enhancements 21
Storage Management Improvements 22
General Database Management 22
Enhanced Security 23
Application Improvements 23
Partitioning New Features 24
High- Availability Enhancements 24
Advanced Compression 25
Installing, Upgrading, and Managing Change 26
New Features in Server Installation 27
Installing Oracle Database 11g 31
New Features in Database Creation 33
Upgrading to Oracle Database 11g 42
Real Application Testing 60
Database Software Patching 78
Database Diagnosability and Failure Repair 82
The Fault Diagnosability Infrastructure 83
Investigating and Resolving Problems 88
Database Health Checks 105
Data Recovery Advisor 113
Improvements in Handling Data Corruption 121
Database Administration 124
Database Automation 124
Flashback-Related New Features 135
Database Administration New Features 150
SQL* Plus New Features 172
Online Application Maintenance 175
Oracle Advanced Table Compression Option 178
Enterprise Manager New Features 181
Oracle Scheduler New Features 186
Performance Management 192
SQL and PL/ SQL Performance Enhancements 193
New Result Caching Functionality 200
Automatic SQL Tuning 215
Optimizer and Statistics Collection Enhancements 222
Performance- Related Changes in Database Control 247
Database Security 250
Enterprise Database Security Concerns 250
Tablespace Encryption 264
Enterprise Manager Integration 269
UTL_ Package Network Access Management 273
Oracle Advanced Security Features 285
Oracle Call Interface Enhancements 286
Backup and Recovery 290
Enhanced Block Media Recovery 290
RMAN Management Enhancements 295
Active ( Network- Based) Database Duplication 313
Recovery Catalog Management 324
Enhanced RMAN Integration with Data Guard 332
Data Pump 337
API Enhancements 337
Compression Enhancements 338
Encryption 343
Reusing a Dump File 346
Remapping Data 347
Remapping a Table 349
Export and Import of Partitions 350
Ignoring Errors 353
External Tables Based on Data Pump 353
Oracle Streams 360
Synchronous Capture 361
Combined Capture and Apply 365
Performance Advisor 367
Streams Topology 368
DBMS_ COMPARISON for “ Compare and Repair” 371
Splitting and Merging of a Destination 377
Usability Improvements 378
Storage Management 383
Automated Storage Management 383
ASM Upgrade 388
ASM Preferred Reads 396
asmcmd Commands 417
Metadata Backup and Restore 422
Oracle Direct NFS 432
Data Guard 436
Active Physical Standby Database Duplication 437
Real- Time Query Standby 439
Snapshot Standby 442
Using the Physical Standby for Rolling Upgrades 447
Logical Standby: SQL Apply 453
Data Guard Broker 458
Application Development 466
New PL/ SQL Features 466
New Trigger Features 490
XML DB Improvements 496
Application Express ( APEX) Enhancements 526
PHP Support Enhancements 528
Java Enhancements 529
Data Warehousing 535
Next-Generation LOBs 536
Data Warehousing New Features 547
Partitioning 558
Oracle Multimedia 581
Index 584