TUNING

Steps to enable HugePages in PostgreSQL 0 (0)

November 18, 2021

Steps to enable HugePages in PostgreSQL By default, the page size on Linux is 4kb. A typical PostgreSQL instance may allocate many GBs of memory, which will end up with…

Monitor PostgreSQL Cluster using pgCenter 0 (0)

October 27, 2021

Monitor PostgreSQL Cluster using pgCenter pgCenter is a command-line admin tool for observing and troubleshooting PostgreSQL i.e monitor PostgreSQL cluster. Postgres provides various activity statistics about its runtime, such as…

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 Check PGA information in Oracle 0 (0)

February 9, 2021

How to Check PGA full information in Oracle.   A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory…

How to Check Long Running Job in the Oracle Database 4.5 (2)

February 4, 2021

How to Check Long Running Job in the Oracle Database Sometimes in the database, few queries are taking a long time to complete the query, to validate which query taking…

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…