Re: Oracle tracing
From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 21 Dec 2001 23:11:43 +0000
Message-ID: <3C23C1AF.1D517E2B_at_exesolutions.com>
Date: Fri, 21 Dec 2001 23:11:43 +0000
Message-ID: <3C23C1AF.1D517E2B_at_exesolutions.com>
[Quoted] Buy Tom Kyte's book "Expert One-On-One Oracle".
Daniel Morgan
Sergei Gofman wrote:
> 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 Sat Dec 22 2001 - 00:11:43 CET