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 […]

 34 total views

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. […]

 136 total views,  1 views today

0 Comments

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

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 […]

 618 total views,  3 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 […]

 691 total views,  1 views today

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 […]

 151 total views