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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Transaction in Oracle Database
Published by :
Obay Salah , November 19, 2024
In both Flashback Table and Flashback versions, Undo Data is used for retrieve objects.Flashback Transaction retrieves all Undo Data F... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Versions Query in Oracle Database
Published by :
Obay Salah , November 19, 2024
Sometimes, as a database administrator, you may need to monitor some modifications to the fields. You need to know the values that a specific... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Table in Oracle Database
Published by :
Obay Salah , November 19, 2024
It is also called Flashback Table Query and this type was introduced in Oracle 10g and is based mainly on the Undo Tablespace,which is returning the t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Query in Oracle Database
Published by :
Obay Salah , November 19, 2024
This type has been available since the Oracle9i release, so that we can use it to query the database not for the data that currently exists, but for d... Continue Reading