stats in 11g
From: K R <kp0773_at_gmail.com>
Date: Fri, 15 Jul 2011 18:42:48 -0700
Message-ID: <CABPz0xg1wZzEx6i9eapA0y4aYTGHQigpiHyNg_dLHY7uG2H1rw_at_mail.gmail.com>
All,
Date: Fri, 15 Jul 2011 18:42:48 -0700
Message-ID: <CABPz0xg1wZzEx6i9eapA0y4aYTGHQigpiHyNg_dLHY7uG2H1rw_at_mail.gmail.com>
All,
on 11.2.0.2 I only run this to gather statistics DBMS_STATS.GATHER_DATABASE_STATS(estimate_percent=>dbms_stats.auto_sample_size);
But I see that dbms_stats.auto_sample_size is touching all the tables in the db instead of only the tables those were changed . is this normal?
and I see few of the user table and SYS tables stats getting locked
ORA-20005: object statistics are locked (stattype = ALL)
what will be a recommended approach to gather stats in 11gR2.
appreciate any suggestions
TIA
Kart
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 15 2011 - 20:42:48 CDT