Alapati / Kim Oracle Database 11g

New Features for DBAs and Developers
1. ed
ISBN: 978-1-4302-0469-5
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 602 Seiten

This brilliant new book gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on 'what's new that really matters.' Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.

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.

Autoren/Hrsg.

Alapati, Sam

Kim, Charles

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Authors;17
4;Acknowledgments;18
5;Introduction;20
5.1;Change Management;20
5.2;Enhanced Database Automation;20
5.3;Performance Management;21
5.4;Enhanced Fault Diagnosis Capability;21
5.5;Data Guard Enhancements;21
5.6;Storage Management Improvements;22
5.7;General Database Management;22
5.8;Enhanced Security;23
5.9;Application Improvements;23
5.10;Partitioning New Features;24
5.11;High- Availability Enhancements;24
5.12;Advanced Compression;25
6;Installing, Upgrading, and Managing Change;26
6.1;New Features in Server Installation;27
6.2;Installing Oracle Database 11g;31
6.3;New Features in Database Creation;33
6.4;Upgrading to Oracle Database 11g;42
6.5;Real Application Testing;60
6.6;Database Software Patching;78
7;Database Diagnosability and Failure Repair;82
7.1;The Fault Diagnosability Infrastructure;83
7.2;Investigating and Resolving Problems;88
7.3;Database Health Checks;105
7.4;Data Recovery Advisor;113
7.5;Improvements in Handling Data Corruption;121
8;Database Administration;124
8.1;Database Automation;124
8.2;Flashback-Related New Features;135
8.3;Database Administration New Features;150
8.4;SQL* Plus New Features;172
8.5;Online Application Maintenance;175
8.6;Oracle Advanced Table Compression Option;178
8.7;Enterprise Manager New Features;181
8.8;Oracle Scheduler New Features;186
9;Performance Management;192
9.1;SQL and PL/ SQL Performance Enhancements;193
9.2;New Result Caching Functionality;200
9.3;Automatic SQL Tuning;215
9.4;Optimizer and Statistics Collection Enhancements;222
9.5;Performance- Related Changes in Database Control;247
10;Database Security;250
10.1;Enterprise Database Security Concerns;250
10.2;Tablespace Encryption;264
10.3;Enterprise Manager Integration;269
10.4;UTL_ Package Network Access Management;273
10.5;Oracle Advanced Security Features;285
10.6;Oracle Call Interface Enhancements;286
11;Backup and Recovery;290
11.1;Enhanced Block Media Recovery;290
11.2;RMAN Management Enhancements;295
11.3;Active ( Network- Based) Database Duplication;313
11.4;Recovery Catalog Management;324
11.5;Enhanced RMAN Integration with Data Guard;332
12;Data Pump;337
12.1;API Enhancements;337
12.2;Compression Enhancements;338
12.3;Encryption;343
12.4;Reusing a Dump File;346
12.5;Remapping Data;347
12.6;Remapping a Table;349
12.7;Export and Import of Partitions;350
12.8;Ignoring Errors;353
12.9;External Tables Based on Data Pump;353
13;Oracle Streams;360
13.1;Synchronous Capture;361
13.2;Combined Capture and Apply;365
13.3;Performance Advisor;367
13.4;Streams Topology;368
13.5;DBMS_ COMPARISON for “ Compare and Repair”;371
13.6;Splitting and Merging of a Destination;377
13.7;Usability Improvements;378
14;Storage Management;383
14.1;Automated Storage Management;383
14.2;ASM Upgrade;388
14.3;ASM Preferred Reads;396
14.4;asmcmd Commands;417
14.5;Metadata Backup and Restore;422
14.6;Oracle Direct NFS;432
15;Data Guard;436
15.1;Active Physical Standby Database Duplication;437
15.2;Real- Time Query Standby;439
15.3;Snapshot Standby;442
15.4;Using the Physical Standby for Rolling Upgrades;447
15.5;Logical Standby: SQL Apply;453
15.6;Data Guard Broker;458
16;Application Development;466
16.1;New PL/ SQL Features;466
16.2;New Trigger Features;490
16.3;XML DB Improvements;496
16.4;Application Express ( APEX) Enhancements;526
16.5;PHP Support Enhancements;528
16.6;Java Enhancements;529
17;Data Warehousing;535
17.1;Next-Generation LOBs;536
17.2;Data Warehousing New Features;547
17.3;Partitioning;558
17.4;Oracle Multimedia;581
18;Index;584