Well , again to get the best of performance in the system , we had observed that the gather schema statistics , with time , had started to take almost 15 hours. The DB size was about 1700 Gb growing daily by 4-5 GB.
Most of us generally run Gather Schema Statistics on the weekend with gather option , however we are not aware of the gather_auto option. Gather_auto is the new and recommended way of running the GSS in the EBS system.
Have adopted the same .Requires a patch :
16410424:R12.FND.B as per Note 1586374.1.
Post application of this patch , the GSS now completes within 7-8 hours on weekends.
And yes , since we are always worried about performance , this did not cause any performance harm. None of the end users came back with any issues.
Cheers
Most of us generally run Gather Schema Statistics on the weekend with gather option , however we are not aware of the gather_auto option. Gather_auto is the new and recommended way of running the GSS in the EBS system.
Have adopted the same .Requires a patch :
16410424:R12.FND.B as per Note 1586374.1.
Post application of this patch , the GSS now completes within 7-8 hours on weekends.
And yes , since we are always worried about performance , this did not cause any performance harm. None of the end users came back with any issues.
Cheers
No comments:
Post a Comment