tag:blogger.com,1999:blog-25740336.post622112345612524664..comments2010-07-23T16:27:47.977+01:00David Kurtzhttp://www.blogger.com/profile/08139761793598085235noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-25740336.post-674037191014782442010-07-23T16:27:47.977+01:002010-07-23T16:27:47.977+01:00David, do you recommend the 4 steps above as the best solution for 11.1.0.7 also? We have just implemented peoplesoft financials 8.9 and have started having issues related to temp table stats (fs_bp, fs_jgen, fs_gledit) and I'm going to implement your suggestions if they apply to 11.1.0.7 also.maryhttp://www.blogger.com/profile/15278459167013279711noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-85830943968193655812008-06-09T18:20:00.000+01:002008-06-09T18:20:00.000+01:00This is very interesting and more straightforward approach. We have a PL/SQL package that will generate a set of triggers, sequence, and debug table to capture data in autonomous transactions. We then move the data from the debug table back to the temporary table to generate Oracle statistics. From there we can import and export statistics to other databases as needed. This is more time intensive and your idea would save quite a bit of time.Eric Gentznoreply@blogger.com