Difference between oracle 9i and oracle 10g?

Answer 1

A lot of differences this is my take on them:

8i -> 9i - Real Application Clusters, PL/SQL enhancements, XMLType enhancements

9i -> 10g - ASM space management, tracing and diagnostics, DML error logging, async commit, more PL/SQL changes, table/column encryption, restore points

10g -> 11g - Probably best to point you to technet on that one.

Answer 2

Hioralce 10g is higher version of oracle 9i, oracle 10g has added a following features

Transparent Data Encryption Async commits CONNECT ROLE can not only connect Passwords for DB Links are encrypted New asmcmd utility for managing ASM storage 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 tablespaces Ability to transport tablespaces across machine types (E.g Windows to Unix) New 'drop database' statement New database scheduler - DBMS_SCHEDULER DBMS_FILE_TRANSFER Package Support for bigfile tablespaces that is up to 8 Exabytes in size Data Pump - faster data movement with expdp and impdp.

Regards Rampoo

Answer 3

Oracle 10g has many features compare to 9i like

asm,swr,addm,flaskback recovery,data pump.

Generating snap shot is much more flexible in 10 g compare to 9i.

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 tablespaces

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

New 'drop database' statement

New database scheduler - DBMS_SCHEDULER

DBMS_FILE_TRANSFER Package

Support for bigfile tablespaces that is up to 8 Exabytes in size

Data Pump - faster data movement with expdp and impdp.

Answer 4

The "i" and "g" Versions

Starting in 1999 with Version 8i, Oracle added the "i" to the version name to reflect support for the internet with its built-in Java Virtual Machine (JVM). Oracle 9i added more support for XML in 2001. In 2003, Oracle 10g was introduced with emphasis on the "g" for grid computing, which enables clusters of low-cost, industry standard servers to be treated as a single unit.

10g is Oracle's grid computing product group including (among other things) a database management system (DBMS) and an application server. In addition to supporting grid computing features such as resource sharing and automatic load balancing, 10g products automate many database management tasks. The Real Application Cluster (RAC) component makes it possible to install a database over multiple servers.

10g follows Oracle's 9i platform. Oracle says that the g (instead of the expected i) in the name symbolizes the company's commitment to the grid model. However, according to some reports, many early adopters are deploying 10g solely for its automation features and have no immediate plans of implementing a grid environment.

Answer 5

storage is different as compared 9i with 10i.........10i uses grid computing...this has more data storage space

Answer 6

The simple answer is that Oracle 10g is a real product from Oracle. Oracle 11i does not exist; the Oracle product is Oracle 11g.

Answer 7

no. of database rules they follow.