Diference between Oracle 9i and 10G.
- 2 Answers
- 7238 Views
- Baidu, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / banti
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 ? | 10 Yes | 0 No |
Answer / devraj
(1) New functions avialable like reg_exp
(2) Grid computing
(3) Automatic storage management
(4) Recycledbin feature
(5) New purge command
(6) Now data can be deleted with in merge command as well
(7) Multiset operators avialable to compare data between
collection sets
Etc.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to find the SGA Size
Which parameter in Storage clause will reduce no. of rows per block?
How the log writer writes the data into database
How will you force database to use particular rollback segment?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How does Space allocation table place within a block ?
What is hit ratio ?
What is PGA?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
Can a Tablespace hold objects from different Schemes in Oracle?
What is the maximum size of a oracle9i database?
What is use of Rollback Segments In Database ?
Oracle General 
