July 13, 2007

11G features

For DBA

  • Incident packaging service: automatically pack all diagnosistic data into zip file. Raise a service request is easy
  • Autmatica Diagnostic repository replaces all XX_DUMP_DEST directories
  • Flashback Data ARchive can keep UNDO data as long as required
  • 112g network-based duplication will duplicate source db to clone dbwithout requiring source db to have existing backups.
  • Data recovery advisor will identify which recovery option is feasible

For Developer

  • Create index as Invisible attribute cause CBO to ginore the presence of the index
  • Add a column with a defult value to a table with many rows could take a significant amount of time and holad a lock on the table. This restriction has been removed
  • SecureFiles : store/read files into db, performance is 10X fater than LOB and has silmilar speed as Linux NFS

- One comment Not publicly viewable

  1. Chris May

    add a column with a defult value to a table with many rows could take a significant amount of time and hold a lock on the table. This restriction has been removed

    Hurrah! That will be a huge win for apps (like Sitebuilder) with continuously evolving schemas and no downtime windows.

    13 Jul 2007, 13:15


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
© MMXXI