Arab DBA

Database

How to check Oracle DB FRA and DISKGROUP usage?

نشر بواسطة : 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... اكمل القراءة

Database

Enabling ARCHIVELOG mode

نشر بواسطة : 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... اكمل القراءة

Database

Oracle 19c Installation on Linux

نشر بواسطة : 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... اكمل القراءة

Database Performance

Blocked Sessions in Oracle

نشر بواسطة : 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... اكمل القراءة

Backup and Recovery

Check RMAN Backup status

نشر بواسطة : 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... اكمل القراءة

SQL