Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
check Oracle DB FRA and DISKGROUP Usage
Published by :
Obay Salah , December 22, 2024
1- Check fast recovery area usageselect name,round(space_limit / 1024 / 1024 /1024) size_gb ,round(space_used / 1024 / 1024/1024) used_gb, decode... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Enabling ARCHIVELOG mode
Published by :
Obay Salah , December 22, 2024
1- Log in as user oracle and enter the following commands:$ export ORACLE_SID=<MYDB> where <MYDB> is the name of the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle 19c Installation on Linux
Published by :
Obay Salah , December 15, 2024
1. Hardware Requirements— Check Physical RAM.# grep MemTotal /proc/meminfo We need at least 8192 MB of physical RAM— Check Swap Space.# grep SwapTotal... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Blocked Sessions in Oracle
Published by :
Obay Salah , December 10, 2024
1- Get current session id.SELECT SID, SERIAL# FROM V$SESSION WHERE SID = Sys_Context('USERENV', 'SID'); 2- Create Below Table and Insert a Row Without... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Check RMAN Backup status
Published by :
Obay Salah , December 4, 2024
Query to check RMAN Backup status:-select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle ENABLE Trigger
Published by :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to enable a trigger.SyntaxALTER TRIGGER trigger_name ENABLE; Parameterstrigger_na... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DISABLE Trigger
Published by :
Obay Salah , December 3, 2024
The ALTER TRIGGER statement is used to disable a trigger.SyntaxALTER TRIGGER trigger_name DISABLE; Parameterstrigger_... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle DROP Trigger
Published by :
Obay Salah , December 3, 2024
In Oracle, DROP TRIGGER statement is used to drop the trigger if you find that you need to remove it from the database.SyntaxDROP TRIGGER tr... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle After INSERT/UPDATE/DELETE Trigger
Published by :
Obay Salah , December 3, 2024
This statement specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE or DELETE operation is executed.SyntaxCREATE [ ... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Before INSERT/UPDATE/DELETE Trigger
Published by :
Obay Salah , December 3, 2024
This statement specifies that Oracle will fire this trigger BEFORE the INSERT/UPDATE or DELETE operation is executed.SyntaxCREATE [&nbs... Continue Reading