Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to translate bind_data from v$sqlarea_plan_hash (and other related views)?

How to translate bind_data from v$sqlarea_plan_hash (and other related views)?

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Mon, 1 May 2006 10:46:09 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D40A@ADMINMAIL1.ui.uillinois.edu>


The documentation is rather flimsy on this column. I learned a lot when I read that the description of "bind_data" is "Bind data". Well blow me down! =)
Does anyone know how this RAW value is formatted? Or, if there is a better way to grab bind variables from the data dictionary, please let me know.

Thanks much,

charles schultz
oracle dba
aits - adsd
university of illinois

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 01 2006 - 10:46:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US