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


Please Help Members By Posting Answers For Below Questions

What does the acronym acid stand for in database management?

671


Is pl sql a scripting language?

673


Which software is used for pl sql programming?

608


what are date and time data types? : Sql dba

613


Does normalization improve performance?

643






What is the max nvarchar size?

602


What is sql engine in oracle?

620


What are the different types of database management systems?

626


What is the reports view in oracle sql developer?

648


what is the difference between blob and text? : Sql dba

621


How do you run a query?

675


Does sql*plus have a pl/sql engine?

668


What is the location of pre_defined_functions.

729


What are the query optimization techniques?

621


Is delete faster than truncate?

644