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

[<arul.kumar@xxxxxx>]

Thanks Ganesh!

I connected as system and it worked.

Have a nice day!!


-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx]=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@xxxxxx <arul.kumar@xxxxxx>
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@xxxxxxxxx]
> 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@xxxxxx=20
> <arul.kumar@xxxxxx>
> wrote:
> > yes!
> >
> >
> >
> > -----Original Message-----
> > From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx]
> > Sent: 01 December 2004 11:20
> > To: Kumar,A,Arul,XGF3C C
> > Cc: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxx=20
> > <arul.kumar@xxxxxx>
> > 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

Other related posts:

SET AUTOTRACE ON- not showing the actual stats.

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

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