Re: Verify Outdated Optimizer Stats

From: Ram <krishna000_at_gmail.com>
Date: Mon, 16 Feb 2009 22:05:03 -0800 (PST)
Message-ID: <26241d3c-88fa-4212-9190-d8eedd38cf52_at_i18g2000prf.googlegroups.com>

On Feb 17, 10:43 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Ram" <krishna..._at_gmail.com> a écrit dans le message de news: f05bf69c-f0a2-4bc3-9cd0-2c72f8345..._at_t39g2000prh.googlegroups.com...
> | Hi All,
> |
> | I hope every one would have come across that users complaining about
> | the  response of database.Usually the first thought comes to the DBA
> | is to Gather Stats and verify the performance.Performance will be far
> | better after collecting stats and this is expected behavior.
> |
> | Before users start complaining about the performance of database is
> | very slow , Can't we verify the statistics for out database is that
> | outdated.  Can any one throw some light on this .
> |
> |
> | Regards
> |
> | RAM.
> |
> |
>
> For instance:
>
> set serveroutput on size 10000 format wrapped
> declare
>   l_objList dbms_stats.objectTab;
> begin
>   dbms_stats.gather_schema_stats
>     ( ownname        => user,
>       options        => 'LIST AUTO',
>       objlist        => l_objList );
>   for i in 1..l_objList.count loop
>     dbms_output.put_line (l_objList(i).objName||' - '||l_objList(i).objType);
>   end loop;
> end;
> /
>
> Regards
> Michel

Michel,

Thank you very much as usval ... you always help us .. by the way i want to about you . can you ??.

Oracle Considers if there are more than 10% of modifications on the segment to Re-Analyze right ??

Regards

RAM. Received on Tue Feb 17 2009 - 00:05:03 CST