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
What are the uses of sysdate and user keywords?
What is a dynamic query?
What is the example of procedure?
How to write html code in pl sql?
Is sqlite good enough for production?
What is the difference between pl and sql?
what is the difference between delete and truncate statement in sql? : Sql dba
What are the types of keys?
what is a trigger in mysql? : Sql dba
What is an ndf file?
What are its different types of dbms?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Is primary key a clustered index?
Is time a data type in sql?
Why do we need databases?