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

From: Bass Chorng <bchorng_at_yahoo.com>
Date: 12 Nov 2002 12:21:58 -0800
Message-ID: <bd9a9a76.0211121221.32bcb5b5@posting.google.com>

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. Received on Tue Nov 12 2002 - 14:21:58 CST