Re: Can't get dbms_profiler to work

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).
Received on Tue Aug 22 2000 - 13:31:51 CDT