ISBN 978-0-9797951-0-7 0-9797951-0-9 Library of Congress Number: 2008936207 480pages Perfect Bind 9x7 PD 908 Shelving: Databases/Oracle Oracle In-Focus Series # 30

Oracle 11g New Features Get started fast with Oracle11g enhancements John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, Brian Carr Retail Price $39.95 / £34.95 Key Features About the Authors Table of Contents Index Reader Comments Errata - Order now and get 30% off the retail price! Only $28.95

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.

The Premier Book of Oracle 11g New 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 Authors:

Lutz Hartmann	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	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	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 is currently pursuing a Master's degree.

John Garmany

John Garmany is a Senior Oracle DBA with Burleson Consulting. A graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point. A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and SearchOracle and SELECT Magazine. John is also the author of four bestselling Oracle books by Rampant TechPress, Oracle Press and CRC Press and hosts a popular Oracle Application Server Newsletter.

Steve Karam

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.

John Garmany
Steve Karam
V. J. Jain
Lutz Hartmann
Brian Carr

CHAPTER 1 - Overview of 11g New Features Improved 11g management Repository enhancements Advanced 11g advisors CHAPTER 2 - Oracle 11g DBA new features Interval partitioning for tables New load balancing utilities Web server load balancing Listener Load Balancing New table Data Type "simple_integer" Improved table/index compression Faster DML triggers Improved NFS data file management Server side connection pooling Scalability Enhancements Scalable execution Virtual 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 balancing Oracle 11g RAC parallel upgrades Oracle RAC load balancing advisor ADDM for RAC Optimized RAC cache fusion protocols Oracle 11g RAC Grid provisioning Hot patching Standby snapshot Quick Fault Resolution CHAPTER 4 - OEM Oracle 11g new features: Interfaces to Applications OEM Easy de-install Database repair wizard Better OEM Grid tools CHAPTER 5 - Oracle 11g language & PL/SQL New Features PHP - Improved PHP driver for Oracle. PL/SQL "continue" keyword Disabled state for PL/SQL Improved native Java & PL/SQL compilers. Easy PL/SQL compiling Oracle 11g XML Enhancements Improved PL/SQL stored procedure invalidation mechanism Scalable PL/SQL and Java Improved sequence management Intra-unit inlining Enhanced PL/SQL warnings Named notation CHAPTER 6 - Oracle 11g SQL New Features The /*+result_cache*/ SQL hint XML SQL queries SQL Replay Improved optimizer statistics collection speed SQL execution Plan Management Dynamic SQL Fully Automatic SQL Tuning Improved 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 Tuning Resource Manager ADDM for RAC Faster sorting AWR Baselines Adaptive Metric Baselines CHAPTER 8 - Oracle 11g security & auditing new features Database Replay Secure Passwords Auditing Defaults in 11g Database Administrator Security Setup Transparent Data Encryption (TDE) enhancements TDE and Logminer Encrypted Tablespaces Encrypted LOB columns using Oracle SecureFiles Hardware 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 BACKUP Tracking transactional changes on tables over its lifetime by using FLASHBACK DATA ARCHIVE The technology behind it Enabling Flashback Data Archive Viewing Flashback Data Archive Information DDL limitations for Flashback Data Archive Flashing back transactions: using DBMS_FLASHBACK using 11g OEM for flashback transaction CHAPTER 12 - Oracle 11g ASM enhancements ASM Fast Mirror Resync ASM Preferred Mirror Read ASM Performance Enhancements ASM Disk Group Checks enhanced ASMCMD new features SYSASM role in 11g

Index Topics: Reviews: Errata: