Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 20 March 2012

Differences between Oracle 9i and 10g

What is New in Oracle 9i
1. Oracle 9i support Microsoft Transaction services and Internet information services.
2. DBCA include database Templates.
3. Connect internal not supported in Oracle 9i. You have to use in oracle 9i CONNECT / AS    SYSDBA.
4. Server Manager not supported in Oracle 9i.
Differences between Oracle 9i and 10g
When you are going to migrate the database from 9i to 10g  you must consider the list of differences:
Major changes to SQL optimizer internals.
Oracle Grid computing
AWR and ASH (Automatic Session History) tables incorporated into Oracle Performance Pack and Diagnostic Pack options
Data Pump replaces imp utility with impdp
Automatic Database Diagnostic Monitor (ADDM)
SQLTuning Advisor
SQLAccess Advisor
dbms_scheduler package replaces dbms_job for scheduling
Miscellaneous Oracle10g enhancements:
Set Database Default Tablespace syntax.
Rename Tablespace command.
Introduced RECYCLEBIN command for storing objects before they are dropped. Required new PURGE command for maintenance.
sqlplus / as sysdba accessibility without quote marks.
SYSAUX tablespace.
Multiple Temporary Tablespaces supported to reduce stress on sorting in TEMP.
RMAN introduces compression for backups.
New drop database syntax.
New alter database begin backup syntax.
Oracle10g Data Guard Broker introduced.
Flashback enhancements for flashback database and flashback table syntax.
SQL Apply feature.
Cross Platform Transportable Tablespaces.
External Table unload utility.
Automatic Database Tuning of Checkpoints, Undo Segments and shared memory.
PL/SQL Compiler enhanced for compile-time Warnings in utl_mail and utl_compress.


Post a Comment