Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Unusable Indexes
Published by :
Obay Salah , November 20, 2024
Indexes can also be unsuitable for use at times. The index is essentially a pointer to the Physical Location. Let’s assume I created a table cont... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Invalid Objects
Published by :
Obay Salah , November 20, 2024
One of the most important things that affect performance is invalid objects, such as (Procedures, Indexes, Materialized Views, Views, Triggers, Packag... Continue Reading
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