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

Can we insert data into view?

894


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1051


what is the difference between primary key and unique key? : Sql dba

1028


How do I find duplicates in the same column?

1075


Can we delete column in sql?

1086


What are all the different normalization?

1036


What do you think about pl/sql?

1016


What is procedure explain with program?

1008


What are the different types of constraints?

1167


What will you get by the cursor attribute sql%found?

958


State few characteristics of pl/sql?

969


How does a covering index work?

953


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2213


What is data control language (dcl)?

1128


What are the advantages of pl sql over sql?

1019