/local/AGOLFRS1/admin/udump/ora_21660_agolfrs1.trc
Oracle8i Enterprise Edition Release 8.1.7.1.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.1.0 - 64bit Production
ORACLE_HOME = /appl/oracle/product/8.1.7
System name:	HP-UX
Node name:	hx000160
Release:	B.11.11
Version:	U
Machine:	9000/800
Instance name: AGOLFRS1
Redo thread mounted by this instance: 1
Oracle process number: 43
Unix process pid: 21660, image: oracle@hx000160 (TNS V1-V3)

*** SESSION ID:(19.4254) 2005-08-09 18:02:45.545
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=====================
PARSING IN CURSOR #1 len=32 dep=0 uid=110 oct=42 lid=110 tim=691186858 hv=1197935484 ad='1fd633d8'
alter session set sql_trace=true
END OF STMT
EXEC #1:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691186858
=====================
PARSING IN CURSOR #1 len=123 dep=0 uid=110 oct=3 lid=110 tim=691187126 hv=2588471414 ad='1fd64af0'
select instance_name || '(' || host_name || ') - '|| to_char (sysdate,'HH24:MI:ss')  as sqlprompt_col
from v$instance, dual
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=691187126
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691187126
FETCH #1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=9223376430606319617,dep=0,og=4,tim=691187126
FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691187126
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='NESTED LOOPS '
STAT #1 id=2 cnt=2 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #1 id=3 cnt=2 pid=2 pos=1 obj=195 op='TABLE ACCESS FULL DUAL '
STAT #1 id=4 cnt=2 pid=2 pos=2 obj=0 op='FIXED TABLE FULL X$KVIT '
STAT #1 id=5 cnt=1 pid=1 pos=2 obj=0 op='FIXED TABLE FULL X$KSUXSINST '
=====================
PARSING IN CURSOR #1 len=32 dep=0 uid=110 oct=42 lid=110 tim=691187126 hv=1197935484 ad='1fd633d8'
alter session set sql_trace=true
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=691187126
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691187126
*** 2005-08-09 18:03:14.116
=====================
PARSING IN CURSOR #1 len=69 dep=0 uid=110 oct=42 lid=110 tim=691189715 hv=672197786 ad='1e3fe5c0'
ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=691189715
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691189715
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
*** 2005-08-09 18:03:33.741
WAIT #1: nam='SQL*Net message from client' ela= 1963 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #2 len=213 dep=1 uid=0 oct=3 lid=0 tim=691191678 hv=1464113443 ad='1fcedf58'
select distinct obj#,containerobj#,pflags,mflags  from sum$, sumdetail$  where detailobj#=0 and sumobj#=obj#  and sumobj# in (select distinct sumobj#                  from sumdep$                  where p_obj#=:1)
END OF STMT
PARSE #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=691191678
BINDS #2:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
   bfp=80000001000bdea8 bln=22 avl=04 flg=05
   value=137795
EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=1,og=4,tim=691191678
FETCH #2:c=0,e=0,p=0,cr=5,cu=0,mis=0,r=9223376430606319616,dep=1,og=4,tim=691191678
STAT #2 id=1 cnt=0 pid=0 pos=0 obj=0 op='SORT UNIQUE '
STAT #2 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #2 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS '
STAT #2 id=4 cnt=2 pid=3 pos=1 obj=320 op='TABLE ACCESS BY INDEX ROWID SUMDETAIL$ '
STAT #2 id=5 cnt=2 pid=4 pos=1 obj=322 op='INDEX RANGE SCAN '
STAT #2 id=6 cnt=2 pid=3 pos=2 obj=318 op='TABLE ACCESS BY INDEX ROWID SUM$ '
STAT #2 id=7 cnt=2 pid=6 pos=1 obj=319 op='INDEX UNIQUE SCAN '
STAT #2 id=8 cnt=0 pid=2 pos=2 obj=329 op='TABLE ACCESS BY INDEX ROWID SUMDEP$ '
STAT #2 id=9 cnt=1 pid=8 pos=1 obj=331 op='INDEX RANGE SCAN '
=====================
PARSING IN CURSOR #2 len=213 dep=1 uid=0 oct=3 lid=0 tim=691191678 hv=1464113443 ad='1fcedf58'
select distinct obj#,containerobj#,pflags,mflags  from sum$, sumdetail$  where detailobj#=0 and sumobj#=obj#  and sumobj# in (select distinct sumobj#                  from sumdep$                  where p_obj#=:1)
END OF STMT
PARSE #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=691191678
BINDS #2:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
   bfp=80000001000bdea8 bln=22 avl=04 flg=05
   value=137795
EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=1,og=4,tim=691191678
FETCH #2:c=0,e=0,p=0,cr=5,cu=0,mis=0,r=9223376430606319616,dep=1,og=4,tim=691191678
STAT #2 id=1 cnt=0 pid=0 pos=0 obj=0 op='SORT UNIQUE '
STAT #2 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #2 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS '
STAT #2 id=4 cnt=2 pid=3 pos=1 obj=320 op='TABLE ACCESS BY INDEX ROWID SUMDETAIL$ '
STAT #2 id=5 cnt=2 pid=4 pos=1 obj=322 op='INDEX RANGE SCAN '
STAT #2 id=6 cnt=2 pid=3 pos=2 obj=318 op='TABLE ACCESS BY INDEX ROWID SUM$ '
STAT #2 id=7 cnt=2 pid=6 pos=1 obj=319 op='INDEX UNIQUE SCAN '
STAT #2 id=8 cnt=0 pid=2 pos=2 obj=329 op='TABLE ACCESS BY INDEX ROWID SUMDEP$ '
STAT #2 id=9 cnt=1 pid=8 pos=1 obj=331 op='INDEX RANGE SCAN '
=====================
PARSING IN CURSOR #2 len=89 dep=1 uid=0 oct=3 lid=0 tim=691191679 hv=1668540021 ad='1fdc16a8'
select i.obj# from ind$ i, obj$ o    where i.obj# = o.obj# and i.bo# = :1 and o.name = :2
END OF STMT
PARSE #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=691191679
BINDS #2:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=4000000000000001 size=24 offset=0
   bfp=80000001000c2428 bln=22 avl=04 flg=05
   value=466070
 bind 1: dty=1 mxl=32(29) mal=00 scl=00 pre=00 oacflg=18 oacfl2=4000000000000001 size=32 offset=0
   bfp=80000001000c2390 bln=32 avl=29 flg=05
   value="CLQ_CUS_CUSTOMER_STATUS_I_IDX"
EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=1,og=4,tim=691191679
FETCH #2:c=0,e=0,p=0,cr=18,cu=0,mis=0,r=9223376430606319617,dep=1,og=4,tim=691191679
STAT #2 id=1 cnt=1 pid=0 pos=0 obj=0 op='NESTED LOOPS '
STAT #2 id=2 cnt=4 pid=1 pos=1 obj=19 op='TABLE ACCESS CLUSTER IND$ '
STAT #2 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN '
STAT #2 id=4 cnt=1 pid=1 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #2 id=5 cnt=7 pid=4 pos=1 obj=33 op='INDEX UNIQUE SCAN '
=====================
PARSING IN CURSOR #1 len=1843 dep=0 uid=110 oct=3 lid=110 tim=691191680 hv=3568124940 ad='1f9ae360'
select count(*)
from
(
SELECT /*+ ordered */
       CC.customer_id,
      (CASE WHEN CC.type_level_id = 4  THEN    CC.trade_name || ' - ' || CC.subaccount_name
           ELSE CC.trade_name END) AS trade_name,
      CC.address_part_1,
      CC.address_part_2,
      CC.geo_area_id,
      CC.naf_code,
      CC.zip_code,
      CC.clientlevel_code,
      SUBSTR (CC.telephone,2,LENGTH (CC.telephone) - 2) AS telephone,
      SUBSTR (CC.fax,2,LENGTH (CC.fax) - 2) AS fax, CC.derniere_action_date
 FROM (SELECT customer_id, type_level_id,
            trade_name, subaccount_name,
             address_part_1,address_part_2,
             geo_area_id, naf_code,
             zip_code, clientlevel_code,
             telephone,fax,
             derniere_action_date, department_id,
             is_managed_cc, is_active,
             client_search_scope_id, last_action_date_cc,
             is_delegated_cc
       FROM clq_customers
       where internal_structure_id IN (71)
         AND department_id IN (258, 259)
         AND is_managed_cc = 1
         AND is_active = 1
         AND type_level_id IN (3)
         AND client_search_scope_id IN (1, 2)
         AND (last_action_date_cc < TO_DATE ('6/28/2005', 'MM/DD/YYYY HH24:MI:SS') OR last_action_date_cc IS NULL)
         AND (is_delegated_cc = 0  OR is_delegated_cc IS NULL)) CC
 WHERE (1=1)
   AND NOT EXISTS (
                   SELECT 'OK'
                     FROM clq_collectionsdefinitions
                    WHERE stake_level_id IN (1, 2)
                      AND CC.customer_id = clq_collectionsdefinitions.customer_id
                  )
   AND CC.customer_id NOT IN
      (SELECT /*+ index(clq_customers CLQ_CUS_CUSTOMER_STATUS_I_IDX)*/
                customer_id
                 FROM clq_customers
                WHERE customer_status_id = 1
                  AND gbu = 1 )
)
END OF STMT
PARSE #1:c=2,e=2,p=0,cr=28,cu=0,mis=1,r=0,dep=0,og=4,tim=691191680
BINDS #1:
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691191680
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60224 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60226 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60228 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60230 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60234 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=54 p2=60236 p3=1
FETCH #1:c=159,e=159,p=6,cr=74291,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=691191839
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=0,tim=691191839
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 882 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='SORT AGGREGATE '
STAT #1 id=2 cnt=1833 pid=1 pos=1 obj=0 op='FILTER '
STAT #1 id=3 cnt=1849 pid=2 pos=1 obj=0 op='HASH JOIN ANTI '
STAT #1 id=4 cnt=2043 pid=3 pos=1 obj=0 op='INLIST ITERATOR '
STAT #1 id=5 cnt=2043 pid=4 pos=1 obj=466070 op='TABLE ACCESS BY INDEX ROWID CLQ_CUSTOMERS '
STAT #1 id=6 cnt=2047 pid=5 pos=1 obj=466208 op='INDEX RANGE SCAN '
STAT #1 id=7 cnt=191722 pid=3 pos=2 obj=0 op='VIEW VW_NSO_1 '
STAT #1 id=8 cnt=191722 pid=7 pos=1 obj=466070 op='TABLE ACCESS BY INDEX ROWID CLQ_CUSTOMERS '
STAT #1 id=9 cnt=253523 pid=8 pos=1 obj=466075 op='INDEX RANGE SCAN '
STAT #1 id=10 cnt=1848 pid=2 pos=2 obj=452743 op='TABLE ACCESS BY INDEX ROWID CLQ_COLLECTIONSDEFINITIONS '
STAT #1 id=11 cnt=21939 pid=10 pos=1 obj=452746 op='INDEX RANGE SCAN '
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=18 dep=0 uid=110 oct=3 lid=110 tim=691192721 hv=4035109885 ad='1fc9f748'
select * from dual
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=691192721
BINDS #1:
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=691192721
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=9223376430606319617,dep=0,og=4,tim=691192721
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=9223376430606319616,dep=0,og=0,tim=691192721
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0