You might examine V$SQL_BIND_DATA.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 9/1/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> Does anyone know if there is a way to find out what values are in effect
> for the bind variables of a currently running query?
> I know how to find bind variable values with a trace, but that requires
> you to start a trace prior to the parsing of the query and it's too late for
> that.
> Thanks,
> Brandon
>