Re: RE: Norbert Debes - trace file analyser
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: "Dunbar, Norman (Capgemini)" <norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2011 13:05:55 +0100
IIRC its an 11.2.0.2
On 12 Aug 2011 11:23, "Dunbar, Norman (Capgemini)" <
norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Thanks Niall,
>> ...
>> The solution was to pass the cached cursor handle (which probably is
the address) through
>> and ...
I'm not seeing that in my trace file! The sql text is being output for
every parse, hard or soft:
PARSING IN CURSOR #140136345356328 len=360 dep=0 uid=2995 oct=2 lid=2995
tim=1313055014330192 hv=3633137198 ad='7254d378' sqlid='6jf6bsmc8ujjf'
INSERT INTO "LW_MEASURED" ("RUN_ID", ...) VALUES (:V00001,...)
END OF STMT
...
PARSING IN CURSOR #140136345356328 len=360 dep=0 uid=2995 oct=2 lid=2995
tim=1313055015833694 hv=3633137198 ad='7254d378' sqlid='6jf6bsmc8ujjf'
INSERT INTO "LW_MEASURED" ("RUN_ID", ...) VALUES (:V00001,...)
END OF STMT
And so on.
Cheers,
Norm.
Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Team (EA)
Internal : 7 ...
Other related posts:
