sql trace and complex bind variables

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Tue, 6 Apr 2004 15:26:26 -0400 (EDT)
Message-ID: <20040406192626.42772.qmail@web41403.mail.yahoo.com>

We are looking into capturing (and potentially replaying) a workload generated by an off-the-shelf application. Among other problems the one that stands out is the bind variables that are user
defined/abstract datatypes. The way it appears in the raw trace is something like this:

Dump of memory from 0x800003FBC005B698 to 0x800003FBC005B6A8

800003FBC005B690                   80000001 000390E0  
       [........]
800003FBC005B6A0 800003FB C005B6A8                   
[........]

bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=800003ff00000000 size=24 offset=0

bfp=800003fb000682a0 bln=22 avl=02 flg=05

Is there any way to get a more meaningful representation of this structure?

Thanks,
Boris Dali.

Post your free ad now! http://personals.yahoo.ca

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Apr 06 2004 - 14:22:48 CDT