Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SET AUTOTRACE ON- not showing the actual stats.

SET AUTOTRACE ON- not showing the actual stats.

From: <arul.kumar_at_bt.com>
Date: Wed, 1 Dec 2004 11:18:35 -0000
Message-ID: <83FC2D1BC95D884894735B11B562A41C098855CB@i2km06-ukbr.domain1.systemhost.net>


Dear DBAs,

I could not see the actual statistics in a "SET AUTOTRACE ON" session though I have the following set on my server:

SQL> show parameter stat

NAME                                 TYPE    VALUE
------------------------------------ -------
------------------------------
timed_os_statistics                  integer 0
timed_statistics                     boolean TRUE

And, I tried enforcing the same

Alter session set timed_statistics=3Dtrue;

select * from xyz;

..
....

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)
     570309  rows processed

Am I missing something?

Environment:

HP-UX B.11.11
Oracle 8.1.7.4

Thanks,
Arul.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 01 2004 - 05:13:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US