SAP Note 711047 - Performance problem on DBMS_STATS in 9.2

Component : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/711047 (SAP Service marketplace login required)

Key words :
oracle releases 8i orlower, event inyour init<sid>, collecting index statistics usinganalyze, concerns oracle versions, problemswith oracle 9i, oracle 9i r2, check oss note 539921, set event 38053 todeactivate, event willswitch back, dbms_stats takes longer

Related Notes :

1013912FAQ: Oracle BW performance
806554FAQ: I/O-intensive database operations
761745Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS
706132Composite SAP Note: Problems with Oracle 9i