row source statistics in AWR

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Thu, 17 Apr 2014 14:09:36 -0500
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05006FF46E582_at_JRCEXC1V1.research.na.admworld.com>



I'm having trouble figuring out where row source statistics are stored in AWR. I've gone through the reference doc and can't find anything under DBA_HIST* other than DBA_HIST_SQL_PLAN which only has the execution plans + optimizer estimates. I swear I've seen them displayed through dbms_xplan.display_awr but I can't get them to display calling that function either. I've taken snapshots with flush_level = 'ALL' and executed SQL in between those snapshots with '/*+ gather_plan_statistics */ and statistics_level = 'ALL' at session and system level with no luck.

Are rowsource statistics (specifically LIO's and a-rows for every operation in a plan) optionally stored in AWR and if so, where?

Thanks!

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 17 2014 - 21:09:36 CEST

Original text of this message