Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Program Global Area (PGA)
Published by :
Obay Salah , November 20, 2024
I previously mentioned that all Sessions are connected to the SGA memory, which is a type of Shared Memory for all Sessions connected to the Instance.... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Automatic Shared Memory Management (ASMM)
Published by :
Obay Salah , November 20, 2024
Memory management is one of the factors that affect performance. The database administrator may configure the SGA optimally for morning work... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Steams Buffer
Published by :
Obay Salah , November 20, 2024
This part of the memory is optional and is created through the STREAMS_POOL_SIZE parameter. The purpose of this memory area is to store ... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Java Buffer
Published by :
Obay Salah , November 20, 2024
This part of the memory is optional, and you may not need it if you are not storing any Java Stored Procedures. However, in general, this part ca... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Large Pool
Published by :
Obay Salah , November 20, 2024
The purpose of this memory segment is to reduce the load on the Shared Pool. The Large Pool is used in several operations, including th... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Log Buffer Cache
Published by :
Obay Salah , November 20, 2024
This part of memory is used to store all the changes that occur in the database. It is essentially a staging area for all the changes that have been m... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Nonstandard Block Size Pools
Published by :
Obay Salah , November 20, 2024
Oracle allows the use of Multiple Block Sizes in the database, but each block size must have a corresponding pool in the Database Buffe... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Sizing the Database Buffer Cache
Published by :
Obay Salah , November 20, 2024
Database Buffer Cache should be sufficiently large to accommodate the blocks that are frequently and repeatedly used. However, it should not be e... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The Default, Keep, and Recycle Pools
Published by :
Obay Salah , November 20, 2024
Database Buffer Cache: It can be divided into approximately three memory segments, and any segment should be placed in one part of the memory. All the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Database Buffer Cache
Published by :
Obay Salah , November 20, 2024
The server processes create a copy of the datafile block into the database buffer cache. If the block is modified in the database buffer cache, the DB... Continue Reading