Thanks Ganesh!
I connected as system and it worked.
Have a nice day!!
-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com]=20
Sent: 01 December 2004 11:27
To: Kumar,A,Arul,XGF3C C
Subject: Re: SET AUTOTRACE ON- not showing the actual stats.
Sorry ..=20
The Only thing is dont run as SYS that is it .. Run as System and u will
see the stats .. Better Still run it as the User who will execute the
uery in the Live Environment ..
Cheers!
Ganesh
On Wed, 1 Dec 2004 11:25:45 -0000, arul.kumar_at_bt.com <arul.kumar_at_bt.com>
wrote:
> but then how do we tune queries which is owned by other users and sys=20
> don't have the password?
>=20
>=20
>=20
>=20
> -----Original Message-----
> From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com]
> Sent: 01 December 2004 11:23
> To: Kumar,A,Arul,XGF3C C
> Subject: Re: SET AUTOTRACE ON- not showing the actual stats.
>=20
> Sys is special .. U will not get Autotrace details if you run as SYS=20
> ..
>=20
> On Wed, 1 Dec 2004 11:21:52 -0000, arul.kumar_at_bt.com=20
> <arul.kumar_at_bt.com>
> wrote:
> > yes!
> >
> >
> >
> > -----Original Message-----
> > From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com]
> > Sent: 01 December 2004 11:20
> > To: Kumar,A,Arul,XGF3C C
> > Cc: oracle-l_at_freelists.org
> > Subject: Re: SET AUTOTRACE ON- not showing the actual stats.
> >
> > Are u Running as SYS ???
> >
> > On Wed, 1 Dec 2004 11:18:35 -0000, arul.kumar_at_bt.com=20
> > <arul.kumar_at_bt.com>
> > wrote:
> > > Dear DBAs,
> > >
> > > I could not see the actual statistics in a "SET AUTOTRACE ON"=20
> > > 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=3D3Dtrue;
> > >
> > > 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
> > >
> >
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 01 2004 - 05:27:01 CST
