RE: "Row Source Operation" section in TKP

Hey Amir,
just do it manually :-)

As you already have traced once you got the corresponding client_id, module and action information in trace file or just enable SQL trace for this particular SQL ID with help of "new" kernel debug & diagnostics infrastructure.

SQL> alter system set events 'sql_trace[SQL: <SQL_ID>] plan_stat=all_executions,wait=true,bind=true';  

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> "Hameed, Amir" <Amir.Hameed_at_xerox.com> hat am 16. September 2016 um 15:45 geschrieben:
>
> Thanks Stefan. The statistics were enabled by using the concurrent program page of Oracle E-Business Suite with Waits option. I am not 100% sure
> whether it executes 10046 or DBMS_MONITOR under the hood to actually enable statistics.
>
> -----Original Message-----
> From: Stefan Koehler [mailto:contact_at_soocs.de]
> Sent: Friday, September 16, 2016 9:39 AM
> To: Hameed, Amir <Amir.Hameed_at_xerox.com>
> Subject: Re: "Row Source Operation" section in TKP
>
> Hey Amir,
>
> > So, it seems that the Row Source Operation section in TKP only reports
> > statistics from the first run? I was under the impression that this section shows cumulative value from all executions?
>
> It depends on how you enabled the extended SQL trace. Exemplary based on DBMS_MONITOR
> (http://docs.oracle.com/database/121/ARPLS/d_monitor.htm#ARPLS67178): plan_stat - Frequency at which we dump row source statistics. Value should be
> 'NEVER', 'FIRST_EXECUTION' (equivalent to NULL) or 'ALL_EXECUTIONS'
>
> Please check out Christian's blog post for the different row source statistic options, if you have enabled SQL trace be event and level:
> https://antognini.ch/2012/08/event-10046-full-list-of-levels/
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK

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