What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5553 Views
- I also Faced
- E-Mail Answers
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
How to put more than 1000 values into an oracle in clause?
How to use values from other tables in update statements using oracle?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to select all columns of all rows from a table in oracle?
How to start an oracle instance?
