Solution : https://service.sap.com/sap/support/notes/948197 (SAP Service marketplace login required)
Summary :
Errors in Oracle versions 9.2.0.7, 9.2.0.8, and 10.2.0.2 while executing the DBMS_STATS package have prompted the release of specific merge patches due to errors in the prvtstat.sql module. For Oracle 9.2.0.8, patch 5915066 merges corrections for bugs 5284303 and 4599763, related to incorrect CBO decisions and DBMS_STATS, respectively. Update to Oracle 10.2.0.2 on September 07, 2007, entails a modified merge patch 6340979 that includes multiple individual patches addressing issues from column length calculation errors to performance-intensive stats flushing, thus requiring updates tailored to platform-specific patches.
Key words :
ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 10, ziphp ux itanium 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris x86-64 /oracle/oracle 64-bit/oracle 10, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 10, aix 5l 64-bit /oracle/oracle 64-bit/oracle 10, long raw column wrong caused fts 5709414 - dbms_stats, ziplinux x86-64-bit /oracle/oracle 64-bit/oracle 10, ziphp tru64 /oracle/oracle 64-bit/oracle 10, ziplinux itanium 64 /oracle/oracle 64-bit/oracle 10, ziplinux ibmpower 64 /oracle/oracle 64-bit/oracle 10
Related Notes :
| 1026396 | DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 633914 | Error when executing DBMS_STATS |
| 601157 | Oracle9i: Server Parameter File |
| 596423 | Events and SPFILE |
| 176754 | Problems with CBO and RBO |