What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 4863 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
Explain about integrity constraint?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to install oracle database 10g xe?
How to drop an index in oracle?
Explain the use of constraints option in exp command.
Design database draw er diagram for a certain scenario ?
What is analyze command used for?
Explain the blob datatype?
Explain an extent?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to check your oracle database 10g xe installation?
Why do you use stored procedures and state some of its disadvantages?
How to generate query output in html format?
What is oracle database 10g express edition?
How to create additional tablespaces for an new database?
