TKPROF: Release 9.2.0.6.0 - Production on Thu Jan 13 11:30:20 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Trace file: sy2ku2_ora_18201.trc
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing 
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************

SELECT LBR.ID 
FROM
 LEDGER_BODY_ROLES LBR WHERE LBR.LBR_LBY_ID = (SELECT LBR1.LBR_LBY_ID FROM 
  LEDGER_BODY_ROLES LBR1 WHERE LBR1.ID = :B2 ) AND LBR.LBR_TYPE = :B1 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute  10694      2.02       2.23         79      42776          0           0
Fetch    10694      0.30       0.19         49      42776          0       10694
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    21388      2.32       2.43        128      85552          0       10694

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8809     (recursive depth: 2)

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                       128        0.01          0.03
  latch free                                      2        0.00          0.00
********************************************************************************

SELECT CPR.ID, CPR.PCT_CODE 
FROM
 PRODUCTS CPR, PRODUCTS BPT WHERE CPR.PCT_CODE IN ('CAPTAIN', 'CTAKER') AND 
  BPT.ID = :B1 AND CPR.ID = BPT.BPT_PCT_ID


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute   6095      0.67       0.68          0          0          0           0
Fetch     6095      0.10       0.11          0      24380          0        5569
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    12190      0.77       0.79          0      24380          0        5569

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 8809     (recursive depth: 2)

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  latch free                                      1        0.00          0.00



********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        0      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file scattered read                    3649310        0.03         78.95
  db file sequential read                   3511979        0.05         43.63
  latch free                                      4        0.00          0.00


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute  16789      2.69       2.91         79      42776          0           0
Fetch    16789      0.40       0.31         49      67156          0       16263
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    33578      3.09       3.23        128     109932          0       16263

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                       128        0.01          0.03
  latch free                                      3        0.00          0.00

    2  user  SQL statements in session.
    0  internal SQL statements in session.
    2  SQL statements in session.
********************************************************************************
Trace file: sy2ku2_ora_18201.trc
Trace file compatibility: 9.02.00
Sort options: default

       1  session in tracefile.
       2  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       2  SQL statements in trace file.
       2  unique SQL statements in trace file.
 7294266  lines in trace file.