How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
Answer / 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 |
Can we use two order by clause in query?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
What is bulk compiling in pl/sql.?
Write a procedure to return the month and the number of developers joined in each month (cursor )
What is difference between stored procedures and application procedures?
Is json a nosql?
What are the types of queries in sql?
Why use stored procedures?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
Which is faster union or join?
Explain normalization and what are the advantages of it?
What are all types of user defined functions?