Do not apply step in this topic to production environment becuase changing internal parameter leading oracle software to unsupport by global support.
I believe many of dba love ADDM , it is good friend but some senior or dba who had a lot of tuning expriece may don't trust or like it , someone talk Hey ! I would like to use my knowledge for anlyze the system , how is going on , how to leave it from his/her life because it so alluring to use.
the follow is step to disable addm :
$ sqlplus /nolog
CHATCHAI_K > conn / as sysdba
CHATCHAI_K > alter system set "_addm_auto_enable" = false scope=both sid='*';
Cheer !!
However ADDM is a good utility to helping you to faster tracking the overall system performance analysis and any sql statement may have a problem compare with the period time.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น