Oliver Demus wrote:
> 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
>
Go to
http://tahiti.oracle.com and pick your Oracle version (hopefully
it's 8i or 9i). You'll see an entry for the Master Index. Click on the
'V' to see all the V$ views.
>
>
> 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 Mon Nov 04 2002 - 12:11:55 CST