RE: SET AUTOTRACE ON- not showing the actual stats.

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 1 Dec 2004 19:35:20 -0600
Message-ID: <433A07749711884D8032B6A0AB1152620548B23D@conmsx07.corp.acxiom.net>

Arul,

RUN:
-- Copyright (c) Oracle Corporation 1995, 2002. All Rights Reserved.
--

NAME
plustrce.sql
--
DESCRIPTION
Creates a role with access to Dynamic Performance Tables
for the SQL*Plus SET AUTOTRACE ... STATISTICS command.
After this script has been run, each user requiring access to
the AUTOTRACE feature should be granted the PLUSTRACE role by
the DBA.
--
USAGE
sqlplus "/ as sysdba" @plustrce
--
Catalog.sql must have been run before this file is run.
This file must be run while connected to a DBA schema.

set echo on

drop role plustrace;
create role plustrace;

grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$mystat to plustrace;

grant plustrace to dba with admin option;

set echo off

Larry

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of arul.kumar_at_bt.com
Sent: Wednesday, December 01, 2004 5:19 AM To: oracle-l_at_freelists.org
Subject: SET AUTOTRACE ON- not showing the actual stats.

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

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 01 2004 - 19:31:53 CST