Re: how to get the most recent sqlstatement

The tool hora 3 offers:

• the session page. It shows all session connected to the server and the actual sql statement which is performed by the session.
• the SQL Area tabregister on the SGA page which shows all sql statements currently in the SGA.

You can download a free trialversion of Hora 3 from http://www.keeptool.com.

Best regards Jan Dieckmann

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 - 10:35:02 CST