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

Content preview from Oracle Database 11g: New Features for DBAs and Developers

CHAPTER 4Performance Management

Oracle Database 11g adds several weapons to the arsenal of the DBA looking to improve performance and scalability. Automatic native compilation of PL/SQL code means you'll now get much faster PL/SQL performance automatically when you upgrade applications to the new release. The new server cache feature dramatically increases performance for SQL queries as well as for PL/SQL functions by retrieving results straight from the cache instead of reexecuting code. There is also a new client-side result caching feature for OCI applications.

The new SQL Plan Management (SPM) feature helps you stabilize SQL execution plans to prevent a performance regression due to unexpected changes in the execution plans of SQL statements. ...