book

Oracle Database 11g: New Features for DBAs and Developers

by Sam R. Alapati, Charles Kim

November 2007

Intermediate to advanced

630 pages

17h 38m

English

Apress

Read now

Unlock full access

Change ManagementEnhanced Database AutomationPerformance ManagementEnhanced Fault Diagnosis CapabilityData Guard EnhancementsStorage Management ImprovementsGeneral Database ManagementEnhanced SecurityApplication ImprovementsPartitioning New FeaturesHigh-Availability EnhancementsAdvanced Compression
New Features in Server InstallationInstalling Oracle Database 11gNew Features in Database CreationUpgrading to Oracle Database 11gReal Application TestingDatabase Software Patching
The Fault Diagnosability InfrastructureInvestigating and Resolving ProblemsDatabase Health ChecksData Recovery AdvisorImprovements in Handling Data Corruption
Database AutomationFlashback-Related New FeaturesDatabase Administration New FeaturesSQL*Plus New FeaturesOnline Application MaintenanceOracle Advanced Table Compression OptionEnterprise Manager New FeaturesOracle Scheduler New Features

SQL and PL/SQL Performance EnhancementsNew Result Caching FunctionalityAutomatic SQL TuningOptimizer and Statistics Collection EnhancementsPerformance-Related Changes in Database Control
Enterprise Database Security ConcernsTablespace EncryptionEnterprise Manager IntegrationUTL_ Package Network Access ManagementOracle Advanced Security FeaturesOracle Call Interface Enhancements
Enhanced Block Media RecoveryRMAN Management EnhancementsActive (Network-Based) Database DuplicationRecovery Catalog ManagementEnhanced RMAN Integration with Data Guard
API EnhancementsCompression EnhancementsEncryptionReusing a Dump FileRemapping DataRemapping a TableExport and Import of PartitionsIgnoring ErrorsExternal Tables Based on Data Pump
Synchronous CaptureCombined Capture and ApplyPerformance AdvisorStreams TopologyDBMS_COMPARISON for "Compare and Repair"Splitting and Merging of a DestinationUsability Improvements
Automated Storage ManagementASM UpgradeASM Preferred Readsasmcmd CommandsMetadata Backup and RestoreOracle Direct NFS
Active Physical Standby Database DuplicationReal-Time Query StandbySnapshot StandbyUsing the Physical Standby for Rolling UpgradesLogical Standby: SQL ApplyData Guard Broker
New PL/SQL FeaturesNew Trigger FeaturesXML DB ImprovementsApplication Express (APEX) EnhancementsPHP Support EnhancementsJava Enhancements
Next-Generation LOBsData Warehousing New FeaturesPartitioningOracle Multimedia

Overview

Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation's flagship database product.

Learn what's new in Oracle that really counts
See actual examples and test run output
Make sound decisions on new feature adoption

Sift the gold from the silt and discover which new features of the latest release of Oracle's flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real-world to help you get the most out of Oracle Database 11g.