Database Tuning (MOSC)

MOSC Banner

collect statistics

edited Mar 25, 2012 10:48PM in Database Tuning (MOSC) 7 comments
 Hi Oracle gurus,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center