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...

please explain database architecture..

Answer Posted / rahul khanke

hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process

and much more

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to install mysql? : Sql dba

1156


What is foreign key in sql with example?

974


Why do we need cursors in pl sql?

1151


What is before trigger?

1049


Define SQL and state the differences between SQL and other conventional programming Languages?

1261


What is output spooling in sql*plus?

1087


What does select count (*) mean in sql?

1073


How do I run a sql script?

1224


What are the types of dbms?

1020


What is sql profiling in oracle?

1128


What is auto increment in sql?

1175


What is difference between stored procedure and trigger?

1246


Is it possible to update views?

1006


How do I run a pl sql procedure in sql developer?

1020


What are the parameter modes supported by pl/sql?

1148