Basic difference between Oracle 9i and 10g

6 ANSWERS

1. Guest21687968
   

   gadida guddu difference teliyada meku waste fellows

   Report (0) (0)  |   1 year, 3 month(s) ago  

2. Guest19132259
   

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

   Report (0) (1)  |   1 year, 8 month(s) ago  

3. Guest14348031
   

   what is difference between Oracle 9i and 10g

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

4. jade andrews
   

   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)  |   2 years, 5 month(s) ago  

5. Guest11366906
   

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

   Report (0) (2)  |   2 years, 5 month(s) ago  

6. Ali Abdullah
   

   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) (0)  |   2 years, 5 month(s) ago