Oracle-L: RE: Win2000/8.1.7.3.0/SQL

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Tue, 20 Aug 2002 13:48:26 -0800
Message-ID: <F001.004BA79E.20020820134826@fatcity.com>

Mike,

Just a thought - could you check DBA_TAB_COLUMNS too for LAST_ANALYZED in the SYS schema?

John

> 1 select owner, trunc(last_analyzed), count(*)
> 2 from dba_tables
> 3* group by owner, trunc(last_analyzed)
> SQL> /

> So I'm confident it's not analyzed SYS objects. But then I
> wondered what else Siebel may have done...so I did this...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 20 2002 - 16:48:26 CDT