How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
- 1 Answers
- 5036 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 execution plan in sql?
what is the difference between join and union? : Sql dba
What is pivot table in sql?
List and explain the different types of join clauses supported in ansi-standard sql?
What are the differences between in and exists clause?
What is pl sql and why it is used for?
How is pl sql different from sql?
How can you select unique records from a table?
What are the subsets of sql?
What is the usage of distinct keyword?
What is the difference between unique and primary key constraints?
Can we use ddl commands in pl sql?
What is nvl?
How do I view a sql trace file?
What is normalization in a database?
