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 is a call statement? Explain with an example.
What is use of term?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What are the different types of joins in sql?
What is sql analyzer?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Is it possible to sort a column using a column alias?
how to shut down the server with 'mysqladmin'? : Sql dba
What is scalar data type in pl sql?
What port does sql server use?
What do you mean by “trigger” in sql?
What are the different type of joins in sql?
What is self-join and what is the requirement of self-join?
What is the purpose of using pl/sql?
define join and explain different type of joins? : Sql dba