Oracle 10g

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, Oracle 11g and Oracle 12c.

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: Unsupported
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: Unsupported
Latest patch-set: 10.2.0.5 (the terminal patch set for this release)

Premier Support Ends: 31-Jul-2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011)
Extended Support Ends: 31-Jul-2013

Features introduced

The following new features were introduced with Oracle 10g:

Oracle 10g Release 1 (10.1.0) - 2003

• 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).

External links

• Oracle 10gR1 Documentation
• Oracle 10gR2 Documentation