Re: 10046/10079 Tracing understanding - SOLVED

Thanks Nuno.  

The original tests were using 10.1 java drivers against a 9.2.0.6 database. However, I performed the tests against a 10.1.0.3 database just to be sure and I got the same results.  

• Brian

Nuno Souto <dbvision_at_iinet.net.au> wrote: Quoting Brian Wisniewski
:

> When it was called from java it was definitely returing the entire 32K when
> the OUT field was CHAR. When I called it from another PL/SQL pgm via sqlplus
> @.. it did NOT return the entire contents.
>
> I'm not sure if this is a thin driver issue or what but I'm still researching
> this. I'm going to try the OCI driver next and see if that makes a
> difference or not.
>
> That was fun to track down in a twisted sort of way.
>

Excellent work, Brian. Thanks for sharing this, might actually explain many "weird" performance problems.
I'm curious if this would happen as well if the parameter being passed was a type with CHAR attributes inside? I'm quite sure we've used CHAR in some of our types in the past but because we always used the type itself rather than discrete fields we never hit the problem. Must try this out. You were using 10.1, right?

-- 
Cheers
Nuno Souto
from sunny Sydney
--
http://www.freelists.org/webpage/oracle-l

		
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Find what you need with new enhanced search. Learn more.
--
http://www.freelists.org/webpage/oracle-l