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

In article <62e59750.0211030714.5214490f_at_posting.google.com>, oliver_at_demus-online.de says...
>
>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
>

otn.oracle.com -> documentation

has tons of documentation. The V$ tables are documented in the Oracle Reference Guide..

http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96536/toc.htm

for example

>
>
>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

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp