Re: Interpreting v$session_event

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Wed, 20 Apr 2005 20:03:21 +0800
Message-ID: <7064689905042005031c0042f@mail.gmail.com>

You got all the columns zero? set TIMED_STATISTICS=3DTRUE. It won't be a burden to the DB now. And read Oracle Wait Interface ^_^. I'm just reading it.

On 4/20/05, K Gopalakrishnan <kaygopal_at_yahoo.com> wrote:
> John:

>=20

> I think you have not set the timed_statistics=3Dtrue. Set this by using
> ALTER SYSTEM SET TIMED_STATISTICS=3DTRUE;
> and query the session_wait. You will get the real numbers.

>=20

> Have a nice day !!
> ------------------------------------------------------------
> Best Regards,
> K Gopalakrishnan,
> Co-Author: Oracle Wait Interface: Oracle Press 2004.
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://blog.csdn.net/

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 20 2005 - 08:07:32 CDT