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

Thanks,
I am a Newbie, can you tell me, where I can find a documentation or list of all these v$-Tables? Some good books about that?

Thanks
Oliver

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<k6l8suol5aahqmibdagttst9rerrk0a5n2_at_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 Sun Nov 03 2002 - 09:14:48 CST