What are the basic element of Base configuration of an
oracle Database ?
Answer Posted / sawant
It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a trace file and how is it created in oracle?
What is an oracle user role?
What are the different types of modules in oracle forms?
What is an oracle data file?
Explain the use of rows option in exp command.
What is the difference between $oracle_base and $oracle_home?
What is analyze command used for?
Explain about the analyze command in oracle?
Calculate difference between 2 date / times in oracle sql?
How to use "in out" parameter properly?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is catalog in Oracle?
What is a partition in oracle?
How index is implemented in oracle database?
How to convert characters to dates in oracle?