collect statistics
Last days, our DB works slowly. Application developers says that maybe statics collection doesnt work. So how can i find out exactly - does any procedure run dbms_stats packet? i read Tom's answer here http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1133388300346992024 and found this script
In Oracle 11g, there has been a restructuring of the job scheduling framework. In particular, the automatic gathering of optimizer statistics. In Oracle 10g, the following query reveals the association of the program GATHER_STATS_PROG with a job GATHER_STATS_JOB. In Oracle 11g, that association does not seem to be present as the query returns no rows.