Basic difference between Oracle 9i and 10g

6 ANSWERS

1. amomipais82
   

   Hi There,
     Each release of Oracle has many differences, and Oracle 10g is a major re-write of the Oracle kernel from Oracle 9i.  I keep a list of the differences and make sure to see these  important differences when migrating from 9i to Oracle 10g.  While there are several hundred new features and other differences between 9i and 10g, here are the major differences between Oracle9i and Oracle10g:
   
       *
   
         Major changes to SQL optimizer internals
       *
   
         Oracle Grid computing
       *
   
         AWR and ASH tables incorporated into Oracle Performance Pack and Diagnostic Pack options
       *
   
         Automated Session History (ASH) materializes the Oracle Wait Interface over time
       *
   
         Data Pump replaces imp utility with impdp
       *
   
         Automatic Database Diagnostic Monitor (ADDM)
       *
   
         SQLTuning Advisor
       *
   
         SQLAccess Advisor
       *
   
         Rolling database upgrades (using Oracle10g RAC)
       *
   
         dbms_scheduler package replaces dbms_job for scheduling
   Thanks

   Report (0) (1)  |   12 years, 9 month(s) ago  

2. Guest1617
   

   Oracle 10g have ability to rename tablespace as well as roll back the drop table while Oracle 9i cant perform it

   Report (0) (2)  |   12 years, 9 month(s) ago  

3. Guest4140
   

   oralce 10g is higher version of oracle 9i, oracle 10g has added a follwoing features
   
   Transparent Data Encryption
   Async commits
   CONNECT ROLE can not only connect
   Passwords for DB Links are encrypted
   New asmcmd utility for managing ASM storage
   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 from 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 is up to 8 Exabytes in size
   Data Pump - faster data movement with expdp and impdp.

   Report (0) (0)  |   12 years, 9 month(s) ago  

4. Guest219
   

   what is difference between Oracle 9i and 10g

   Report (0) (0)  |   12 years, 9 month(s) ago  

5. Guest4088
   

   I don't know about that so don't ask me ever, ever, ever and forever.
   O.K

   Report (0) (1)  |   12 years, 9 month(s) ago  

6. Guest2825
   

   gadida guddu difference teliyada meku waste fellows

   Report (0) (0)  |   12 years, 9 month(s) ago