RE: Can't get dbms_profiler to work

From: Leng Kaing <leng.kaing_at_hancorp.com.au>
Date: Thu, 24 Aug 2000 12:23:34 +1000
Message-Id: <10598.115436@fatcity.com>

All,

I have been there (metalink) all day. Can't find it!! Have you tried finding it yourself? I've since logged a call with Oracle support who tells me to simply get it off a winNT box! Doh! I'm on Unix so I'll just walk over to a non-existent NT box and pull it out.

Anyhow, I've managed to get it going on 8.1.6 by re-executing profload.sql as internal, and toadprofiler.sql as system.

Waiting on Oracle to give me a version of profiler for 8.1.5.

Thanks anyhow,
Leng.

From: cjgait_at_earthlink.net
Date: Tue, 22 Aug 2000 14:31:51 -0400
Subject: 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.

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 Received on Wed Aug 23 2000 - 21:23:34 CDT