Search and Find
Service
Oracle Database 11g - New Features for DBAs and Developers
of: Sam Alapati, Charles Kim
Apress, 2008
ISBN: 9781430204695 , 602 Pages
Format: PDF, Read online
Copy protection: DRM
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
All prices incl. VAT