For a while , I have seen unexpected growth at SYSAUX tablespace . When listed objects ordered by size , WRH$_LATCH_CHILDREN table is on the top and as a result of examination , it was caused from statistics_level parameter. For a performance issue i have changed this parameter from TYPICAL to ALL to get more detail information . But after performance issue resolved , i have not changed parameter back and it affected tablespace SYSAUX increased to bigger values.
After changing parameter to old value "TYPICAL" , growth decreased to expected values.
Not only statistics_level parameter can cause this issue according to metalink note, also low snapshot interval can cause. For interval 60 minutes is ideal.
No comments:
Post a Comment