Re: DBMS_MONITOR
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 28 Dec 2011 07:44:07 -0800 (PST)
Message-ID: <33622dc1-3820-4f57-a995-07fe16ca24fc_at_t13g2000yqg.googlegroups.com>
On Dec 23, 3:44 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Fri, 23 Dec 2011 10:57:43 -0800, Charles Hooper wrote:
> > I believe that the session with the trace enabled through DBMS_MONITOR
> > must execute at least one SQL statement after tracing is enabled for the
> > session, before ORADEBUG will report that the trace is enabled.
>
> Confirmed. Charles you're great!
>
> --http://mgogala.byethost5.com
Date: Wed, 28 Dec 2011 07:44:07 -0800 (PST)
Message-ID: <33622dc1-3820-4f57-a995-07fe16ca24fc_at_t13g2000yqg.googlegroups.com>
On Dec 23, 3:44 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Fri, 23 Dec 2011 10:57:43 -0800, Charles Hooper wrote:
> > I believe that the session with the trace enabled through DBMS_MONITOR
> > must execute at least one SQL statement after tracing is enabled for the
> > session, before ORADEBUG will report that the trace is enabled.
>
> Confirmed. Charles you're great!
>
> --http://mgogala.byethost5.com
Yes, good job Charles.
I have seen problem posts related to dbms_monitor not tracing in the past but when replies were "it works for me" type replies. Next time I see such a post I will have to keep this behavior in mind.
- Mark D Powlel --