TKPROF: Release 9.2.0.4.0 - Production on Mon Jun 14 08:27:14 2004

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

Trace file: biasia_ora_10975.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
********************************************************************************

Error in CREATE TABLE of EXPLAIN PLAN table: BIUSER.prof$plan_table
ORA-00955: name is already used by an existing object

parse error offset: 20
EXPLAIN PLAN option disabled.
********************************************************************************

alter session set events '10046 trace name context forever , level 12'


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

Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer goal: CHOOSE
Parsing user id: 62

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 17.56 17.56
********************************************************************************

alter session set events '10053 trace name context forever, level 1'


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

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 62

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 4.44 4.44
********************************************************************************

select a11.TIME_PERIOD_IND_ID TIME_PERIOD_IND_ID,
a11.LEDGER_TYPE_ID LEDGER_TYPE_ID,
a11.FISCAL_PERIOD_ID FISCAL_PERIOD_ID,
sum(a11.PL_PERIOD_AMT_LOCAL) WJXBFS1
from AGGR_PL_FISCAL_PERIOD a11,
LU_ACCOUNT a12,
LU_ACCOUNT_LOD6 a13
where a11.ACCOUNT_ID = a12.ACCOUNT_ID and
a12.LOD6_ID = a13.LOD6_ID
and (a11.FISCAL_PERIOD_ID between TO_CHAR(ADD_MONTHS(TO_DATE( '200405','yyyymm'),-11),'yyyymm') and TO_CHAR(ADD_MONTHS(TO_DATE( '200405','yyyymm'),-0),'yyyymm')
and a11.LEDGER_TYPE_ID in (1877)
and a11.TIME_PERIOD_IND_ID in (1)
and a13.LOD6_OBJECT_ACCOUNT_SRCCD = '63900'
and ((a12.BUSINESS_UNIT_ID in (156569, 156590, 156591, 156947, 156948, 156949, 156950, 156951)
and a12.COMPANY_ID in (3023))
or (a12.BUSINESS_UNIT_ID in (156571, 156989, 156990, 156991, 157007, 157008, 157009, 157010)
and a12.COMPANY_ID in (3023))
or (a12.BUSINESS_UNIT_ID in (156607, 157011, 157027, 157028, 157029, 157030, 157031, 157047)
and a12.COMPANY_ID in (3023))
or (a12.BUSINESS_UNIT_ID in (156570, 156967, 156968, 156969, 156970, 156971, 156987, 156988)
and a12.COMPANY_ID in (3023))
or (a12.BUSINESS_UNIT_ID in (157514, 157497, 157498, 157499, 157500, 157501, 157512, 157513)
and a12.COMPANY_ID in (3023))
or (a12.BUSINESS_UNIT_ID in (156568, 156608, 156609, 156610, 156611, 156587, 156588, 156589)
and a12.COMPANY_ID in (3023))))
group by a11.TIME_PERIOD_IND_ID,
a11.LEDGER_TYPE_ID,
a11.FISCAL_PERIOD_ID

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.12 0.13 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 14.60 15.24 0 1340441 0 7
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 14.72 15.38 0 1340441 0 7

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 62

Rows Row Source Operation
------- ---------------------------------------------------
7 SORT GROUP BY (cr=1340441 r=0 w=0 time=15247163 us)
357 HASH JOIN (cr=1340441 r=0 w=0 time=15244187 us)
14893 TABLE ACCESS BY INDEX ROWID LU_ACCOUNT_LOD6 (cr=3070 r=0 w=0 time=82395 us)
14893 INDEX RANGE SCAN LOD6_OBJ_IDX_01 (cr=49 r=0 w=0 time=12499 us)(object id 42908)
13293 NESTED LOOPS (cr=1337371 r=0 w=0 time=15115938 us)
391755 TABLE ACCESS BY INDEX ROWID AGGR_PL_FISCAL_PERIOD (cr=162104 r=0 w=0 time=2573807 us)
391755 BITMAP CONVERSION TO ROWIDS (cr=538 r=0 w=0 time=218600 us)
190 BITMAP INDEX RANGE SCAN AGGR_PL_FISCAL_INDX1 (cr=538 r=0 w=0 time=13603 us)(object id 49228)
13293 TABLE ACCESS BY INDEX ROWID LU_ACCOUNT (cr=1175267 r=0 w=0 time=11337688 us)
391755 INDEX UNIQUE SCAN SYS_C0014576 (cr=783512 r=0 w=0 time=3733693 us)(object id 42896)