What is difference between oracle8i oracle9i?

Answer 1

The major differences 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