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 11Application Development

One of the focuses of this book is to expose major new Oracle Database 11g development features to the development community. This chapter dives deep into the new features of development in the areas of PL/SQL, Java, and XML support. Furthermore, this chapter briefly covers Application Express and PHP to describe what is available in Oracle Database 11g. The PL/SQL and Java portions of this chapter are dedicated to developers, with minor emphasis on DBAs. DBAs with previous development backgrounds can definitely enjoy this chapter, though. Also, DBAs who are aspiring developers can benefit from all the new Oracle Database 11g features offered to increase database productivity. Let's get started with a discussion ...