What are the basic element of Base configuration of an oracle Database ?

 It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary tablesUser objects (table,indexes,views etc.,)The server that access the database consists ofSGA  (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)RECODispatcherUser Process with associated PGS

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions