Monday, July 16, 2007

Oracle 11G - OLTP Table Compression

Oracle 11G introduces a new option to support compression of various structured, unstructured and other backup data. This option named Oracle Advanced Compression option provides multiple features including ( this feature extends the basic table compression that was available since 9i ) , Secure File Deduplication, RMAN Compression and Data Pump Compression.

Technorati : , , ,

Sunday, July 15, 2007

Oracle 11G New Features - SQL Performance Analyzer

Database Administrators spend countless hours troubleshooting SQL statements that have taken upon a new life after a simple system or environment change. Oracle 11G SQL Performance Analyzer provides a solution to this never ending regressive statement issues. This new feature of Oracle 11G allows the database administrator to get a granular view of the impact to sql execution plans and statistics due to environment changes and the best part is that it completely automates the impact analysis process of extremely large SQL workloads