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

Re: Oracle tracing

From: mark <mark_brehmen_at_yahoo.com>
Date: 25 Dec 2001 01:48:05 -0800
Message-ID: <fa4781e4.0112250148.42e2a628@posting.google.com>


Welcome back Oracle Comrade Daniel !!!!!!

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C23C1AF.1D517E2B_at_exesolutions.com>...
> 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 Tue Dec 25 2001 - 03:48:05 CST

Original text of this message

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