Re: Oracle tracing

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
Received on Mon Dec 31 2001 - 10:11:17 CST