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 -> Re: Is thjere a way to find all sql satements run by a session

Re: Is thjere a way to find all sql satements run by a session

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 25 Mar 2006 01:58:06 GMT
Message-Id: <pan.2006.03.25.01.58.06.70492@sbcglobal.net> 





On Fri, 24 Mar 2006 14:12:39 -0800, dbaplusplus wrote:



> What I am looking for is to look at V$sql views  and find various types

> of sql statements executed, how long they take etc.




V$SQL doesn't support that. As soon as there is need for space in shared
pool, old SQL is purged out of V$SQL. You can use DBA_HIST views in 10g,
only you have to pay for it. In 9.2 there is no way to do that.


-- 
http://www.mgogala.com


Received on Fri Mar 24 2006 - 19:58:06 CST












Original text of this message













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