Re: DBA_HIST_SQLSTAT
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Mon, 26 Nov 2012 09:17:29 -0800 (PST)
Message-ID: <1353950249.52704.YahooMailNeo_at_web161302.mail.bf1.yahoo.com>
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
Date: Mon, 26 Nov 2012 09:17:29 -0800 (PST)
Message-ID: <1353950249.52704.YahooMailNeo_at_web161302.mail.bf1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 26 2012 - 18:17:29 CET