Oracle 10g

From Oracle FAQ
Jump to: navigation, search

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[edit]

Two releases are available:

Oracle 10g Release 1 (10.1.0)[edit]

In 2003, Oracle Corporation released Oracle Database 10g Release 1 (10gR1).

Status: Unsupported
Latest patch-set:

Premier Support Ends: 31-Jan-2009
Extended Support Ends: 01-Jan-2012

Oracle 10g Release 2 (10.2.0)[edit]

In July 2005, Oracle Database - also known as Oracle Database 10g Release 2 (10gR2) - was released.

Status: Unsupported
Latest patch-set: (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[edit]

The following new features were introduced with Oracle 10g:

Oracle 10g Release 1 (10.1.0) - 2003[edit]

  • 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
  • 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[edit]

  • 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[edit]

The following features are desupported in 10g:

  • Oracle's rule based optimizer is still available in 10g, but no longer supported.

Upgrade path[edit]

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[edit]

TGV Oracle Database
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, Oracle 18c, Oracle 19c