Re: Oracle tracing
From: Cliff Dabrowski <cliffdw_at_my-deja.com>
Date: Fri, 28 Dec 2001 16:27:30 -0500
Message-ID: <3c2ce460$1_at_172.22.1.229>
Date: Fri, 28 Dec 2001 16:27:30 -0500
Message-ID: <3c2ce460$1_at_172.22.1.229>
Take a look at the SQL Viewer component of Compuware DBPartner. http://www.compuware.com/products/numega/dbpartner/index.htm
"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 Fri Dec 28 2001 - 22:27:30 CET