Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Shared & Exclusive Locks
Published by :
Obay Salah , November 19, 2024
The prevailing idea states that no more than one user in a database can modify the same row in the same table at the same time.This is logically... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Job Logs
Published by :
Obay Salah , November 19, 2024
The database administrator can monitor and track all Job operations through the Job Logs.Additionally, the database administrator can clean up the Job... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Windows
Published by :
Obay Salah , November 19, 2024
We previously discussed the concept of Schedules, which are used to specify the time for executing Jobs. The concept of Windows is fundamentally... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Job Classes
Published by :
Obay Salah , November 19, 2024
This entity is used to associate one or more Jobs with a specific Resource Manager Consumer Group. We can create a Job Class using the CREATE_JOB_CLAS... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Using Oracle Programs and Schedules
Published by :
Obay Salah , November 19, 2024
We previously talked about the Program and the Schedule, and we defined that multiple Jobs can share a single Program and that a single Schedule can a... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Schedules
Published by :
Obay Salah , November 19, 2024
Let’s assume you want to create a group of Jobs that are executed at the same time and are repeated at the same time, and their execution is completed... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Programs
Published by :
Obay Salah , November 19, 2024
Let's assume we want to create a set of jobs, all of which execute a stored procedure stored in the database at different times.In such a scenario, yo... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Jobs
Published by :
Obay Salah , November 19, 2024
In the Job, we determine what we want to do and also when we want to execute it. As for the question of what we want to do, it can be either:SQL State... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Scheduler Architecture
Published by :
Obay Salah , November 19, 2024
In reality, there are many situations where a database administrator and users need to perform their tasks efficiently through scheduling. Examples of... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Consumer Group Mapping
Published by :
Obay Salah , November 19, 2024
The default method for joining a specific Session within a Consumer Group is through the Username. When a user connects to the database, Oracle... Continue Reading