One place to look for the peeked binds in 10.2 is
in v$sql_plan line 0, column other_xml.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -----
> Date: Fri, 9 Feb 2007 13:05:11 -0700
> From: "John Darrah" <darrah.john_at_gmail.com>
> Subject: bind_data in v$sql
>
> A while back I saw a post asking about the bind_data column in v$sql. The
> poster wanted to know how to interpret the RAW data in the column. At first
> I didn't see the point since there is also a V$sql_bind_capture view that
> has all the columns in plain text but I was curious about the structure of
> the column and started digging into it. I quickly stumbled on a procedure
> that translates this raw string called dbms_sqltune.extract_binds which made
> manually translating this data even less necessary but at that point I was
> having fun pulling the data out.
>
> I've determined how the columns marked with a "*" are stored. Does anyone
> know how to interpret the rest of this string? Also, does anyone know if
> the binds that were peeked during a hard parse are stored anywhere? It
> appears that the bind_data string gets refreshed periodically by oracle,
> overwriting the originals.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 10 2007 - 04:56:52 CST