Oracle 10g is a version of the Oracle Database. The g stands for "grid" to indicate that 10g is "grid-computing ready".
 History and Support Status
Two releases are available:
 Oracle 10g Release 1 (10.1.0)
In 2003, Oracle Corporation released Oracle Database 10g Release 1 (10gR1).
Latest patch-set: 10.1.0.5
 Oracle 10g Release 2 (10.2.0)
In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released.
Latest patch-set: 10.2.0.5 (the terminal patch set for this release)
 Features introduced
The following new features were introduced with Oracle 10g:
 Oracle 10g Release 1 (10.1.0) - January 2004
- Grid computing - an extension of the clustering feature (Real Application Clusters)
- Manageability improvements (self-tuning features)
- Performance and scalability improvements
- Automated Storage Management (ASM)
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- 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 (E.g Windows to Unix)
- 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 - faster data movement with expdp and impdp
- SYSAUX tablespace has been introduced
- NID utility has been introduced to change the database name and/or id.
 Oracle 10g Release 2 (10.2.0) - September 2005
- Transparent Data Encryption
- Async COMMITs
- The CONNECT ROLE can now only connect (CREATE privs removed)
- Passwords for DB Links are encrypted
- New asmcmd utility for managing ASM storage
- Support for regular expressions in SQL and PL/SQL
 Desupported features
The following features are desupported in 10g:
- Oracle's rule based optimizer is still available in 10g, but no longer supported.
 Upgrade path
Direct upgrade to Oracle 10g is only supported if your database is running one of the following releases: 8.0.6, 8.1.7, 9.0.1, or 9.2.0. If not, you will have to upgrade the database to one of these releases or use a different upgrade option (like export/ import).
|Oracle 1 | Oracle 2 | Oracle 3 | Oracle 4 | Oracle 5 | Oracle 6 | Oracle 7 | Oracle 8 | Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11gR1 | Oracle 11gR2 | Oracle 12c|