Re: Performance issue post database analyze, need to understand whats wrong in analyze
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 6 Jun 2011 23:07:12 -0700
Message-ID: <BANLkTinbhVcyi=bu=ENVMT8VawMpo2jv-g_at_mail.gmail.com>
There's an easy way in 11g with DBMS_STATS.DIFF_TABLE_STATS_IN_HISTORY: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_stats.htm#BEIDHICC
Date: Mon, 6 Jun 2011 23:07:12 -0700
Message-ID: <BANLkTinbhVcyi=bu=ENVMT8VawMpo2jv-g_at_mail.gmail.com>
There's an easy way in 11g with DBMS_STATS.DIFF_TABLE_STATS_IN_HISTORY: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_stats.htm#BEIDHICC
On Mon, Jun 6, 2011 at 8:44 PM, Shastry(DBA) <shastry17_at_gmail.com> wrote:
> The plan change from index usage to FTS since 05-jun-11 18hrs and gather
> stats on this table was on 05-jun-11 10:00 hrs.
>
> After re-gathering stats on DM.CPR_LDAP_SUMMARY the static plan used index
> again and performance improved.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 07 2011 - 01:07:12 CDT