oracleskill

The /*+result_cache*/ SQL hint      
      This suggests that the result data will be cached in the data buffers, and not the intermediate data blocks that were accessed to obtain the query results. You can cache both SQL and PL/SQL results for super-fast subsequent retrieval.     
            
      XML SQL queries     
      Oracle11g will support query mechanisms for XML including XQuery and SQL XML, emerging standards for querying XML data stored inside tables.     
            
      SQL Replay     
      Similar to the previous feature, but this only captures and applies the SQL workload, not total workload
      Improved optimizer statistics collection speed      
      Oracle 11g has improved the dbms_stats performance, allowing for an order of magnitude faster CBO statistics creation     
            
      SQL execution Plan Management     
      Oracle 11g SQL will allow you to fix execution plans (explain plan) for specific statements, regardless of statistics or database version changes.     
            
      Dynamic SQL     
      DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations     
            
      Fully Automatic SQL Tuning     
      The 10g automatic tuning advisor makes tuning suggestions in the form of SQL profiles that will improve performance. You can tell 11g to automatically apply SQL profiles for statements where the suggested profile give 3-times better performance that the existing statement. The performance comparisons are done by a new administrative task during a user-specified maintenance window.     
            
      Improved SQL Access Advisor     
      The 11g SQL Access Advisor gives partitioning advice, including advice on the new interval partitioning. Interval partitioning is an automated version of range partitioning, where new equally-sized partitions are automatically created when needed. Both range and interval partitions can exist for a single table, and range partitioned tables can be converted to interval partitioned tables.
    
            
      RELATE LINK :     
      Oracle 11g PL/SQL new features
Oracle 11g programming support new features
Oracle 11g DBA new features
Oracle 11g High Availability & RAC new features
Oracle 11g OEM Enterprise Manager new features
Oracle 11g Performance tuning optimization new features
Oracle 11g security & auditing new features