Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I display the last SQL-Statements, which were running on the server
On 2 Nov 2002 14:06:17 -0800, oliver_at_demus-online.de (Oliver Demus)
wrote:
>Hi guys,
>can I display the last SQL-Statements which were running on the
>server? These statements were sent by a program, and I have to know
>the order of these statements (e.g.:which insert was in wich table).
>
>Thanks in advance
>Oliver
session specific info is in
v$open_cursor
The address and hash_value column point to v$sqltext_with_newlines
This contains the actual statement.
v$sqlarea contains accumulated execution info.
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Nov 02 2002 - 16:44:17 CST
![]() |
![]() |