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
Which query operators in sql is used for pattern matching?
what is union? : Sql dba
what is log shipping? : Sql dba
What are the different dcl commands in sql?
Can we join two tables without common column?
does sql support programming? : Sql dba
how can we destroy the cookie? : Sql dba
How much does sql cost?
Explain the difference between triggers and constraints?
What is the use of prepared statement?
how to load data files into tables with 'mysqlimport'? : Sql dba
differentiate between float and double. : Sql dba
how to create a new table in mysql? : Sql dba
What is a constraint? Tell me about its various levels.
what does the t-sql command ident_incr does? : Transact sql