top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

0 votes
80 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...