Re: "read by other session" scenario

  • From: Karl Arao <karlarao@xxxxxxxxx>
  • To: fmhabash <fmhabash@xxxxxxxxx>
  • Date: Thu, 22 Jul 2010 15:28:38 +0800

Yes that makes the SQL_ID 7kugzf4d2vbbm do 80,604 LIOs per execute...

Thanks for sharing these scenarios.. :)
As far as ASH vs. AWR, I've seen it happening under 2 scenarios ...
1) session that initiated query did not list as 'active' and therefore
did not show in ash. I've seen queries run and show in awr for session
that posted an idle wait event sql*net.
2) sessions executing plsql code where queries spawned from the block
show in awr but never in ash.

I also got a response that it's possible to only see the recursive
statements as the top statements in the ASH reports because they are
the ones doing most of the working and the waiting...

Karl Arao

Other related posts: