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
What is assignment operator in pl sql?
What does a pl/sql package consist of?
What is sql character function?
Is not null in sql?
What is difference between inner join and cross join?
Is sql developer case sensitive?
What are actual parameters and formal parameters?
Are stored procedures compiled?
how many ways we can we find the current date using mysql? : Sql dba
What is sql comments?
Enlist the characteristics of pl/sql?
How do you update a sql procedure?
what is heap table? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
Is sqlite thread safe?