no stats in autotrace

From: David Green <thump_at_cosmiccooler.org>
Date: Wed, 5 May 2004 14:44:55 -0500 (CDT)
Message-ID: <46481.127.0.0.1.1083786295.squirrel@www.cosmiccooler.org>

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:44:11 CDT