Re: How to see the last sql executed by a session that is finished?

Check this two tables: v$sqltext and v$open_cursor,

anyway,oracle session manager at http://www.wangz.net can help you do this on the fly.

"pako" <pako73_at_wanadoo.es> wrote in message news:<b%it8.723684$EH2.2863194_at_telenews.teleline.es>...
> Hi, all!
>
> How to see the last sql executed by a session that is finished?
>
> I have a aplicattion that open a session,
>
> thown a sql instruccion and close the session.
>
> What view of user SYS have this instruccion?
>
> I only can see this instruccion when the session is closed.
>
> Thanks
Received on Wed Apr 17 2002 - 06:26:25 CEST