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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
User Trace Files in Oracle Database
Published by :
Obay Salah , November 19, 2024
Background Trace Files are generated automatically at the moment a problem occurs, but User Trace Files are generated only on demand. T... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Editing Thresholds in Oracle Database
Published by :
Obay Salah , November 19, 2024
The database administrator can configure the thresholds using the DBMS_SERVER_ALERT package to issue alerts. However, before the database administrato... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Server-Generated Alerts
Published by :
Obay Salah , November 19, 2024
It is a system that monitors the database, the Instance, and the User Sessions, issuing warnings at certain thresholds and when specific events... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Background Trace Files
Published by :
Obay Salah , November 19, 2024
This file contains more detail than the Alert Log. Notice that I said files because the database contains one important Alert Log regardless of... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Alert Log
Published by :
Obay Salah , November 19, 2024
This is a file that contains several important messages relevant to the database administrator. This file is located in the specified path defined in... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Deadlocks
Published by :
Obay Salah , November 19, 2024
This is a problem that usually arises due to poor program design and not because of the database administrator. The problem is summarized in that two... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Lock Contention
Published by :
Obay Salah , November 19, 2024
If an operation is being written by more than one user on a specific field at the same time, it is not allowed by the database, and this is enforced t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Enqueue Mechanism
Published by :
Obay Salah , November 19, 2024
Let's assume a session requests a lock on a table or a specific field but finds that field or table locked by another session. This session will remai... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Manual Lock Table
Published by :
Obay Salah , November 19, 2024
The database administrator can manually lock the table using the Lock Table command.LOCK TABLE TEST IN SHARE MODE; Thus, we have appli... Continue Reading