Thanks & Regards:
M K SINGH
>>>>>
Dear Singh,
It’s very hard to tell you the diferrences between each version, it’s a lot more easy for me to show you the new features of each one, here are a small resume (not a full list) of what was new on each version you asked for:
|
Version
|
8i |
9i |
10g |
| First Released |
February, 1999 |
June, 2001 |
January 2004 |
| Support |
Not Supported |
Extended Support Ends: 30/07/2010 |
10gR1:
Premier Support Ends: 31/01/2009
Extended Support Ends: 01/01/2012
10gR2:
Premier Support Ends: 31/07/2010
Extended Support Ends: 31/07/2013
|
| New Features |
|
- Real Application Clusters
- Dynamic Memory Management
- Data Guard
- Automatic Undo Management
- Flashback Query
- XMLType
- List Partitioning
- Range List Partitioning
- FastStart Recovery
- Two-Pass Recovery
- Zero Data Loss
- SVRMGRL and Connect Internal Desupport
- Server Parameter Files (SPFILE)
- Resumable Space Management
- Default Temporary Tablespaces
- Oracle Managed Files (OMF)
- Multiple Database Block Size Support
- Self Tuning PGA
- Online Table Redefinition
- Dbms_metadata package
- Automatic Segment Space Management
- Skip Scanning of Indexes
- Bitmap Join Indexes
- Mapping tables and Bitmap Indexes on Index-Organized Tables
- External Tables
- View Constraints
- Multi-Table Insert Statements
- Associative Arrays
- Oracle Merge Statements
- Opatch
- DBCA
- DBUA
- Support for ANSI/ISO SQL 1999 Compliance
- DBMS_XPLAN
- Better Support for LOB’s
- PL/SQL Native Compilation
- Character vs. Byte Semantics
- Fine Grained Auditing
|
- Manageability improvements
- Performance and scalability improvements
- Automated Storage Management
- Automatic Workload Repository
- Automatic Database Diagnostic Monitor
- Flashback operations available on row, transaction, table or database level
- Ability to UNDROP a table using a recycle bin
- Ability to rename tablespaces
- Ability to transport tablespaces across machine types
- New ‘drop database’ statement
- New database scheduler - DBMS_SCHEDULER · DBMS_FILE_TRANSFER Package
- Support for bigfile tablespaces that are up to 8 Exabytes in size
- Datapump
- Grid computing
- Grid Control
- OEM DB Control
- Transparent Data Encryption
- ASMCMD
- Async Commits
- The CONNECT ROLE can now only connect (CREATE privs removed)
- Passwords for DB Links are encrypted
- Rule based optimizer Desupported
|
As happened with Oracle 9i, Oracle 10g has many enhancements to support largest database size limits and continues to remove the complexity from the DB to make it easier to manage and to reduce the total cost of ownership of it.
Cheers,
Francisco Munoz Alvarez
only the weather is not helping but I hope to have the opportunity to go to the beach and enjoy a little before Wednesday Night. 
