Re: how to get the most recent sqlstatement

Did you try the v$sqlarea table. It's documented in the reference manual and it basically contains a view into the cache of SQL statements in the SGA. I don't know how to get to the bind values, though there are also some v$ tables with that information I believe.

I'm not too sure about using it from a trigger, I'm much more prone to data mine it looking for performance problems -

"Maija-Leena Kangasmäki" wrote:

> Hi,
>
> is there a way to get the most recent sqlstatement ?
>
> I'm debugging an error that updates too many rows in the database but I
> don't know the program which does it. Is there any way to find out the
> sqlstatement in table trigger ? Any other suggestions ? I tried to use
> audit and saving new and old values to another table but that doesn't
> tell much.
>
> Regards,
>
> Maija-Leena
Received on Tue Mar 09 1999 - 07:45:57 CST