tkprof-output

From: Matthias Koepf <mak_at_kis.datagroup.de>
Date: 1997/02/27
Message-ID: <33156247.183C@kis.datagroup.de>#1/1

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