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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Shared Pool
Published by :
Obay Salah , November 20, 2024
It is an essential part of the SGA memory, and without it, the instance will not work. Control over it is achieved through the variable SHARED_POOL_SI... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle System Global Area
Published by :
Obay Salah , November 19, 2024
We mentioned that the Instance consists of Memory Structure and Processes, and we also defined that the Memory Structure consists of two components: S... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
DBMS_REPAIR Backage
Published by :
Obay Salah , November 19, 2024
This package contains a number of procedures that perform checks on the objects and identify the corrupted objects, and then it proceeds to repair tho... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The ANALYZE Command
Published by :
Obay Salah , November 19, 2024
The main purpose of this command is to collect statistics to determine the most efficient way to execute SQL statements. However, this command is also... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The DBVERIFY Utility
Published by :
Obay Salah , November 19, 2024
It is a tool that works on the operating system to verify the Data Files, allowing this tool to check the Data Files during its use.It can also... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Detecting Block Corruptions in Oracle Database
Published by :
Obay Salah , November 19, 2024
Of course, the user can detect corrupt blocks at the moment they attempt to read those blocks, but it is better for the Database Administrator t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Block Corruption
Published by :
Obay Salah , November 19, 2024
In fact, it is not within the capacity of the Database Administrator to prevent Block Corruption from occurring, but they can detect these corru... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Session-Level SQL Tracing
Published by :
Obay Salah , November 19, 2024
Tracing can be enabled at the Session level.alter session set sql_trace=true; After configuring the Session, a Trace File is generated in... Continue Reading