Re: Can't get dbms_profiler to work

Correction: download files from http://technet.oracle.com/ (my fingers had a mind of their own yesterday).

Chris

On 22 Aug 2000, at 13:12, cjgait_at_earthlink.net wrote:

> You can download the scripts you need (prvtpbp.sql and dbmspbp.sql) at
> http://www.oracle.com.
>
>
>
> On 21 Aug 2000, at 23:04, Leng Kaing wrote:
>
> > Hi Guys,
> >
> > Env: 8.1.5 and 8.1.6 on Solaris 2.7
> >
> > I've been wasting too much time on this so have now decided to ask for help.
> >
> > The story starts with turning on PL/SQL Profiling in TOAD for my 8.1.6
> > database. Found that the stats are 0 ie. no runs, nothing. So I went into
> > SQL*Plus and tried to turn on profiling manually:
> >
> > declare
> > x number;
> > begin
> > x := SYS.dbms_profiler.start_profiler('Leng');
> > pkg_db_stat.gather_stale;
> > sys.dbms_profiler.flush_data;
> > end;
> >
> >
> > There's nothing in the plsql_profiler tables. Time_statistics is set to
> > true.
> >
> > So thought I might try it out on 8.1.5. Guess what, no profload.sql and
> > proftab.sql in $ORACLE_HOME/rdbms/admin. Been searching metalink for them
> > but can't find. Have you got a copy of them to send to me? Or an ftp site I
> > can download from? not just ftp.oracle.com, but the full path please.
> > Thanks.
> >
> > So have you got the profiler working in both 8.1.5 and 8.1.6? How did you do
> > it? Any tips and tricks?
> >
> > TIA,
> >
> > Leng.
> >
> > -----------------------------------------------------------------------
> > Leng M Kaing
> > Email: leng.kaing_at_hancorp.com.au
> > Tel: 9843-8440
> > Fax: 9843-8590
> > -----------------------------------------------------------------------
> >
> >
> >
> > **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager.
> >
> > This footnote also confirms that this email message has been swept by
> > MIMEsweeper for the presence of computer viruses.
> >
> > www.mimesweeper.com
> > **********************************************************************
> > --
> > Author: Leng Kaing
> > INET: leng.kaing_at_hancorp.com.au
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> Regards,
> Chris Gait
> Arlington, VA
> --
> Author:
> INET: cjgait_at_earthlink.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 23 2000 - 10:12:00 CDT