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 8Oracle Streams

With the technological advances in computers and the spread of the Internet, the need has grown to share information within the corporation throughout the disparate regions of the globe. The internationalization of products and the demand for readily available information create the increasing requirements for data replication. Of all the replication technologies available, Oracle Streams can provide a single enterprise solution for data sharing for Oracle databases. One key benefit that Oracle Streams provides is the ability to replicate data between different versions of Oracle. Unlike Oracle Logical Standby, Oracle Streams also allows you to replicate a database between different operating systems. In addition, architects ...