Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the uses of sysdate and user keywords?

1148


What is a dynamic query?

1073


What is the example of procedure?

977


How to write html code in pl sql?

1159


Is sqlite good enough for production?

1046


What is the difference between pl and sql?

1153


what is the difference between delete and truncate statement in sql? : Sql dba

1347


What are the types of keys?

1067


what is a trigger in mysql? : Sql dba

1216


What is an ndf file?

1062


What are its different types of dbms?

1054


what are the advantages and disadvantages of cascading style sheets? : Sql dba

1104


Is primary key a clustered index?

1009


Is time a data type in sql?

962


Why do we need databases?

1089