Skip to main content

Posts

Showing posts from March, 2019

Understanding the Oracle Database Technical Architecture in Detail

<<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 cache is main