Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I display the last SQL-Statements, which were running on the server

Re: How can I display the last SQL-Statements, which were running on the server

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 02 Nov 2002 23:44:17 +0100
Message-ID: <k6l8suol5aahqmibdagttst9rerrk0a5n2@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US