Difference between Oracle 10g and Oracle 9i Databases

Oracle Database 10g is the first database designed for grid computing, the most flexible and cost-effective way to manage enterprise information. It cuts costs of management while providing the highest possible quality of service.

In addition to providing numerous quality and performance enhancements, Oracle Database 10g significantly reduces the costs of managing the IT environment, with a simplified install, greatly reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.

Oracle 9i Database provides efficient, reliable, secure data management for high-end applications such as high-volume on-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Oracle also offers several additional optional database products that enhance the capabilities of Oracle9i Database for specific application requirements.

Additional features in 10g over the 9i:

Transparent Data Encryption

Grid computing - an extension of the clustering feature (Real Application Clusters)

Manageability improvements (self-tuning features)

Performance and scalability improvements

Automated Storage Management (ASM)

Automatic Workload Repository (AWR)

Automatic Database Diagnostic Monitor (ADDM)

Flashback operations available on row, transaction, table or database level

Ability to UNDROP a table from a recycle bin

Ability to rename table spaces

Ability to transport table spaces across machine types (E.g Windows to Unix)

Proactive Performance Monitoring

Improved Flashback Technology

Automatic Storage Management (ASM) and hence better RAC

Data Pumps

The Enterprise Manager (EM)

Clearly Oracle 10g is a positive change over its predecessor and therefore the OCA 10g Certification will draw more demand than Oracle 9i.