Re: DBA_HIST_SQLSTAT

  • From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
  • To: free <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Nov 2012 09:17:29 -0800 (PST)

Below statement in my previous post is not correct:
"If multiple child cursors exist with the same execution plan, 
then awr only report the stats for the most recent child cursor."
 
awr maintains only one record for multiple child cursors of a given sql_id if 
the plan_hash_value is same for all of them, it can be seen in 
X$KGLCURSOR_CHILD_SQLIDPH.kglobt03, and all sql metrics like executions, 
buffer_gets, etc. are summed up.
 
Thanks,
Sai.
http://sai-oracle.blogspot.com
--
//www.freelists.org/webpage/oracle-l


Other related posts: