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

Home -> Community -> Usenet -> c.d.o.server -> v$sql and v$session

v$sql and v$session

From: Thomas Sagen <thomas_at_sagen.org>
Date: Fri, 6 Oct 2000 00:31:12 +0200
Message-ID: <8o7D5.5223$Q43.74030@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 Thu Oct 05 2000 - 17:31:12 CDT












Original text of this message













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