please explain database architecture..
Answer / 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 |
What normalization means?
When do we use triggers?
What is sqlexception in java?
What is a temporal data type?
Is sqlite thread safe?
what is view? : Sql dba
What are variables in pl sql?
What is user defined functions?
How can we optimize a sql query?
What is the maximum size of sqlite database?
How do you explain an index number?
Explain the update statement in sql