sql trace and complex bind variables
- From: Boris Dali <boris_dali@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 6 Apr 2004 15:26:26 -0400 (EDT)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
