top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the basic element of base configuration of an Oracle database?

0 votes
419 views
What is the basic element of base configuration of an Oracle database?
posted Aug 21, 2014 by Selvimohana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

It consists of one or more data files, control files, two or more redo log files.

The Database contains multiple users/schemas one or more rollback segments, 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

answer Aug 28, 2014 by Amit Kumar Pandey
...