what is the difference between Oracle 8i and Oracle 9i

10 pts.
Tags:
Oracle
Oracle 8i
Oracle 9i
what is the difference between Oracle 8i and Oracle 9i

Answer Wiki

Thanks. We'll let you know when a new response is added.

Some of the differences are:
In oracle 9i we can drop column this option is not availbe in 8i
New datatype called timestamp
You can moniter index using alter index <index name> monitering usage
You can check user_objects table from system user
New performance monitering tools called STATPACK
You can dynamically change init ora parameter using alter system <parameter> scope=/path/ of your spfile/pfile
New concept for undo transaction called UNDO tablespace
By default TEMP tablespace is considering while creating new oracle users
New partition called LIST
Tablespace next extent can be managed automatically
In oracle 8i default tablespace is dictonary managed while in 9i it is locally managed
Oracle 9i can support 512 PetaByte of data
Oracle can supprt 10,000 concurrent users.
Oracle 9i provides auto undo segment management.
9i Supports RAC
Simplified scripts for RMAN backup and Recovery
Rollback segments (undo) is managed automatically by Oracle
Multiple block size support.
ANSI Support for join i.e inner-join,outer-join,left-outer join keyword introduced instead of operator(+)

I’m sure that there are other things which other people can add to this list.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • NOSIBAH1
    quality of oracle 8i,9i,10g and cost of qulaity,trainning of quality
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following