December 01, 2009

11g new features

Some new features might help developer:

1. Off load read to active data guard , set standby_max_data_delay = none. It throw exception if standby is not in sync with primary. SB can identify the exception and read data again from primary.

2. Flashback data archive can keep history data for weeks, months. Helpful audit_trail or editing history

3. Direct NFS

4. Make a table read only
5. Add a NOT NULL column with a default value much faster.

For DBA:

invisible index: Test drop index by making it invisible

bdump, cdump and udump is depreciated, but adump is kept.

color sql: let AWR caputre it even it not in top sql

rows are inserted uncompressed and in the routine way

alter index in_tab_01 rebuild online; No blocking at all


- 2 comments by 0 or more people Not publicly viewable

  1. lucy

    All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the database performance advisory framework like Undo Advisor, Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor, and the best of all Automatic Database Diagnostic Monitor (ADDM). Oracle Database 11g expands this advisory framework by introducing a new Database Repair Advisor. The main goal of this new Advisor is to locate root causes of a failure, identify and present options for repairing these root causes, and correct the identified problems with self-healing mechanisms.

    06 Mar 2010, 13:15

  2. shaane

    Oracle 11g is the clear leader in this area. Oracle has invested heavily into self-tuning capabilities including automated storage and memory management and intelligent tuning advisors.
    seo london

    15 Mar 2010, 10:57


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII