Oracle Database 11g
Top 10 New Feature for Oracle DBA

Home  

Oracle Database 11g TOP New Features Summary

Oracle Database 11g New Features Tips & Tricks

Upgrading 10g RAC to 11g RAC

• Week 1- ADR [Click Here for Detail]
  

  ADR - Automatic Diagnostic Repository [ Click here for pdf ]
  

  In Oracle 11g database New dimension fault diagnosability infrastructure added to Oracle self managing concept to reduce time for resolving problem/bug/SR and round trip between end-user and Oracle Support. Trace file, dump file , core file ADR, ADRCI etc are components of fault diagnosability infrastructure.
   
  

• Week2 Database Replay [Click  for Detail]
  

  “Simulating production load is not possible” , you might have heard these word.

  In one project, where last 2 year  management want to migrate from UNIX system to Linux system ( RAC ) , but they still testing because they are not sure where this Linux Boxes where bale to handle load or not. They have put lot of efforts and time in load testing and functional testing etc, but still not le gain confidence.

  After using these feature of 11g , they will gain confidence and will able to migrate to Linux with full confidence and will know how there system will behave after migration/upgrade. 

• Week 3 Automatic memory[Click Here]
  

  Oracle 9i. Automatic SGA tuning was introduced in Oracle 10g. In 11g, all memory can be tuned automatically by setting one parameter. You literally tell Oracle how much memory it has and it determines how much to use for PGA, SGA and OS Processes. Maximum and minimum thresholds can be set.
  

• Week 4 SQL Performance Analyzer(SPA) [Click Here] 

  [PDF]

  You can use SQL Performance Analyzer (SPA) to analyze the SQL performance impact of any type of system changes.

• Implementation of tuning recommendations ( like parameter changes )
• Schema changes (eg Application Patch ), Statistics gathering
• Database upgrades, OS/hardware changes
  
  SQL Performance Analyzer (SPA) Part 1
  
  SQL Performance Analyzer (SPA) Part 2
  
  

• Week 5  Statistics
  

  
  
  • Multi-columns statistics
  • Expression statistics
  • Statistics preferences

   

• Week 6 Partitioning

  Two New kind of partition introduce in 11g 

  • System Partition 
  • Interval Partition 
  •  
  There might more Feature apart from above  

• Week 7 Security New Features

  • Case Sensitive password
  • By Default many Security enabled
  • Encrypt tablespace 
  • ACL ( Access Control List) [ Click Here]
    

• Week 8 SQL Plan Manageability [Click Here PDF format]
  

• Week 9 Automatic SQL Tuning
  

• Week 10 ADDM For RAC [Click Here]
  

  External Links 

  Some Good Links / Blogs / site to know more about New Oracle Database 11g features
  Virag Sharma virag123@gmail.com
  
  

  I have rated 5 *(star) for some sites , which I like Most

  ( these links collected from google alert )
  

• Oracle Database Online Documentation 11g Release 1 (11.1) *****
• ORACLE-BASE - Articles on Oracle 11g new features *****
• Oracle Database 11g on OTN
• Oracle Database 11g: The Top Features for DBAs and Developers
• Pythian Group Blog » Tuning Pack 11g : Real-Time SQL Monitoring
• PSOUG - New in 11gR1*****
• Robert G. Freeman’s Blog: 11g Security New Feature… A short one…
• Oracle 11g new Features Summary by Burleson
• My top 10 Oracle 11g New Features Part 3 - 5 nice optimizer statistics
• Oracle 11g Top New Features for DBA Virag Sharma
• Oracle Magazine: PL/SQL Practices: On the PL/SQL Function Result Cache
• Changes in Oracle 11.1 - Julian Dyke *****
• Blogging about 11g - Part 7 - Function Result Cache
• Oracle 11g New Features SQL plan management (SPM)
• Oracle 11g New feaures : Case Sensitive Password
• SQL Performance Analyzer (SPA) Part - 2
• Oracle 11g ADR Automatic Diagnostic Repository
• New Parameters in 11g (Part 2) | Dizwell Informatics
• Oracle 11g DRCP: Database Resident Connection Pooling - second attempt
• Oracle 11g internals part 1: Automatic Memory Management
  
  

Some more link you can find of following links 

 40+ Links for Knowing the New Oracle Database 11g.