Re: no stats in autotrace

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 5 May 2004 20:52:30 +0100
Message-ID: <017201c432da$800ecf10$7102a8c0@Primary>

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_at_cosmiccooler.org> To: <oracle-l_at_freelists.org> 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed May 05 2004 - 14:49:59 CDT