TUNING

ADD-DROP Redo log files in Oracle Database 5 (4)

November 26, 2020

ADD-DROP Redo Log Files In Oracle Database In the real world, we may encounter scenarios where we need to or asked to increase/decrease the size of redo log files as…

Loading

📌
4💬 read more

How to find table’s statistics are LOCKED or UNLOCKED in Oracle 5 (1)

November 19, 2020

Find table’s statistics are LOCKED or UNLOCKED in Oracle Table’s statistics is a key role in terms of performance along with the execution plan of SQL’s statements. Here we demonstrate…

Loading

📌
0💬 read more

How to Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS in Oracle 0 (0)

October 20, 2020

Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS SQL command for standalone database. Click here to get sample output. SQL command for RAC database. Click here to…

Loading

📌
0💬 read more

DBMS_LOCK.sleep procedure to suspend the session in Oracle 4.6 (21)

August 31, 2020

DBMS_LOCK.sleep procedure to suspend the session in Oracle DBMS_LOCK.sleep procedure suspends the session for a given period of time or specified time in the procedure, it will wait to complete…

Loading

📌
2💬 read more