Thanks for posting this. I've struggled with this ...

2008-06-26T23:18:00.000+01:00

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.

Are you really sure 4 and 5 have been swapped?
in 8.46, 4 is analyze estimate and 5 is analyze compute.
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.

Am I just muddled?

Comments on The PeopleSoft DBA Blog: Oracle/PeopleSoft have mixed up DDL Models used by...

Thanks for posting this. I've struggled with this ...