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