Oracle Performance Tuning Archives - Page 3 Of 3

How to Flush bad SQL Plan from Shared Pool in Oracle:

In some of the performance issues, we may need to flush bad SQL plan from shared pool in Oracle Database. […]

In some of the performance issues, we may need to flush bad SQL plan from shared pool in Oracle RAC

During DB performance or slowness issues, it is very important to check long running query in Oracle database as a

You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance

Do you know how to troubleshoot high FRA usage in Oracle, if you are looking for the same, then you

Do you know why stats gather is required in Oracle Database? i)As a DBA we may see that, highly transactional

Do you know why index rebuild is required in oracle? If the index gets invalid or unusable state for some

Tablespace is a logical storage structure of a database that contains tables, indexes etc. So if a table, lob partition

As a DBA it is very common in our daily basis scenarios if a database is performing slow. You should