RE: row source statistics in AWR

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Tue, 1 Jul 2014 09:54:15 -0700
Message-ID: <BLU179-W46559800EB1B952FC05058EB070_at_phx.gbl>

Does anybody know the answer to this question; that is, where are row source execution statistics stored in AWR? Iggy

From: Chris.Stephens_at_adm.com
To: oracle-l_at_freelists.org
Date: Thu, 17 Apr 2014 14:09:36 -0500
Subject: row source statistics in AWR

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!

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 01 2014 - 18:54:15 CEST