tag:blogger.com,1999:blog-25740336.post3781379610010377648..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: Oracle/PeopleSoft have mixed up DDL Models used by %UpdateStats from PeopleTools 8.48David Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-25740336.post-5811866966559152392008-06-26T23:18:00.000+01:002008-06-26T23:18:00.000+01:00Thanks for posting this. I've struggled with this ...Thanks for posting this. I've struggled with this problem for a couple years now. I'd gotten excited about the prospect of dynamic sampling after a conversation with Wolfgang at Hotsos a couple years back, but then ran into the ORA-20005 and was told to get my nose out of the developers' business.<BR/><BR/>Are you really sure 4 and 5 have been swapped?<BR/>in 8.46, 4 is analyze estimate and 5 is analyze compute.<BR/>In the ddlora.dms I've got in front of me for 8.49, 4 is estimate 1%, and 5 is estimate with auto sample size. I figured they're using auto sample to do better than 1% but avoid the hit of a full compute.<BR/><BR/>Am I just muddled?Anonymousnoreply@blogger.com