Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Create Consumer Group
Published by :
Obay Salah , November 19, 2024
The database administrator creates the Consumer Group using the package DBMS_RESOURCE_MANAGER. The fact is that this package contains a number of proc... Continue Reading
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
Enabling Archivelog Mode
Published by :
Obay Salah , November 19, 2024
1- Make sure that the database is running in NOARCHIVELOG mode by running a query on the database.ARCHIVE LOG LIST SELECT LOG_MODE FROM V$DATABA... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle SQL*Loader
Published by :
Obay Salah , November 19, 2024
We used the Data Pump to read, write and send data from one database to another, but all the data that was dealt with was actually in Oracle proprieta... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Time Zones
Published by :
Obay Salah , November 19, 2024
Large companies and databases that deal with multiple time zones must deal with Time Zones, otherwise let's assume this scenario,Let's assume th... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Level of Oracle Globalization
Published by :
Obay Salah , November 19, 2024
Globalization can be specified at any or all of the following levels:1 - The Database: Database Globalization is specified at the moment th... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Character Set
Published by :
Obay Salah , November 19, 2024
Select Character Set:The database administrator must make two important decisions when creating the database:The first decision is to choose the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Globalization
Published by :
Obay Salah , November 19, 2024
Globalization is a term that means serving a number of different environments, languages, cultures and geographical regions that work on a datab... Continue Reading