Re: "Row Source Operation" section in TKP

  • From: Lothar Flatz <l.flatz@xxxxxxxxxx>
  • To: Stefan Koehler <contact@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 16 Sep 2016 16:07:27 +0200

Hey Stefan,

sure. There is the chance however that binds are already in the existing trace. Then we don't need more tracing .. ;-)

Regards

Lothar
On 16.09.2016 16:03, Stefan Koehler wrote:

Hey Lothar,

What you need is the statistic of the execution that went wrong. It would be 
good to have the bind variables for that execution.
You get this statistic, if you dump with "all_executions" and the SQL is only 
executed 27 times in this case - so no problem. Regarding binds you are
right - that's the reason why i have suggested the option 
"plan_stat=all_executions,wait=true,bind=true" :)

Best Regards
Stefan Koehler

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

Lothar Flatz <l.flatz@xxxxxxxxxx> hat am 16. September 2016 um 15:56 
geschrieben:

Well, I would say "who cares which executions stats it is?".
What you need is the statistic of the execution that went wrong. It
would be good to have the bind variables for that execution.
Given that, you can repeat your bad execution any time and create
runtime stats.

Regards

Lothar


--




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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2016