Re: Newbie trace question

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 24 Oct 2000 16:15:42 +0100
Message-ID: <8t4934$khq$1@soap.pipex.net>

Or DBMS_SYSTEM

I seem to be having a few too many head fits at the mo'. Thing is I'm sure I also answered this exact same question with the correct package name the same day as this piece of incorrect advice.

apologies

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<oratune_at_aol.com> wrote in message news:8t23nq$gb8$1_at_nnrp1.deja.com...


> In article <39F48D15.CD0448A1_at_home.nl>,

>   frank <fbortel_at_home.nl> wrote:

> > <snip>

> >

> > >

> > > This would be an excellent suggestion however I cannot find this in

> > > DBMS_UTILITY as it is installed on our instances (8.1.6).  Am I

 missing


> > > something?

> > >

> > > --

> > > David Fitzjarrell

> > > Oracle Certified DBA

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> > I'm sure I am: you *cannot* find it, because it *is* installed?

> > Contradictio in terminis?

> > Had this once more this week: english is not my native tongue.

> > Anyway: dbmsutil is called from catproc, so you'd better

> > have it. set_sql_trace_in_session is wrapped in prvtutil.plb

> >

> > Frank

> >

> >

>


> However, it is NOT in DBMS_UTILITY, but in DBMS_SESSION.  This package

> is created from the dbmsutil.sql and prvtutil.plb scripts, wherein lies

> the confusion.

>


> --

> David Fitzjarrell

> Oracle Certified DBA

>
>


> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Tue Oct 24 2000 - 10:15:42 CDT