Interested to Buy Any Domain ? << Click Here >> for more details...
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
- 1 Answers
- 5388 Views
- Flextronics, I also Faced
- E-Mail Answers
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 is a unique constraint?
explain the difference between delete , truncate and drop commands? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are sql*plus environment variables?
How delete all records from table in sql?
What are the three pl sql block types?
When is the update_statistics command used?
Does sql backup shrink transaction log?
Why having clause is used in sql?
What is a parameter query?
Which is faster joins or subqueries?
Explain the steps needed to create the scheduled job?
Are left and right joins the same?
Does a primary key have to be a number?
Can we change the table name in sql?
