Re: v$session_event in 9i, is it reported differently ?

Known bug.

Use the v$session.sid - 1 = v$session_event.sid

Fixed in version 10.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Bass Chorng wrote in message ...


>I noticed in 9i, Oracle behaves differently with v$session_event.

>

>In pre-9i, I can find out every event wait, as long as the SQL is

>completed, in v$session_event of certain sid. But it no longer

>does that in 9i. Does anybody know if the behaviour changed ?

>

>For example, if I do a select count(*) of a table, then I query

>v$session_event of my sid, I will see a 'db file scattered read'

>showing in v$session_event immediately.

>

>With 9i, that 'db file scattered read' no long shows in

>v$session_event.

>

>I did not check v$session_wait to see if I had a full table

>scan there, but I am assuming for select count(*), oracle

>*HAS* to do a full table scan.

>

>Does anybody know why ? This behavior basically makes v$session_event

>useless because it is not reflecting the wait events.