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
Can we insert data into view?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
what is the difference between primary key and unique key? : Sql dba
How do I find duplicates in the same column?
Can we delete column in sql?
What are all the different normalization?
What do you think about pl/sql?
What is procedure explain with program?
What are the different types of constraints?
What will you get by the cursor attribute sql%found?
State few characteristics of pl/sql?
How does a covering index work?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is data control language (dcl)?
What are the advantages of pl sql over sql?