Re: RE: Norbert Debes - trace file analyser

On 12 Aug 2011 11:23, "Dunbar, Norman (Capgemini)" < norman.dunbar.capgemini_at_environment-agency.gov.uk> 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 ...

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