Difference between oracle 8i and 9i ?

Showing Answers 1 - 9 of 9 Answers

rajat dey

  • Feb 20th, 2006

The major diffferences are-

In 9i merge , insert all, case is introduced .

In 9i newdatatype called timestamp

In 9i you can moniter index using alter index <index name> monitering usage


u can check user_objects table from system user.

In 9i new performance monitering tools called STATPACK .

In 9i You can dynamically change init ora parameter using alter system <parameter> scope=/path/ of your spfile/pfile

In 9i new concept for undo transaction called UNDO tablespace

In 9i by default   TEMP tablespace  is considering while creating new oracle users

In 9i new partition called LIST

In 9i tablespace next extent can be managed automatically


rajat dey

  Was this answer useful?  Yes


  • Feb 21st, 2006

Dear Rajat,

CASE statement is already there in Oracle 8i.  So, which version of Oracle r u talking about ?

  Was this answer useful?  Yes

Deep Chandra Pandey

  • Mar 28th, 2006

There are many differences between oracle 8i and oracle 9i

(1) In oracle 8i default tablespace is dictonary managed while in 9i it is locally managed.

(2)Oracle 9i can support 512 PetaByte of data.

(3)Oracle can supprt 10,000 concurrent users.

(4)oracle 9i provides auto undo segment management.

and there a lot difference in oracle 9i and 8i as 9i Support RAC Concept.

Thanks and Regards.

Deep Chandra Pandey


  Was this answer useful?  Yes

arun oommen

  • Aug 30th, 2006

thanks a lot.

  Was this answer useful?  Yes


  • Sep 7th, 2006

Differeneces between 8i and 9i

1. Undo Retention

2. Incremental level backup using export and import is not there in Oracle 9i

3. Lot of simplified scripts for RMAN backup and Recovery when compared to Oracle 8i

4. In Oracle 9i Rollback segments (undo) is managed automatically by Oracle.



  Was this answer useful?  Yes


  • Oct 8th, 2006

thank u

  Was this answer useful?  Yes

Rajendra Thanekar

  • Apr 28th, 2007

1)  connect internal (SVRMGR) is not supported in 9i now you can manage database with SQL*plus.

2) SPfile in 9i which is not available in previous version. Helpful for those init parameter those need server reboot.

3) SGA is dynamic i.e buffer cache and shared pool can be dynamically increased or decreased.

4) by default now table-space are locally managed to improve performance as free space management is done in the header of the data file instead of dictionary.

5) Default TEMP table space and default UNDO table space can be specified at the create database statement level.

6)dbms_meta data a new package introduced which helps to generate DDL from the database instead of writing PL/SQL Block.

7) Multiple block size support.

8) Merge statement is introduced in Oracle 9i.

9) ANSI Support for join i.e inner-join,outer-join,left-outer join keyword introduced instead of operator (+)

10) newly introduced Rollback segment management (UNDO)

  Was this answer useful?  Yes


  • Nov 30th, 2008

8i-materilized views, instead of triggers, support internet, granting of columns

9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions