Re: Interpreting v$session_event

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 20 Apr 2005 02:10:16 -0700 (PDT)
Message-ID: <20050420091017.26132.qmail@web30902.mail.mud.yahoo.com>

John:

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

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 Received on Wed Apr 20 2005 - 05:14:25 CDT