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
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
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
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.
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 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
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
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 statistics
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 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
