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 is a call statement? Explain with an example.

1010


What is use of term?

1068


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1111


What are the different types of joins in sql?

1790


What is sql analyzer?

1024


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1067


Is it possible to sort a column using a column alias?

1047


how to shut down the server with 'mysqladmin'? : Sql dba

1012


What is scalar data type in pl sql?

1070


What port does sql server use?

1063


What do you mean by “trigger” in sql?

1079


What are the different type of joins in sql?

956


What is self-join and what is the requirement of self-join?

1151


What is the purpose of using pl/sql?

1146


define join and explain different type of joins? : Sql dba

954