Oracle 10g
From Oracle FAQ
Oracle 10g is a version of the Oracle Database. The g stands for "grid" to indicate that 10g is "grid-computing ready".
Also see Oracle 9i and Oracle 11g.
Contents |
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).
Status: Supported
Latest patch-set: 10.1.0.5
Premier Support Ends: 31-Jan-2009
Extended Support Ends: 01-Jan-2012
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.
Status: Supported
Latest patch-set: 10.2.0.4
Premier Support Ends: 31-Jul-2010
Extended Support Ends: 31-Jul-2013
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.
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
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).
