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
how to install mysql? : Sql dba
What is foreign key in sql with example?
Why do we need cursors in pl sql?
What is before trigger?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is output spooling in sql*plus?
What does select count (*) mean in sql?
How do I run a sql script?
What are the types of dbms?
What is sql profiling in oracle?
What is auto increment in sql?
What is difference between stored procedure and trigger?
Is it possible to update views?
How do I run a pl sql procedure in sql developer?
What are the parameter modes supported by pl/sql?