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

Oracle tracing

From: Sergei Gofman <senq_at_innocent.com>
Date: Wed, 19 Dec 2001 16:53:45 +0200
Message-ID: <9vq9ls$g0m@news.or.intel.com> 





Hi.


I need a mechanism which allows me to get information about the excecuted
queries in Oracle DB "on the fly" (in realtime). Alternatively, if you know
a way to get trace of SQL queries with timestamps (when the query started
execution) and the duration that the query took, that would also be good.
The SQL_TRACE gives me only the queries, not the time when they started
executing.


Thanks in advance,


Sergei
Received on Wed Dec 19 2001 - 08:53:45 CST












Original text of this message













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