Question:

Difference b/w oracle 9i and 10g?

by Guest3373  |  12 years, 9 month(s) ago

0 LIKES UnLike

Difference b/w oracle 9i and 10g?

 Tags: 10g, 9i, BW, difference, Oracle

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating
  1. Guest774
    Following 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 olling database

        

      - upgrades (using Oracle10g RAC)

        

      - dbms_scheduler package replaces

      

      - dbms_job for scheduling

Sign In or Sign Up now to answser this question!
You're reading: Difference b/w oracle 9i and 10g?

Question Stats

Latest activity: 14 years, 8 month(s) ago.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now