Re: "latest sql"?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 14 Dec 2002 08:03:09 +0100
Message-ID: <0sllvugq37tjrfkgc1fb2r7u5vfur0vqb4@4ax.com>

On Sat, 14 Dec 2002 02:57:48 GMT, CoolDude <nospam_at_nospam.it> wrote:

>Question: how to find out the latest sql executed on a given session id?
>assuming audit is turned off.
>
>Thanks!
>
>-cd

sql_hash_value and sql_address in v$session point to (among others) v$sqlarea and v$sqltext_with_newlines.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Dec 14 2002 - 01:03:09 CST