Interested to Buy Any Domain ? << Click Here >> for more details...
Diference between Oracle 9i and 10G.
- 2 Answers
- 8014 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 calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What does LGWR do?
How to implement the multiple control files for an existing database ?
What is the significance of having storage clause ?
What is an Oracle Data Block?
What is dictionary cache ?
what is the role of archiever
How will you estimate the space required by a non-clustered tables?
Can a View based on another View in Oracle?
What is meant by redo log buffer ?
How will you monitor rollback segment status ?
What are Oracle Schema Objects?
Oracle General 
