Re: tkprof-output

From: Cisco <prsingh_at_cisco.com>
Date: 1997/02/27
Message-ID: <01bc2504$579f8420$e0d044ab@prsingh-pc.cisco.com>#1/1

First thing all the columns are important. It all depends on what inferences you want to draw.
Considering You are more interested in no of rows. You may be looking at query column for how many rows it needed for constructing the output.
Disk column to see was it reading all data from disk or some was available in cache.

The time columns gives you information like are jobs cpu intensive or may be system was
busy at that particular time.

Hope this helps

Pratap

Matthias Koepf <mak_at_kis.datagroup.de> wrote in article <33156247.183C_at_kis.datagroup.de>...
> Hi,
> we are trying to analyze our sql-Statements with the the
> Oracle-Trace-Facility and the tkprof-tool.
> Can anybody give me a description of how to read the results? We just
> use the count-column to get the number of Parse-, Execute- and
> Fetch-counts.
> Which other columns are important and which columns should be small to
> retrieve good performance?
>
> Here is an example of a tkprof-output:
>

>
> select "ALLMND_MANDANT","PPVEPS_EPSNR","PPVEPS_EPSSTAT"
> from
> "KIS"."P_PVEPS_EPISODE" where :EPPVEPS_EPSNR="PPVEPS_EPSNR" and
> :EALLMND_MANDANT="ALLMND_MANDANT" for update
>
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 1 0.00 0.08 0 0
> 0 0
> Execute 476 0.26 0.76 0 1428
> 476 0
> Fetch 476 0.04 0.19 0 0
> 0 476
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 953 0.30 1.03 0 1428
> 476 476
>
> Misses in library cache during parse: 0
> Optimizer goal: RULE
> Parsing user id: 8 (KIS)
>
> Rows Execution Plan
> ------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: RULE
> 476 FOR UPDATE
> 476 TABLE ACCESS (BY ROWID) OF 'P_PVEPS_EPISODE'
> 476 INDEX (UNIQUE SCAN) OF 'P_PVEPS_IND2_U' (UNIQUE)
>
>

>
> Thanks for your answers in advance
>
> Matthias Koepf
> =====================
> JenOptik Systemhaus
> E-Mail: mak_at_kis.datagroup.de
>
> PS:We are using Oracle 7.2.3 on HP-UX 10.
>
Received on Thu Feb 27 1997 - 00:00:00 CST