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 5Database Security

Oracle has made numerous enhancements to Oracle Database 11g security. In fact, Oracle has taken security more seriously than ever. Starting with Oracle Database 11g, passwords are now case-sensitive, and the password algorithm has changed to Secure Hash Algorithm (SHA-1) instead of the Data Encryption Standard (DES)-based hash algorithm. There is a significant amount of out-of-the-box security improvements geared to providing a higher sense of security for corporate environments. Oracle Database 11g introduces the concept of tablespace-level encryption to attack the data-at-rest concerns while addressing performance and feasibility concerns. Oracle Database 11g can govern fine-grained network access from the database. ...