Re: Oracle tracing

From: danisment <danisment_at_yahoo.com>
Date: 3 Jan 2002 09:29:20 -0800
Message-ID: <2c78cfac.0201030929.5d125a30@posting.google.com>

Hello,

itrprof can do what you ask. it's web based and free at http://www.unal-bilisim.com/products/itrprof/itrprof.html

"Sergei Gofman" <senq_at_innocent.com> wrote in message news:<9vq9ls$g0m_at_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 Thu Jan 03 2002 - 11:29:20 CST