query on ditionary objects

From: raja rao <raja4list_at_yahoo.com>
Date: Tue, 18 Oct 2005 23:48:19 -0700 (PDT)
Message-ID: <20051019064819.56017.qmail@web31402.mail.mud.yahoo.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 19 2005 - 01:50:34 CDT