Oracle tracing
From: Sergei Gofman <senq_at_innocent.com>
Date: Wed, 19 Dec 2001 16:53:45 +0200
Message-ID: <9vq9ls$g0m_at_news.or.intel.com>
Hi.
[Quoted] [Quoted] 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 - 15:53:45 CET
Date: Wed, 19 Dec 2001 16:53:45 +0200
Message-ID: <9vq9ls$g0m_at_news.or.intel.com>
Hi.
[Quoted] [Quoted] 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 - 15:53:45 CET