Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie trace question
which explains why I could not find the sql file... Thnx for the addition
-- Frank <oratune_at_aol.com> schreef in berichtnieuws 8t23nq$gb8$1_at_nnrp1.deja.com...Received on Tue Oct 24 2000 - 07:34:22 CDT
> 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.
![]() |
![]() |