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 has a Master of Business Administration degree.

John Garmany

John Garmany has been working as an Oracle DBA since 2002.

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.

 

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  About the Authors   John Garmany         Steve Karam Lutz Hartmann         V.J. Jain         Brian Carr

Index Topics: _ _asm_ausize    _asm_stripesize           _newsort_enabled       _recyclebin      A accept_sql_profiles     Access Advisor           Access Control Lists   add_filter        Advanced Replication Advanced Security Network Encryption Option       Advanced Security Option     alert.logs          allowed_logon_versions         alter_param     alter_sql_plan_baseline           ambr_backup_intermediate_file         analyze_current_performance apply_captured_compilenv     apply_set         apply_unset     ARCH transport         asm_preferred_read_failure_groups   asmcmd           au_size            aud$    Audit Vault     audit_trail        Automatic Segment Space Management        Automatic Shared Memory Management       Automatic Storage Management        B background_dump_dest basic_filter Benchmark Factory Binary XML BINARY_DOUBLE BINARY_FLOAT bloom filtering buffer_gets      C cancel_analysis_task chained blocks Class of Secure Transports client_result_cache_lag client_result_cache_size client_result_cache_stats$ Clone Database clone.pl cloning cluster interconnect Cluster Synchronization Service daemon cluster_database clustered tables comparison_metric compatible compensating transaction composite partitioning compound trigger configure_pool connect_time_scale connection broker Connection Load Balancing connection pooling Content Repository API core_dump_dest cost-based optimizer            cp cpu_count cpu_time create_analysis_task create_job create_sqlset create_virtual_catalog ctx_user_index_errors Cube Organized Materialized Views    CURRVAL D Dark Fiber data pump Database Configuration Assistant Database Control Database Resident Connection Pooling days_to_expire db_block_size db_cache_size db_file_multiblock_read_count db_recovery_file_dest db_recovery_file_dest_size db_securefile dba_advisor dba_advisor_executions dba_blockers dba_cpool_info dba_free_space dba_hist_sql_plan dba_hist_sqlstat dba_indexes dba_network_acls dba_part_tables dba_segments dba_sql_plan_baselines dba_streams_tp_component dba_streams_tp_component_link dba_streams_tp_component_stat dba_streams_tp_database dba_streams_tp_path_bottleneck dba_streams_tp_path_stat dba_tab_partitions dba_tables dba_user_network_acl_privileges dba_users dba_users_with_defpwd dba_waiters dba_workload_captures dba_workload_filters dba{user}_advisor_executions            dba{user}_advisor_findings dba{user}_advisor_sqlplans dba{user}_advisor_sqlstats dba{user}_advisor_tasks DBCA DBConsole dbms_addm.analyze_partial dbms_addm.get_report dbms_auto_task_admin dbms_connection_pool dbms_file_transfer dbms_flashback    dbms_logstdby      dbms_network_acl_admin dbms_network_acl_utility     dbms_rcvcat          dbms_repair           dbms_result_cache               dbms_scheduler    dbms_space          dbms_spm             dbms_sqlpa           dbms_sqltune        dbms_stats             dbms_streams_tablespace_adm dbms_workload_capture      dbms_workload_replay        dbms_workload_repository dbms_xplan           deadly embrace     default_action        default_execution_type         delete_filter            denial of service attacks diagnostic_dest    Direct NFS Client   direct_writes          disaster recovery disk_reads             disk_repair_time    display_sql_plan_baseline  drop_analysis_task                  E elapsed_time enable_at_time encryption encryption_algorithm encryption_mode encryption_password encryption_wallen_location evolve_sql_plan_baseline excution_type        execute_analysis_task execution plan       execution_days_to_expire execution_name1  execution_name2 expdp     explain_plan          F fal_client fal_server               Fast Connection Failover Fined Grained Auditing flashback data archiver        flashback query     flashback transaction           flashback transaction query flashback versions query     flashback_retention_target   flashback_transaction_query               flush        G gather_workload_stats global cache hot blocks Grid Control          gv$asm_disk         H Hangman Utility     Hardware Security Module hash_area_size Health Monitor       hosts      I identification key logging ignorecase             ILM Assistant         impdp     inactivity_timeout  Incident Package Service     Incident Packaging System incremental            incrsize   Index Organized Tables       Information Lifecycle Management     inlining   interrupt_analysis_task        interrupt_anaylsis_task        Interval Partitioning              invalidate               invalidate_object   invisible indexes   Invisible indexes L ldap_directory_access ldap_directory_sysauth        list-hash list-list     list-range                local_time_limit      Log Writer              log_archive_dest_1              log_archive_dest_10            log_archive_dest_n  Logical Standby Database   Logminer                LogMiner                lost writes               lsdsk       M max_lifetime_session           max_think_time     max_use_session maxconn_cbrok    Maximum Availability Architecture       maxsize  md_backup            md_restore             memory_max_target              memory_report      memory_target       minsize   N NetCA     NEXTVAL                no_restart_mode   num_cbrok             numtxns O oci_result_cache_max_rset_rows       oci_result_cache_max_rset_size         oci_result_cache_max_size OEM Text Manager               ONLINE REDEFINITION       optimizer_capture_sql_plan_baselines              optimizer_cost       optimizer_features_enable    optimizer_index_caching     optimizer_index_cost_adj    optimizer_mode     optimizer_use_sql_plan_baselines     options   ORA-24247             ORA-28334             Oracle Call Interface             Oracle Cluster Registry        Oracle Enterprise Manager Database Control   Oracle Notification Service  Oracle Secure Backup          Oracle Text            Oracle Universal Installer     oranfstab                P parallel_automatic_tuning    partition key           partition pruning   partitioning key     password_versions              pga_aggregate_target          plan_filter               planning downtime               PLS_INTEGER       plsql_optimizer_level            PRAGMA INLINE    pre_11g_enable_capture      preupdate.sh         primary connection nodes  principal privilege publish   R range partitioning range-hash            range-list                range-range           rank_measure1      rank_measure2      rank_measure3      recovery_catalog_owner      recyclebin              reference partitioning           Reference partitioning          referential constraint             regexp_count        regexp_instr          regexp_like            regexp_replace     regexp_substr        remap     report_analysis_task            reset_analysis_task              result_cache          result_cache_max_result result_cache_max_size         result_cache_mode result_cache_remote_expiration resume_analysis_task          resume_filter          Row Level Security                rvwr         S sec_case_sensitive_login    sec_max_failed_login_attempts sec_protocol_error_further_action sec_protocol_error_trace_action        sec_return_server_release_banner     SecureFiles            session_cached_cursors     set_analysis_default_parameter set_analysis_task_parameter               set_table_prefs      sga_max_size        sga_target              shared_pool_size SIMPLE_DOUBLE  SIMPLE_FLOAT     SIMPLE_INTEGER sort_area_size       spfile       SQL Performance Analyzer  SQL Plan History SQL Tuning Set     sql_impact_threshold sql_limit  sql_percentage     sqlnet     srvctl       stale_percent         status      Stored Outlines     subexpression parameter     subquery pruning  supertypes             supplemental logging          Swingbench           synchronization    sys.user$                sys.xid_array         sys_auto_sql_tuning_task   System Parameters                System partitioning               System Partitioning T Tablespace Migration Wizard test_execute           think_time_auto_correct       time_limit                Transaction Backout             transaction_backout             transcation_backout             transition point      Transparent Data Encryption              U undo_retention      undo_sql                use_db_recovery_file_dest  user_dump_dest    user_flashback_txn_state     user_tab_col_statistics utlpwdmg.sql V v$asm_attribute      v$asm_client          v$asm_disk            v$asm_disk_iostat                v$asm_file              v$cpool_cc_stats  v$cpool_stats        v$database             v$dnfs_channels  v$dnfs_files           v$dnfs_servers      v$dnfs_stats          v$encrypted_tablespaces    v$encryption_wallet              v$flashback_txn_graph        v$flashback_txn_mods         v$logmnr_contents               v$pwfile_users       v$result_cache_objects        v$session              verify_function       verify_function_11g              virtual column        Virtual Column-Based Partitioning      virtual columns      Virtual Private Database        Voting Disk            vpc_databases      W Wait Activity           Wait Class              wallet      wallet_location      workload_impact_threshold                Workspace Manager            X x$kfdat    x$kfdpartner          x$kffxpi   XQuery   Reviews: Errata: Reader Comments: I have since learned that unfortunately in Oracle11g (so far, at least) OEM Grid Control is quite different from OEM Database Control.  For some reason, in Grid Control, OEM is still at version 10.2.x.x.x, so it does not include the new OEM 11g features.  In Database Control (only) OEM is available in version 11, and includes the new features.  I understand that Oracle is working on getting OEM Grid Control in sync with what Database Control offers, but they aren’t there yet.  I can’t get dbconsole (for the Database Control) version of OEM to work on our new 11G servers, but I have a Service Request open with Oracle to address that. Mark Geerlings