RE: SET AUTOTRACE ON- not showing the actual stats.
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: arul.kumar@xxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 1 Dec 2004 19:35:20 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of arul.kumar@xxxxxx
Sent: Wednesday, December 01, 2004 5:19 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
