0 Comments

How to Perform a Health Check of an Oracle Database 5 (1)

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 from Application user that their application is slow and they’re asking us to perform health checks on the specified database. We generally perform health checks […]

 284 Total Views,  1 Views Today

Spread the love

2 Comments

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

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 conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using […]

 920 Total Views,  6 Views Today

2 Comments

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

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 challenge for DBA to resolve this issue. Resolving the slowness issue we are using an Oracle tool called SQL Advisor. When you run SQL advisor […]

 801 Total Views

0 Comments

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

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 with maintains statistics of database performance. Below is the SQL command to Check the Retention Period of AWR Snapshot in Oracle. We always encourage the technical […]

 165 Total Views

Spread the love

0 Comments

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

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 due to performance issues, statistics locked on the table, disable statistics in the database, before/after manual analyze on tables or gather statistics, before/after migration, etc. […]

 403 Total Views,  2 Views Today

0 Comments

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

To Find Sessions In RAC All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to monitor application connected sessions, etc. Here we are going to show various scenarios to find connected sessions in RAC databases. Here we have a two-node RAC to […]

 941 Total Views,  1 Views Today

4 Comments

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

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 log switches creating contentions at the database. For example, by increasing the redo log file size, the number of log switches can be decreased which […]

 990 Total Views

0 Comments

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

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 how to find the table’s statistics are LOCKED or UNLOCKED in Oracle. Some time due to performance issues or on-demand business impact or auto enable […]

 298 Total Views

2 Comments

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

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 procedure, it will wait to complete procedure then next SQL statement will execute. DBMS_LOCK.SLEEP (seconds IN NUMBER); seconds : Amount of time, in seconds, to suspend the session. The smallest increment can […]

 2,061 Total Views

Spread the love