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 has stored procedures in sql?
What is compilation error in pl sql?
What does data normalization mean?
Is a foreign key always unique?
How to process query result in pl/sql?
What is the plv (pl/vision) package offers?
Is ms sql traffic encrypted?
Is microsoft sql free?
Write the command to remove all players named sachin from the players table.
What is the difference between distinct and unique in sql?
what are date and time data types? : Sql dba
Can a trigger call a stored procedure?
Can you inner join the same table?
What is posting?
What are the types of variables use in pl sql?