Re: monitor sql sentences

From: dombrooks <dombrooks_at_hotmail.com>
Date: 11 Jan 2007 12:21:34 -0800
Message-ID: <1168546894.754103.293300@p59g2000hsd.googlegroups.com>

Shinya Koizumi wrote:
> How to monitor the executed sql sentence from GUI?
>
> Is it possible?
>
> SK

Hi,

This is possible up using extended trace provided you can identify the session(s).
Depending on the number of sessions in your database, you could set the relevant tracing across the whole database or you could use an after logon trigger to isolate only session connecting as a certain username or a certain application or possibly even using a certain IP I suppose (using USERENV SYS_CONTEXT).

Cheers,
Dominic Received on Thu Jan 11 2007 - 14:21:34 CST