Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Resource Manager Configuration
Published by :
Obay Salah , November 19, 2024
To configure the Resource Manager, we will use two packages:DBMS_RESOURCE_MANAGER: This package is used to create plans, directives, and consume... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Resource Manager Plans
Published by :
Obay Salah , November 19, 2024
This is to define and allocate resources among groups, and these plans control a set of resources, primarily the CPU resources and others that w... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Consumer Groups
Published by :
Obay Salah , November 19, 2024
Users of the database are not the same; the database manager is not like a database user who performs one or two operations in a day on the data... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Archived Redo Log Files Backup
Published by :
Obay Salah , November 19, 2024
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK; ALLOCATE CHANNEL D2 DEVICE TYPE DISK; ALLOCATE CHANNEL D3 DEVICE TYPE DISK; BACKUP AS copy archiv... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Database Patching - Introductiion
Published by :
Obay Salah , November 19, 2024
Oracle Database Patching is a critical process for keeping the database protected, secure, and efficient. These updates aim to fix bugs, enhance... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Advanced Security - Introduction
Published by :
Obay Salah , November 19, 2024
Oracle Advanced Security provides a set of security features designed to secure databases and protect them from various security threats. These... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle GoldenGate Introduction
Published by :
Obay Salah , November 19, 2024
Oracle GoldenGate is a powerful tool used for data exchange and integration between different databases, and it is part of Oracle's big data and... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Real Application Clusters (RAC) Concept
Published by :
Obay Salah , November 19, 2024
This technology allows an Oracle database to run across multiple servers simultaneously, enhancing performance and availability.Here’s the conce... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Tablespaces Backup
Published by :
Obay Salah , November 19, 2024
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK MAXPIECESIZE 1G; BACKUP AS COMPRESSED BACKUPSET TABLESPACE USERS; } We created a backup copy for the USER... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Data Files Backup
Published by :
Obay Salah , November 19, 2024
You can create a backup of the Data Files using RMAN, provided that the database is in the Mount or Open state.The Recovery Catalog Database mus... Continue Reading