Programming Logics FORUMS

Full Version: Difference between 9i and 10g!!!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have been lurking around the site for sometime now and found the people here sharing some very useful information. Wink I am looking forward to come to terms with some new things here. Big Grin I just wanted to know the difference between the Oracle 9i and Oracle 10g. Cool
I didn't find any difference except the installation procedure. Undecided
there is not much difference
There are so many difference between 9i and 10g as bellow:

1) Major changes to SQL optimizer internals
2) Oracle Grid computing
3) AWR and ASH tables incorporated into Oracle Performance Pack and Diagnostic Pack options
4) Automated Session History (ASH) materializes the Oracle Wait Interface over time
5) Data Pump replaces imp utility with impdp
6) Automatic Database Diagnostic Monitor (ADDM)
7) SQLTuning Advisor
8) SQLAccess Advisor
9) Rolling database upgrades (using Oracle10g RAC)
Reference URL's