Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't get dbms_profiler to work

Re: Can't get dbms_profiler to work

From: Binley Lim <binley.lim002_at_winz.govt.nz>
Date: Wed, 23 Aug 2000 11:08:24 +1200
Message-Id: <10597.115306@fatcity.com>


The profiler tables have changed between 8.1.5 and 8.1.6 - you need to get the updated script from Quest for TOAD to properly under 8.1.6.

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
Received on Tue Aug 22 2000 - 18:08:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US