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

What is assignment operator in pl sql?

764


What does a pl/sql package consist of?

721


What is sql character function?

711


Is not null in sql?

732


What is difference between inner join and cross join?

715






Is sql developer case sensitive?

724


What are actual parameters and formal parameters?

778


Are stored procedures compiled?

678


how many ways we can we find the current date using mysql? : Sql dba

811


What is sql comments?

813


Enlist the characteristics of pl/sql?

1491


How do you update a sql procedure?

767


what is heap table? : Sql dba

802


Mention what is the use of function "module procedure" in pl/sql?

784


Is sqlite thread safe?

787