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 : Compression, New Features, OLTP, Oracle 11g

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

Oracle 11G - Database Replay

Database Replay a new feature of Oracle 11G provides DBAs and system administrators with the ability to accurately rerun actual production workloads, including online user and batch workloads, in test environments. By capturing the full database workload from production systems, including all concurrency, dependencies and timing, Database Replay enables you to realistically test system changes by essentially recreating production workloads on the test system -something that a set of scripts can never duplicate.

Technorati : New Feature, Oracle 11g, Real Application Testing

Oracle expansion in Hyderabad

Oracle and its salaries are expanding in Hyderabad Job Market at a very quick pace. During my recent trip to Hyderabad, I noticed that they have moved into their own campus and are continuing to lease a ton of office space in and around their campus. Hiring engines seem to be firing on all cylinders to meet the continued customer and consulting demand for offshore work.

ORA-03113 End of File

ORA-03113 seems to be an error that keeps haunting new dba's over and over again. Metalinks has tons of documentation on this error but a great place to start is on this ORA-03113 Error

Some of the regular readers have complained about ORA-12154 and here is a link to resolving the ORA-12154 error

ORA-00918 ate our weekend

A good explanation about solving the ORA-00918 issue.

Oracle is easier to manage than DB2

An interesting study by Edison Group that announced that oracle saves 38% in RDBMS Management cost over IBM DB2. Looks like this study is based on a study of the administrative tasks and the time it takes to complete those tasks. It claims that Oracle will save upto $30K+ in administrative costs...

More info can be found here and here