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
Recover a Corrupted Block Using RMAN
Published by :
Obay Salah , November 19, 2024
The process of recovering corrupted blocks is one of the features of RMAN. If a database administrator performs a backup using User-Managed Backu... 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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Instance-Level SQL Tracing
Published by :
Obay Salah , November 19, 2024
The user can create User Trace Files at the Instance level, and there are two variables that control this Trace:The fir... Continue Reading