<<Back to DB Administration Main Page Understanding the Oracle Database Technical Architecture in Detail Since the architecture of oracle database is complicated and difficult to understand for a beginner. I will divide the article in multiple posts. I will try my best to explain you, how oracle database functions. You can leave me your questions/suggestion in the comment box below. A high level architecture of non multitenant oracle database is explained here Database Buffer Cache in Details: The database buffer cache, also called the buffer cache, is the memory area in the System Global Area (SGA) that stores copies of data blocks read from data files. A buffer is a database block-sized chunk of memory. The default size of a database block is 8K and can not be changed once the database is created. Supported non default block sizes are 2k, 4k, 16k and 32k. Each buffer has an address called a Database Buffer Address (DBA) Buffers in database buffer...
A Blog to share interesting Database Facts and Experience.