Performance Tuning-Part5

We have discussed on How Optimizer works in our previous article. Please find the article here Performance Tuning – Part4 Now we will discuss about the SQL Tuning. SQL TUNING   Before going into how to perform SQL Tuning, let us begin with Thumb Rules… Read More

Oracle : Change AWR Retention

Check existing retention and current snapshot interval. set linesize 300 select extract( day from snap_interval) *24*60+extract( hour from snap_interval) *60+extract( minute from snap_interval ) snapshot_interval, extract( day from retention) *24*60+extract( hour from retention) *60+extract( minute from retention ) retention_interval, topnsql from dba_hist_wr_control; Below query is… Read More