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

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_PROFILER package

Re: DBMS_PROFILER package

From: <michael_bialik_at_my-deja.com>
Date: Fri, 11 Feb 2000 14:46:13 GMT
Message-ID: <8817bk$9hq$1@nnrp1.deja.com>


Hi.

In article <87vq53$9t9$1_at_nnrp1.deja.com>,   davehk_at_my-deja.com wrote:
Two questions (three,actually)

  1. is DBMS_PROFILER the best way to measure the gross performance of a packaged application? No. As I see it it's additional way to tune PL/SQL code : It enables to quantify time spent on PL/SQL code execution ( vs SQL_Trace and TKPROF that may be used to tune SQL statements only ).
  2. how does it compare to SQL_Trace and TKPROF? It completes these utilities.
  3. How can I get hold of DBMS_PROFILER? It's a part of oracle supplied packages of Oracle 8i ( together with DBMS_SQL, DBMS_ALRET, DBMS_PIPER, etc. ).

>
> Castrate me to reply.
> Thx
> dhk_at_balls.clarent.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 08:46:13 CST

Original text of this message

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