Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: query on ditionary objects
when i dont have stats, it is slow.
after perofrming stats. i see that i am getting faster response.
Yavor Ivanov <Yavor_Ivanov_at_stemo.bg> wrote:
Hm.
My guess would be oposite. According to Oracle Docs, you should not
collect stats for objects in SYS schema in 9i or the database will creep.
So, do you realy have ANY stats on SYS objects? If you do have, remove
them...
Rgds,
yavor
On Wed, 19 Oct 2005 09:48:19 +0300, raja rao wrote:
> Hi All,
>
> querying sys objects taking long time in 9205. is this becoz, of the
> stats missing on sys schema ?
> select trunc(last_analyzed), count(*) from dba_tables
> group by trunc(last_analyzed);
> (taking 10-15 seconds)
> Can someone throw some light on this.
> Thanks,
> Raj
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
-- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- http://www.freelists.org/webpage/oracle-l --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 19 2005 - 03:57:13 CDT