3 Review(s)

Oracle 11g grid database is the next incarnation of Oracle's flagship database management system, noted as the world's most flexible and robust data storage platform. Many of the Oracle11g new features are intended to automate the inherent complexity of the Oracle engine, and this book on Oracle 11g new features explores all of the new features from the perspective of a working Oracle professional. Unlike other 11g new features book that list all new features regardless of value, this Oracle 11g new features book shows only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Oracle 11g has over 500 new features and this comprehensive Oracle11g new features book explores those enhancements most useful to Oracle users: 11g SQL new features 11g language & PL/SQL new features 11g DBA features 11g RAC new features & enhancements 11g performance features 11g security new features 11g Enterprise Manager (OEM) new features This is the flagship book on Oracle11g new features written by working Oracle experts with many years of real-world experience.  This book is the indispensable reference for Oracle 11g new features for both DBA's and Oracle developers and programmers. Key Features See Oracle11g SQL new features Understand Oracle 11g language & PL/SQL new features Learn the Oracle 11g DBA new features See the Oracle 11g RAC new features & enhancements Examine 11g new high-performance features Learn 11g security new features Use 11g OEM new features About The Author Lutz Hartmann is a senior instructor specializing in Oracle trainings for DBAs and developers. Lutz has been an Oracle employee for more than 6 years. After leaving Oracle Corporation Lutz has raised his own company sysdba database consulting GmbH in Switzerland which provides advanced Oracle consulting and support services as well as custom courses for DBAs and developers. Lutz was one of the first trainers worldwide to deliver 11g New Features courses for Oracle University and Oracle Support Services.  He has delivered Oracle trainings in more than 10 countries and three continents. Lutz has published a great number of articles on Oracle new features in American, Swiss and German tech magazines and speaks at Oracle User Group meetings from time to time. His blog http://sysdba.wordpress.com is well recognized in the Oracle community and registers more than 100,000 hits per year. For his outstanding contributions to the oracle communities he was awarded ORACLE ACE in 2006. V. J. Jain is an Oracle Database and Applications consultant with over 12 years of experience in database and ERP systems. He specializes in database performance, development, interfaces and high-performance solutions. V.J. actively evaluates Oracle's newest technologies and is a member of the Oracle Partner Network and Beta program. He has published articles on SearchOracle, OraFaq, OTN and is the owner of www.oracle-developer.com. V.J. received his B.S. in Information and Computer Science from the University of California Irvine and is a veteran of the U.S. Army National Guard who was in military intelligence and held a TS/SCI security clearance. V.J. is the owner of Varun Jain, Inc., a Southern California based consulting firm. Brian Carr works as a Senior Oracle DBA and is an Oracle Certified Professional and Oracle ACE. His articles have appeared in SELECT Journal, OTN, Database Trends and Applications, JavaWorld, and DevX. He co-wrote a multithreaded Web crawler and search engine in Perl, as well as an anonymous web browsing service in C#. Brian also wrote a server monitoring solution that has been commercially released.  Brian has a Master of Business Administration degree. John Garmany has been working as an Oracle DBA since 2002. Steve Karam is one of the few DBAs worldwide to achieve both the Oracle 10g Certified Master certification and the Oracle ACE designation, both of which he received before the age of 26.  As both a production DBA and an instructor, he has a proven track record in performance and troubleshooting on dozens of high profile Oracle systems including complex RAC environments. Additionally, Steve has been developing against Oracle databases for over twelve years on a variety of platforms including C, C++, Java, PHP, and Application Express. Steve is also involved heavily in the Oracle community as the President of the Hampton Roads Oracle Users Group, Web Chair for the IOUG RAC SIG, and judge for the yearly Oracle Academy educational competition. Table of Contents Using the Online Code Depot Conventions Used in this Book   Acknowledgements Credits Chapter 1: Introduction to 11g New Features Inside 11g New Features  Oracle 11g DBA New Features Oracle 11g High Availability & RAC new features OEM - Enterprise Manager Oracle 11g new features Oracle 11g New Features Programming Language Support Oracle 11g PL/SQL New Features          Oracle SQL optimizer (CBO) Improvements       Oracle 11g SQL New Features    11g Performance Tuning Optimization New Features Oracle 11g Security & Auditing New Features  Oracle 11g New RMAN Features HTML-DB 11g Enhancements     Oracle 11g Business Intelligence & OLAP        Oracle 11g data mining     Conclusion  Chapter 2: 11g New DBA Features 11g for the DBA      Partitioning Enhancements          Interval Partitioning System Partitioning Reference Partitioning      Virtual Column-Based Partitioning         Composite Partitioning Enhancements Enhanced Partition Pruning Capabilities          Enhanced Information Lifecycle Management The Oracle 11g ILM Assistant       New Index Features           Invisible indexes     Improved table compression         Improved NFS Performance/Management        Database Resident Connection Pooling           Oracle Call Interface (OCI) Consistent Client Cache   Virtual columns       Oracle 11g Binary XML data storage       Incident Packaging Service          Enhanced Read-only tables         Faster DML triggers Conclusion  Chapter 3: High Availability and RAC New Features Background of Oracle RAC          Scalability     Automatic Workload Repository   Services        Putting Load Balancing into Action        Cloning a Cluster to another Cluster      Scalability Conclusion       Cluster Performance          ADDM for RAC        High Availability      Clusterware Rolling Upgrades     ASM Rolling Upgrades      Conclusion  Chapter 4: OEM Oracle 11g new features Introduction to OEM           Improved Database Home Page and Performance changes  Integrated Interface for LogMiner Advanced Replication Interface   Wait Activity Detail Enhancement           Easy Oracle Text Management    Better OEM Grid Tools       Clone Database Enhancements Migrate Database (and more!) to ASM    Workspace Manager          Find Referential Integrity Constraints     Compress a Workspace     Manage System Parameters         Privilege Management       Conclusion  Chapter 5: Oracle 11g PL/SQL New Features 11g PL/SQL New Features           PL/SQL Sequence Access           SIMPLE Number Types     The CONTINUE Statement           PL/SQL Subprogram Inlining       PL/SQL Compound Triggers        PL/SQL Trigger Enhancements   Cross-Session PL/SQL Function Result Cache           Conclusion  Chapter 6: Oracle 11g SQL New Features 11g SQL       SQL PIVOT and UNPIVOT Operators     Regular Expressions Enhancements     regexp_instr regexp_substr          regexp_count          Result Cache Hint  HASH OUTER JOINS        Conclusion  Chapter 7: 11g Performance Tuning Features New Performance Tuning Features        A trip to the SPA – Inside the 11g SQL Performance Analyzer          Decision Support and Expert Systems Technology     Inside the Oracle 11g SQL Performance Analyzer       A trip to the SPA      Comparing the SPA Results        Extended Optimizer Statistics       Inside Extended Optimizer Statistics       Automatic Diagnostic Repository Conclusion  Chapter 8: Oracle 11g Security Enhancements New Password Security Features           Enhances hashing algorithm       Passwords with symbols in 11g   Case sensitive passwords Case sensitive passwords and database upgrade to 11g       How to enable the Oracle 11g EXCLUSIVE MODE     Enforcing complex passwords     How to find accounts with default passwords in 11g   Other Hacking Prevention Features       Auditing by DEFAULT in 11g       Strong Authentication for SYSDBA and SYSOPER in 11g   Limiting Access to External Networking Services         How to create and manage ACLs with PL/SQL How to create and manage ACLs with OEM     Other network security features   Transparent Data Encryption Features in 11g  External Master Key Storage using Hardware Security Module        TDE with Logminer and Logical Standby Database    TDE with Export Data Pump         Transparent Tablespace Encryption       TDE with Enterprise Manager      Intelligent LOB Encryption with Secure File LOBs       Securefile Lobs at work     Securefile Lobs at work with OEM           Virtual Private Catalogues for RMAN     Other security aspects about backup in 11g      Conclusion Chapter 9: 11g New Features Streams and Data Guard Data Guard  Physical Standby + Real-Time Query     Snapshot Standby  Creation of Standby Database     Dynamic Setting of Oracle Data Guard SQL Apply Parameters         Streams        Streams Performance        Streams Topology   Materialized Views Conclusion  Chapter 10: Oracle 11g Change Management RAT - Real Application Testing    Testing with a snapshot standby database        SQL Performance Analyzer (SPA)          SQL Performance Analyzer using PL/SQL        SQL Performance Analyzer using OEM Database Replay    Database replay using the command line         Preparing the system for capture Capturing the workload     How to capture a workload in a 10g database for replay in an 11g database (patchset 10.2.0.4)           Preparing the testing system for workload replay         Workload replay and analysis on the testing system   Database replay in the GUI           Conclusion  Chapter 11: SQL Management SQL Plan Management with SQL Plan Baselines       How Automatic SQL Plan Management works Use cases for Automatic SQL Plan Management        SQL Plan Management in OEM  How Manual SQL Plan Loading works  Integration of SQL Plan Management with Automatic SQL Tuning  Conclusion  Chapter 12: Oracle 11g Flashback A brief history of FLASHBACK functionalities  TRANSACTION BACKOUT in Oracle 11g         Transaction backout without OEM using PL/SQL        Transaction backout with OEM    Oracle Total Recall The Technology Behind It Enabling Flashback Data Archive           What is in the Flashback Data Archive? DDL limitations for Flashback Data Archive What’s new about UNDO and transactions in 11g? Optimized UNDO BACKUP with RMAN Conclusion Chapter 13: Oracle 11g ASM Enhancements ASM Security Enhancements SYSASM role in 11g UPGRADING ASM to 11g ASM disk group attributes Resetting the CSSd ASM Rolling Upgrade ASM Fast Mirror Resync ASM Performance Enhancements Variable size of Allocation Units ASM Fast Rebalance Stretched ASM cluster configuration with ASM Preferred Mirror Read in 11g ASMCMD new features Automatic and manual ASM disk repair in 11g ASM Disk Group Checks Enhanced ASM metadata Conclusion Index