Oracle has introduced Oracle Database 11g, which claims to enable organisations take control of their enterprise information, gain better business insight, and adapt to an increasingly changing competitive environment.

The new release extends Oracle’s database clustering, data centre automation, and workload management capabilities and claims to tackle transaction processing, data warehousing, and content management applications.

Oracle Database 11g includes advanced self-management and automation to help organisations meet service level agreements. It features new data partitioning and compression capabilities, for cost-effective Information Lifecycle Management and storage management.

It also features Oracle Flashback Transaction which makes it easy to back out a transaction made in error, as well as any dependent transactions; Parallel Backup and Restore which helps improve the backup and restore performance of very large databases; and ‘hot patching,’ which improves system availability by allowing database patches to be applied without the need to shut databases down.

New manageability capabilities in Oracle Database 11g include Automatic SQL and memory tuning, a new Partitioning Advisor which automatically advises administrators on how to partition tables and indexes in order to improve performance, and enhanced performance diagnostics for database clusters.