TUNING

How to Perform a Health Check of an Oracle Database 4.9 (7)

March 1, 2021

How to perform Oracle Database health-check In this blog, we’ll be learning about how we can perform Oracle Database health-check. Many times we have seen that we got the request…

Step by Step How to increase SGA size in Oracle 4.3 (3)

February 14, 2021

Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR  and ADDM reports and came to the…

How to run sql tuning advisor in Oracle 5 (5)

January 24, 2021

Steps by steps to run SQL Tuning Advisor in Oracle As we all know running a slow query is a major performance issue in the database also has the biggest…

How to Check Retention Period of AWR Snapshot in Oracle 5 (1)

January 8, 2021

How to Check Retention Period of AWR Snapshot in Oracle AWR (Automatic Workload Repository) is a key to diagnose the performance of Oracle database, AWR collects various types of processes along…

How to Find Last Analyzed date on Tables, Partition, and Subpartition in Oracle 5 (1)

December 14, 2020

Find Last Analyzed date on Tables, Partitions, and Subpartitions in Oracle Here we are going to demonstrate how to find the last analyzed date on tables in Oracle. Some time…

How to Find Sessions in RAC Oracle All in One 5 (3)

December 9, 2020

How to Find Sessions In RAC Oracle All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to…

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…

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…

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…