Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Win2000/8.1.7.3.0/SQL
John:
I checked it out with this...
SQL> select owner, trunc(last_analyzed), count(*)
2 from dba_tab_columns
3 group by owner, trunc(last_analyzed);
OWNER TRUNC(LAS COUNT(*) ------------------------------ --------- ---------- AURORA$JIS$UTILITY$ 69 OSE$HTTP$ADMIN 16 OUTLN 21 PERFSTAT 293 SIEBEL 12-JUL-02 17737 SIEBEL 71877 SYS 15831 SYSTEM 172
8 rows selected.
SQL> ...and it looks like there's nothing here, either!
Thanks,
Mike
-----Original Message-----
Sent: Tuesday, August 20, 2002 2:48 PM
To: Multiple recipients of list ORACLE-L
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: mvergara_at_guidant.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 - 18:28:27 CDT