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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
When We Use Oracle Shared Server
Published by :
Obay Salah , November 19, 2024
In fact, you will not find a clear answer to this question? That is, when should you use the Shared Server? Also, how many Dispatchers and Shared Serv... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Shared Server Architecture
Published by :
Obay Salah , November 19, 2024
When the database is configured to work in Shared Server mode, two types of Process are created (Shared Servers & Dispatchers),Also, a numbe... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Dedicated Server
Published by :
Obay Salah , November 19, 2024
This is the model in which the database originally works, whereby a Server Process is created for each User Process that requests to connect to... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Why Oracle Shared Server
Published by :
Obay Salah , November 19, 2024
The original is that when the user requests to connect to the instance, Oracle creates a Server Process whose mission is to serve the requests o... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Oracle Database
Published by :
Obay Salah , November 19, 2024
Have you ever thought about what you would do if you deleted a user by mistake? The answer is simply that I perform a database recovery from a b... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Drop in Oracle Database
Published by :
Obay Salah , November 19, 2024
In previous versions of Oracle Database, the moment you delete a table Drop Table will also be removed from the Data Dictionary, and it requires... Continue Reading