Performance Tuning – Part4

  Till now in my previous articles we have discussed about the tools that are used in the performance tuning. Please find the previous article here. Performance Tuning in Oracle – Part3 Before we go in depth of the Performance tuning, it is important to… 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