REPOST: Re: Oracle tracing

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 31 Dec 2001 16:11:17 +0000
Message-ID: <5$--$$-$-%%-%%_%-$_at_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

  • WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!dfw.uu.net!sea.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.marketplace Subject: cmsg cancel <3C308E24.6CCA4004_at_exesolutions.com> Control: cancel <3C308E24.6CCA4004_at_exesolutions.com> Date: Tue, 1 Jan 2002 23:54:27 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3C308E24.6CCA4004_at_exesolutions.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009941837 18263 166.102.15.34 (2 Jan 2002 03:23:57 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 03:23:57 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40272499

autocancel Received on Mon Dec 31 2001 - 17:11:17 CET

Original text of this message