tag:blogger.com,1999:blog-25740336.post400004847550273152..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: Controlling How PeopleSoft Cobol Collects StatisticsDavid Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-25740336.post-81638943733624486702012-01-24T07:50:38.395+00:002012-01-24T07:50:38.395+00:00I have found the enforcing plan stability is helpf...I have found the enforcing plan stability is helpful for GPPDPRUN. If you have payrolls of different sizes, or if you run the calculation for a few employees using Group Lists, then Oracle can choose to use different plans. If those plans can be used by a large payroll calculation if they are still in the library cache when it is run. Stored Outlines can be collected and subsequently applied to payroll processes using triggers. <br />See http://blog.psftdba.com/2010/03/oracle-plan-stability-stored-outlines.htmlDavid Kurtzhttps://www.blogger.com/profile/00468908370233805717noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-29632010797951922552012-01-24T04:12:57.903+00:002012-01-24T04:12:57.903+00:00Great post. I would be interested in any other in...Great post. I would be interested in any other insights into tuning the GPPDPRUN process that you may have.<br /><br />We have found that there are a number of SQL statements that benefit from hints, thus overriding the need for accurate stats.Anonymousnoreply@blogger.com