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
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
Performance Tuning
Published by :
Obay Salah , November 17, 2024
Oracle Database performance refers to how efficiently the database system executes queries and manages resources. Key factors influencing perfor... Continue Reading