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 |
[edit] History and Support Status
Two releases are available:
[edit] 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
[edit] 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
[edit] Features introduced
The following new features were introduced with Oracle 10g:
[edit] 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.
[edit] 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
[edit] Desupported features
The following features are desupported in 10g:
- Oracle's rule based optimizer is still available in 10g, but no longer supported.
[edit] 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).
[edit] External links
| Oracle Database |
|---|---|
| Oracle 1 | Oracle 2 | Oracle 3 | Oracle 4 | Oracle 5 | Oracle 6 | Oracle 7 | Oracle 8 | Oracle 9i | Oracle 10g | Oracle 11g |
