How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
Answer Posted / yasaswini
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
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why is theta join required?
What is compilation error in pl sql?
How do I view an execution plan in sql?
How you improve the performance of sql*loader? : aql loader
Difference between table function and pipelined function?
Can we insert delete data in view?
How do I clear the screen in sql plus?
what are the different tables present in mysql? : Sql dba
how to install mysql? : Sql dba
How to use sql*plus built-in timers?
What is the best sql course?
What is sql and explain its components?
How do I truncate a word?
How do you write an index?
What are reports usually used for?