Are you connected as SYS ? Until 9.2.0.X (where X is somewhere around 2 or 3) autotrace doesn't collect statistics other that row counts for SYS. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Optimising Oracle Seminar http://www.jlcomp.demon.co.uk/seminar.html June 2004 UK Manchester July 2004 Iceland July 2004 USA California Aug 2004 USA North Carolina Sept 2004 UK Manchester Sept 2004 USA NYC Oct 2004 USA Boston ----- Original Message ----- From: "David Green" <thump@xxxxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, May 05, 2004 8:44 PM Subject: no stats in autotrace Has anyone seen this issue: 81740 db on solaris 8. set autotrace traceonly explain statistics Giving the following results in the stats section: Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 0 bytes sent via SQL*Net to client 0 bytes received via SQL*Net from client 0 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 657190 rows processed timed_statistics boolean TRUE Prior to migrating tables to partitioning, I was getting the following: Statistics ---------------------------------------------------------- 4 recursive calls 350 db block gets 1624245 consistent gets 363016 physical reads 0 redo size 36181075 bytes sent via SQL*Net to client 3549130 bytes received via SQL*Net from client 43814 SQL*Net roundtrips to/from client 12 sorts (memory) 3 sorts (disk) 657190 rows processed What could cause this? Thoroughly confused... - David Green ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------