Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: In a BIND again...
Bind values are listed, in their entirety, in the raw trace file (in the
udump directory).
You should see a section headed BINDS #<cursor number> for each cursor.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe
Sent: Friday, October 12, 2007 11:55 AM
To: oracle-l_at_freelists.org
Subject: In a BIND again...
OK. Now I've got a 10046, level 12 trace file and I'm still having trouble seeing the values of my bind variables. Or so I think. If I'm reading this correctly, there are 8 bind variables in my SQL statement. The Trace Analyzer output says there are 6 and only displays 5.
If it matters, 9.2.0.6 Standard Edition on Red Hat.
thanks,
-joe
The current SQL statement is:
select
distinct insured1_.accountId as col_0_0_,
insured1_.objectId as col_1_0_, insured1_.party_fullName as col_2_0_, insured1_.state_Id as col_3_0_, insured1_.prod_number as col_4_0_,
insured1_.transaction_Id<>:1 and insured1_.purged=:2 and insured1_.deleted=:3 and quote0_.deleted=:4 and
insured1_.accountId , insured1_.objectId , insured1_.party_fullName , insured1_.state_Id , insured1_.prod_number , insured1_.effectiveDate , insured1_.modified_time , insured1_.product
And the relevant section of the html output is:
Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)
Exec
Line Exec Ranking 6 Values (according to position within SQL) 5703: 4 172 0 0 0 0 9041: 2 172 0 0 0 0 15195: 3 172 0 0 0 0 16700: 1 172 0 0 0 0
I only see 5 values listed after the "Exec Ranking" is each row above.
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 12 2007 - 12:05:11 CDT
![]() |
![]() |