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)
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
The following features are desupported in 10g:
- Oracle's rule based optimizer is still available in 10g, but no longer supported.
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, Oracle 18c, Oracle 19c|