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
Hongfeng Sun
01 Dec 2009 20:43
| 
Tags: Oracle-Availability
| 
Comments (2)
| 
Report a problem
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
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.