-
What do Database Buffers contain ?
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.
NAGARAJ OCP
- Dec 27th, 2011
Database Buffer cache has four states: Pinned: multiple sessions are kept from wirting to same block @ same time. Other session waits to access these blocks Clean : Now the session is unpinned ...
saihaan
- Jul 2nd, 2009
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 d...
-
What are the components of SGA ?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
Nagaraj OCP
- Dec 27th, 2011
SGA has six parts on it
Shared pool
JAVA POOL
Stream Pool
Large Pool
Data Buffer cache - MRU, LRU
Redo log buffersaihaan
- Jul 2nd, 2009
Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache.
