Re: v$sql and v$session

From: Dogan Cibiceli <dogan_at_mediaone.net>
Date: Sat, 07 Oct 2000 04:37:57 GMT
Message-ID: <FMxD5.34776$tn.710193@typhoon.ne.mediaone.net>

v$sqlarea

"Thomas Sagen" <thomas_at_sagen.org> wrote in message news:8o7D5.5223$Q43.74030_at_news1.online.no...
> Is there any way to find out witch statement that has been run by a given
> sid?
> I can't find any sqladdress or hashvalue that connect this 2 views. (v$sql
> and v$session)
>
> I have installed x$views also. I found that x$kglcursor is almost the same
> as v$sql.
>
> Someone have any clue?
>
> *T*
> Sagen Consulting
>
>
>
Received on Fri Oct 06 2000 - 23:37:57 CDT