| |
GeekInterview.com > Interview Questions > Oracle
| Print | |
Question: difference between oracle 8i and 9i ?
|
| April 04, 2007 22:37:30 |
#8 |
| Rajendra Thanekar |
Member Since: Visitor Total Comments: N/A |
Difference between oracle 8i and 9i ?
|
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) |
| |
Back To Question | |
