RE: row source statistics in AWR

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Tue, 1 Jul 2014 11:17:11 -0700
Message-ID: <BLU179-W665DE4DA3AED2A5BD2410FEB070_at_phx.gbl>

I need the history of V$SQL_PLAN_STATISTICS I just checked the list of WRH$ tables and don't see it so I guess the answer is in the negative SQL> select table_name from dba_tables where table_name like 'WRH$%SQL%' order by 1;

TABLE_NAME------------------------------WRH$_SQLCOMMAND_NAMEWRH$_SQLSTATWRH$_SQLSTAT_BLWRH$_SQLTEXTWRH$_SQL_BIND_METADATAWRH$_SQL_PLANWRH$_SQL_SUMMARYWRH$_SQL_WORKAREA_HISTOGRAM

8 rows selected.
I also checked the definitions of DBMS_XPLAN.DISPLAY_CURSOR and DISPLAY_AWR. The second function does not accept the IOSTATS keyword. Iggy

Date: Tue, 1 Jul 2014 10:09:53 -0700
From: "" <dmarc-noreply_at_freelists.org> (Redacted sender "oratune_at_yahoo.com" for DMARC) Subject: Re: row source statistics in AWR To: iggy_fernandez_at_hotmail.com; chris.stephens_at_adm.com; oracle-l_at_freelists.org

Are you looking for DBA_HIST_ROWCACHE_SUMMARY?  David Fitzjarrell
Principal author, "Oracle Exadata Survival Guide"  

     On Tuesday, July 1, 2014 10:55 AM, Iggy Fernandez <iggy_fernandez_at_hotmail.com> wrote:     

 Does anybody know the answer to this question; that is, where are row source execution statistics stored in AWR?IggyFrom: Chris.Stephens_at_adm.comTo: oracle-l_at_freelists.orgDate: Thu, 17 Apr 2014 14:09:36 -0500Subject: 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 - 20:17:11 CEST