Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> REPOST: Re: Oracle tracing

REPOST: Re: Oracle tracing

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 31 Dec 2001 16:11:17 +0000
Message-ID: <5$--$$-$-%%-%%_%-$@news.noc.cabal.int>


Good to be back. Best wishes for the New Year to all.

Dan Morgan

mark wrote:

> 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

autocancel Received on Mon Dec 31 2001 - 10:11:17 CST

Original text of this message

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