Hi What's The Main Difference Between Oracle 9i & 10g ?

There more features in 10g. Such as Web Based Database Management. Efficient replication support. But system requirements are high compared to 9i. Compare the features. If you require some special 10g features, then go with it. Otherwise stay with 9i. It much lighter than 10g. ( process / memory wise)

You can find them all in the Oracle new features guide published with every release (see link below). However, if you're building real software (i.e. You're building a system that will be deployed and supported by a company and not building something on your personal machine for educational purposes) and trying to choose a database, then the critical factor should be that 11g is already out and 10g has been available for several years. Choose 9i now and you'll either be deployed on an unsupported version, paying extra for extended support or going through an expensive upgrade cycle in the not too distant future.

10g MAY require more resources but provides additional features and includes many improvements that were designed specifically to reduce the ongoing support costs (see TIME spent by your DBA's) which can often more than cover a little additional hardware if necessary.


Check this out >>>>

download.oracle.com



liked my answer? Rate me as "wow"

Many differences are there..



NProvides volume management capabilities
nAutomatic I/O tuning
nEliminates disk fragmentation
nAutomatically selects allocation policy per Oracle file type
nAllow to add/manage the disk on-line
nViews containing information on ASM are V$ASM_DISKGROUP, V$ASM_FILE, V$ASM_OPERATION
Automatic database diagnostic Monitor
JDBC Enahncement
Datapump
Rename Tablespace
Online segment shrink
Partitioning
LOBs in Oracle 10g
Table space alerts