Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
check Oracle DB FRA and DISKGROUP Usage
Published by :
Obay Salah , December 22, 2024
1- Check fast recovery area usageselect name,round(space_limit / 1024 / 1024 /1024) size_gb ,round(space_used / 1024 / 1024/1024) used_gb, decode... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Enabling ARCHIVELOG mode
Published by :
Obay Salah , December 22, 2024
1- Log in as user oracle and enter the following commands:$ export ORACLE_SID=<MYDB> where <MYDB> is the name of the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle 19c Installation on Linux
Published by :
Obay Salah , December 15, 2024
1. Hardware Requirements— Check Physical RAM.# grep MemTotal /proc/meminfo We need at least 8192 MB of physical RAM— Check Swap Space.# grep SwapTotal... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Blocked Sessions in Oracle
Published by :
Obay Salah , December 10, 2024
1- Get current session id.SELECT SID, SERIAL# FROM V$SESSION WHERE SID = Sys_Context('USERENV', 'SID'); 2- Create Below Table and Insert a Row Without... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The Segment Advisor
Published by :
Obay Salah , November 20, 2024
We previously discussed the logical and physical components of the database and identified that objects such as tables and indexes are stored logicall... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The SQL Access Advisor
Published by :
Obay Salah , November 20, 2024
The SQL Access Advisor works similarly to the SQL Tuning Advisor, and the analysis will focus on testing the impact of adding a new index and also, up... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The Automatic Database Diagnostic Monitor (ADDM)
Published by :
Obay Salah , November 20, 2024
As mentioned earlier, the MMON writes statistics from memory to disk in the AWR in what is known as a Snapshot. The MMON Background Process also gener... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
The Automatic Workload Repository (AWR)
Published by :
Obay Salah , November 20, 2024
Oracle collects a large amount of statistical data regarding performance and activity. This data accumulates in memory and is then written periodicall... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Optimizer Statistics
Published by :
Obay Salah , November 20, 2024
There are many ways to execute SQL statements, and the process of choosing an execution plan for SQL statements is highly influential on perform... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Rebuild Invalid Inexes
Published by :
Obay Salah , November 20, 2024
The Database Administrator can repair unusable indexes by rebuilding them using the command: ALTER INDEX … REBUILD This command creates a new index th... Continue Reading