GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle

 Print  |  
Question:  difference between oracle 8i and 9i ?



February 02, 2006 05:45:58 #1
 rajat dey   Member Since: Visitor    Total Comments: N/A 

RE: difference between oracle 8i and 9i ?
 

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

or

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

regrds

rajat dey

     

 

Back To Question