Re: Newbie trace question

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.