Oracle 11g New Features book

I am writing some chapters in a book on Oracle 11g New Features.
It is planned to be published at the beginnig of next year.

See more details on the book here!

We are a team of four authors working on it. The others are:
- John Garmany, Steve Karam, and V.J. Jain

Table of Contents:

John Garmany

Steve Karam

V.J. Jain

Lutz Hartmann

CHAPTER 1 – Overview of 11g New Features Improved 11g managementRepository enhancements Advanced 11g advisors CHAPTER 2 – Oracle 11g DBA new features Interval partitioning for tablesNew load balancing utilitiesWeb server load balancingListener Load Balancing New table Data Type “simple_integer”Improved table/index compressionFaster DML triggersImproved NFS data file managementServer side connection poolingScalability EnhancementsScalable executionVirtual columns “super” object-oriented DDL keyword Oracle 11g XML data storage New Trigger features Partitioning by logical object and automated partition creation. New high-performance LOB features. Incident Packaging Service (IPS) Feature Based Patching Enhanced Read only tables Table trigger firing order CHAPTER 3 – Oracle11g High Availability & RAC new features RAC instance load balancingOracle 11g RAC parallel upgradesOracle RAC load balancing advisorADDM for RACOptimized RAC cache fusion protocolsOracle 11g RAC Grid provisioningHot patchingStandby snapshot Quick Fault Resolution CHAPTER 4 – OEM Oracle 11g new features: Interfaces to ApplicationsOEM Easy de-installDatabase repair wizardBetter OEM Grid tools CHAPTER 5 – Oracle 11g language & PL/SQL New Features PHP – Improved PHP driver for Oracle.PL/SQL “continue” keywordDisabled state for PL/SQLImproved native Java & PL/SQL compilers.Easy PL/SQL compilingOracle 11g XML EnhancementsImproved PL/SQL stored procedure invalidation mechanismScalable PL/SQL and Java Improved sequence management Intra-unit inliningEnhanced PL/SQL warningsNamed notation CHAPTER 6 – Oracle 11g SQL New Features The /*+result_cache*/ SQL hintXML SQL queriesSQL ReplayImproved optimizer statistics collection speedSQL execution Plan ManagementDynamic SQLFully Automatic SQL TuningImproved SQL Access Advisor

CHAPTER 7 – Oracle 11g Performance Tuning new features: 11g SQL Performance Analyzer (SPA) 11g Multi-column hybrid histograms CBO correlating statistics New Oracle11g Advisors Automatic Diagnostic Repository (ADR)Automatic Memory TuningResource ManagerADDM for RACFaster sortingAWR BaselinesAdaptive Metric Baselines CHAPTER 8 – Oracle 11g security & auditing new features Database Replay Secure PasswordsAuditing Defaults in 11gDatabase Administrator Security SetupTransparent Data Encryption (TDE) enhancementsTDE and LogminerEncrypted TablespacesEncrypted LOB columns using Oracle SecureFilesHardware Secure Module versus Oracle Wallet TDE and Logical Standby Database FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP EM new Security Features Policy Manager Label Security Administration in EM Enterprise Users Administration VPD configuration Application Contexts configuration CHAPTER 9 – Oracle 11g Streams, replication and Data Guard enhancements Data Guard Load Balancing Data Guard supports “Flashback Standby”. CHAPTER 10 Oracle 11g Change Management RAT – Real Application Testing - SQL Performance Analyzer (SQL Replay)- SQL Plan Manageability (SQL Plan baselines)- Database replay - The technology behind it- capture workload- replay workload on test system- analyze replay (compare periods)- Using EM for replay database CHAPTER 11 – 11g Flashback New Features What’s new about UNDO and transactions in 11g?Optimized UNDO BACKUPTracking transactional changes on tables over its lifetime by using FLASHBACK DATA ARCHIVEThe technology behind itEnabling Flashback Data ArchiveViewing Flashback Data Archive InformationDDL limitations for Flashback Data ArchiveFlashing back transactions: using DBMS_FLASHBACK using 11g OEM for flashback transaction CHAPTER 12 – Oracle 11g ASM enhancements ASM Fast Mirror ResyncASM Preferred Mirror ReadASM Performance EnhancementsASM Disk Group Checks enhancedASMCMD new featuresSYSASM role in 11g