We've a setup that remove the trace files older than 30 days in our platform.
"find ..../trace -type f \( -name "*.trm" -o -name "*.trc" \) -mtime +30 -exec rm {} \;"
Of late the job was taking significant time to wipe off trace files . We then figured that the file system in question needs to be de-fragmented . Now after carrying out the de-fragmenting , the job has been able to complete in reasonable time frame.
I would like to analyze if the Oracle database performance on the whole has improved after the defragmentation . Could someone help me how to prove a point that the overall db performance has improved. Are those pointers be available in the AWR, ADDM reports?
Thank you!
-Bugs