RE: row source statistics in AWR
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Jul 2014 19:01:01 +0000
I don't think they are stored.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Iggy Fernandez [iggy_fernandez@xxxxxxxxxxx]
Sent: 01 July 2014 17:54
To: Chris.Stephens@xxxxxxx; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: row source statistics in AWR
Does anybody know the answer to this question; that is, where are row source
execution statistics stored in AWR?
Iggy
________________________________
From: Chris.Stephens@xxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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!
Other related posts:
