Following are the key differences in Oracle 9i and Oracle
10g
1. There are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automated Storage Management (ASM), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) were introduced 10g version of oracle.
2. For developers, 10g is more stable than 9i. All the earlier bugs reported were fixed in 10g release.
3. Performance wise, 10g is more impressive. It has increased the data chunk size during I/O between the SQL and PL/SQL engines. Use of collections is recommended in 10g.
PLS_INTEGER, a new data type was added which enhances performance. ANYDATA data type was introduced to hold a data of variant feature.
4. FLASHBACK option was made more stronger like TABLE FLASHBACK was introduced. Oracle Recyclebin was introduced. The dropped objects can be flashed back like tables.
5. Support for bigfile tablespaces that is up to 8 Exabytes in size has been introduced
6. Data Pump has been introduced for faster data movement with expdp and impdp utilities.
7. In Oracle 9i after drop we can't rollback the drop operation but we can do it in 10g.
Moreover, 10g has additional 149 features than 9i.
1. There are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automated Storage Management (ASM), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) were introduced 10g version of oracle.
2. For developers, 10g is more stable than 9i. All the earlier bugs reported were fixed in 10g release.
3. Performance wise, 10g is more impressive. It has increased the data chunk size during I/O between the SQL and PL/SQL engines. Use of collections is recommended in 10g.
PLS_INTEGER, a new data type was added which enhances performance. ANYDATA data type was introduced to hold a data of variant feature.
4. FLASHBACK option was made more stronger like TABLE FLASHBACK was introduced. Oracle Recyclebin was introduced. The dropped objects can be flashed back like tables.
5. Support for bigfile tablespaces that is up to 8 Exabytes in size has been introduced
6. Data Pump has been introduced for faster data movement with expdp and impdp utilities.
7. In Oracle 9i after drop we can't rollback the drop operation but we can do it in 10g.
Moreover, 10g has additional 149 features than 9i.
Can you explain your 7th point. I think this can be done by FLASHBACK option. M i right? Is there anymore option whcih can be used to rollback after drop?
ReplyDeleteDear Navneet
ReplyDeleteBy 7th point i mean flashback droped table . flashback droped table was first introduced in oracle 10g .
SQL>flashback table emp to before drop;