 Related Questions Database buffers, Redo Log Buffer the Shared Pool and Cursors. Latest Answer : Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache. ... Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk. Latest Answer : Database buffers consists of the dirty blocks. When ever we are trying to update some table/etc. First it verifies whether the data exists in database buffer , If not it fetches the information from data files to database buffer. So the modified values ... Redo Log Buffer stores redo entries a log of changes made to the database. Latest Answer : It stores redo log entries a log of changes made to a Database. ... A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution Latest Answer : HiShared SQL areas are shared memory areas; any Oracle process can use a shared SQL area. The use of shared SQL areas reduces memory usage on the database server, thereby increasing system throughput. Shared SQL areas are aged out of the shared ... A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server. Tags : Parallel Server DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process MonitorARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server. Latest Answer : Mandatory Processes DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process Monitor Optional Process ARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server. ... Database writer writes modified blocks from the database buffer cache to the data files. DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data Latest Answer : DBWR writes* when checkpoint occures* when dirty buffers reach threshold* when RAC ping requested* when free buffers are not available* when tablespace taken offline,droped ... LGWR writes redo log entries into an on-line redo log file when transactions commit and the log buffer files are full. Latest Answer : Log writer writes* when transaction commits* every three seconds* when 1/3 of redo full* when 1mb of redo generated* before dbwn writes ... The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control Latest Answer : Ckpt (checkpoint) is a background process. It synchronize SCN of all the database files like datafiles, control files and redo log files. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0