SQL> SELECT CLM.ID CLM_ID 2 ,DECODE(CLM.multi_source_cd,'Y',CLM.id,NULL) gen_ind 3 ,CLM.DATE_FILLED DATE_FILLED 4 ,CLM.RX_NUMBER RX_NUMBER 5 ,DECODE(NVL(CLM.NEW_REFILL_CD,0), 0, 'N', 'R') NEW_REFILL 6 ,CLM.METRIC_QTY_ALLOWED METRIC_QTY_ALLOWED 7 ,CLM.DAYS_SUPPLY_ALLOWED DAYS_SUPPLY_ALLOWED 8 ,CLM.BILL_BASIS CLM_BILL_BASIS 9 ,(NVL(CLM.BILL_IC_SUBMITTED,0) + NVL(CLM.BILL_IC_ADJ,0)) CLM_BILL_IC 10 ,CLM.BILL_DF CLM_BILL_DF 11 ,CLM.TAX_PAID TAX_PAID 12 ,CLM.PAT_TOTAL CLM_PAT_TOTAL 13 ,DECODE(CLM.TRANSACTION_TYPE, 1, CLM.PAT_TOTAL, 0) REV_PAT_TOTAL 14 ,DECODE(CLM.TRANSACTION_TYPE, 1, NVL(CLM.BILL_IC_SUBMITTED,0) + NVL(CLM.BILL_IC_ADJ,0) + NVL(CLM.BILL_DF, 0) + 15 NVL(CLM.TAX_PAID, 0) - NVL(CLM.PAT_TOTAL, 0) , 0) REV_NET_TOTAL 16 ,CLM.PAT_DEDUCTIBLE CLM_PAT_DEDUCTIBLE 17 ,DECODE(CLM.DAW_ALLOWED,'1','1','2','2',NULL) CLM_DAW 18 ,PHR.ID PHR_ID 19 ,PHR.NAME PHR_NAME 20 ,PHR.ADDR1 PHR_ADDR1 21 ,PHR.CITY || ', ' || PHR.STATE || ' ' || PHR.ZIPCODE PHR_CITY_ST 22 ,CLM.GROUP_ID CLM_GROUP_ID 23 ,MBR.ID MBR_ID 24 ,MBR.FIRST_NAME MBR_FIRST_NAME 25 ,MBR.LAST_NAME MBR_LAST_NAME 26 ,MBR.PERSON_CODE MBR_PERSON_CODE 27 ,DRG.DESCRIPTION DRG_DESCRIPTION 28 ,DRG.ID_NUM_FORM_CD DRG_ID_FORMAT 29 ,DECODE(DRG.MULTI_SOURCE_CD, 'Y', 'G', 'M', 'C', DRG.MULTI_SOURCE_CD) DRUG_MULTI_SOURCE 30 ,CLM.DRUG_NDC_ALLOWED 31 ,CLM.PAYEE_TYPE CLM_PAYEE_TYPE 32 ,PHY.DEA PHY_DEA 33 ,PHY.FIRST_NAME PHY_FIRST_NAME 34 ,PHY.LAST_NAME PHY_LAST_NAME 35 ,CLM.CAPTURE_STATUS CAPTURE_STATUS 36 ,DECODE(CLM.TRANSACTION_TYPE, 0, 1, 0) CLAIM_COUNT 37 ,DECODE(CLM.TRANSACTION_TYPE, 1, 1, 0) REV_CLAIM 38 FROM PBM_CLAIM CLM 39 ,PBM_PHARMACY PHR 40 ,PBM_MEMBER MBR 41 ,PBM_DRUG DRG 42 ,PBM_PHYSICIAN PHY 43 , pbm_pharmacy_network pn 44 WHERE 45 CLM.phrnet_pk = pn.pk AND 46 pn.service_type = decode(NVL('&P_NETWORK_TYPE', 'A'),'RETAIL','R','MAIL','M',pn.service_type ) AND 47 PHR.PK = CLM.PHARMACY_PK AND 48 MBR.PK = CLM.MEMBER_PK AND 49 MBR.ID = DECODE(NVL('&P_MEMBER_ID','ALL'), 50 'ALL',MBR.ID,'All',MBR.ID, 51 '&P_MEMBER_ID') AND 52 MBR.PERSON_CODE = DECODE(NVL('&P_PERSON_CODE', 'ALL'), 53 'ALL', MBR.PERSON_CODE, 54 '&P_PERSON_CODE') AND 55 PHY.PK = CLM.PHYSICIAN_PK AND 56 CLM.GROUP_ID = &P_GROUP_ID AND 57 DRG.NDC = CLM.DRUG_NDC_ALLOWED AND 58 DATE_FILLED BETWEEN NVL('&P_FROM_DATE', DATE_FILLED) AND NVL('&P_TO_DATE', DATE_FILLED) 59 ORDER BY 60 MBR.PERSON_CODE 61 ,CLM.DATE_FILLED 62 ,CLM.ID 63 / ------------------------------------------- SCENARIO # 1 ------------ Enter value for p_network_type: ALL old 46: pn.service_type = decode(NVL('&P_NETWORK_TYPE', 'A'),'RETAIL','R','MAIL','M',pn.service_ new 46: pn.service_type = decode(NVL('ALL', 'A'),'RETAIL','R','MAIL','M',pn.service_type) AND Enter value for p_member_id: 3961309900 old 49: MBR.ID = DECODE(NVL('&P_MEMBER_ID','ALL'), new 49: MBR.ID = DECODE(NVL('3961309900','ALL'), Enter value for p_member_id: 3961309900 old 51: '&P_MEMBER_ID') AND new 51: '3961309900') AND Enter value for p_person_code: ALL old 52: MBR.PERSON_CODE = DECODE(NVL('&P_PERSON_CODE', 'ALL'), new 52: MBR.PERSON_CODE = DECODE(NVL('ALL', 'ALL'), Enter value for p_person_code: ALL old 54: '&P_PERSON_CODE') AND new 54: 'ALL') AND Enter value for p_group_id: 7701 old 56: CLM.GROUP_ID = &P_GROUP_ID AND new 56: CLM.GROUP_ID = 7701 AND Enter value for p_from_date: 01-DEC-07 Enter value for p_to_date: 31-DEC-07 old 58: DATE_FILLED BETWEEN NVL('&P_FROM_DATE', DATE_FILLED) AND NVL('&P_TO_DATE', DATE_FILLED new 58: DATE_FILLED BETWEEN NVL('01-DEC-07', DATE_FILLED) AND NVL('31-DEC-07', DATE_FILLED) Elapsed: 00:05:328.22 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3074 Card=1 Bytes=24 4) 1 0 SORT (ORDER BY) (Cost=3074 Card=1 Bytes=244) 2 1 NESTED LOOPS (Cost=3072 Card=1 Bytes=244) 3 2 NESTED LOOPS (Cost=3070 Card=1 Bytes=212) 4 3 NESTED LOOPS (Cost=3068 Card=1 Bytes=177) 5 4 NESTED LOOPS (Cost=3067 Card=1 Bytes=114) 6 5 NESTED LOOPS (Cost=3066 Card=1 Bytes=110) 7 6 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_CLAIM' (Cost=3028 Card=19 Bytes=1482) 8 7 INDEX (RANGE SCAN) OF 'CLAIM_GROUP_FK_I' (NON-UNIQUE) (Cost=45 Card=19) 9 6 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_MEMBER'(Cost=2 Card=1 Bytes=32) 10 9 INDEX (UNIQUE SCAN) OF 'MEMBER_PK' (UNIQUE) (Cost=1 Card=1) 11 5 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHARMACY_NETWORK' (Cost=1 Card=44 Bytes=176) 12 11 INDEX (UNIQUE SCAN) OF 'PHRNET_PK' (UNIQUE) 13 4 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHARMACY' (Cost=1 Card=101750 Bytes=6410250) 14 13 INDEX (UNIQUE SCAN) OF 'PHARMACY_PK' (UNIQUE) 15 3 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_DRUG' (Cost=2 Card=200344 Bytes=7012040) 16 15 INDEX (UNIQUE SCAN) OF 'DRUG_PK' (UNIQUE) (Cost=1 Card=200344) 17 2 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHYSICIAN' (Cost=2 Card=1924035 Bytes=61569120) 18 17 INDEX (UNIQUE SCAN) OF 'PHYSICIAN_PK' (UNIQUE) (Cost=1 Card=1924035) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 732146 consistent gets 532602 physical reads 0 redo size 1592 bytes sent via SQL*Net to client 1050 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 7 sorts (memory) 0 sorts (disk) 1 rows processed ======================================================================================================================== SCENARIO # 2 ------------- Enter value for p_network_type: ALL old 46: pn.service_type = decode(NVL('&P_NETWORK_TYPE', 'A'),'RETAIL','R','MAIL','M',pn.service new 46: pn.service_type = decode(NVL('ALL', 'A'),'RETAIL','R','MAIL','M',pn.service_type) AND Enter value for p_member_id: 3961309900 old 49: MBR.ID = DECODE(NVL('&P_MEMBER_ID','ALL'), new 49: MBR.ID = DECODE(NVL('3961309900','ALL'), Enter value for p_member_id: 3961309900 old 51: '&P_MEMBER_ID') AND new 51: '3961309900') AND Enter value for p_person_code: ALL old 52: MBR.PERSON_CODE = DECODE(NVL('&P_PERSON_CODE', 'ALL'), new 52: MBR.PERSON_CODE = DECODE(NVL('ALL', 'ALL'), Enter value for p_person_code: ALL old 54: '&P_PERSON_CODE') AND new 54: 'ALL') AND Enter value for p_group_id: 7703 old 56: CLM.GROUP_ID = &P_GROUP_ID AND new 56: CLM.GROUP_ID = 7703 AND Enter value for p_from_date: 01-DEC-07 Enter value for p_to_date: 31-DEC-07 old 58: DATE_FILLED BETWEEN NVL('&P_FROM_DATE', DATE_FILLED) AND NVL('&P_TO_DATE', DATE_FILLE new 58: DATE_FILLED BETWEEN NVL('01-DEC-07', DATE_FILLED) AND NVL('31-DEC-07', DATE_FILLED) no rows selected Elapsed: 00:05:311.19 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3074 Card=1 Bytes=24 4) 1 0 SORT (ORDER BY) (Cost=3074 Card=1 Bytes=244) 2 1 NESTED LOOPS (Cost=3072 Card=1 Bytes=244) 3 2 NESTED LOOPS (Cost=3070 Card=1 Bytes=212) 4 3 NESTED LOOPS (Cost=3068 Card=1 Bytes=177) 5 4 NESTED LOOPS (Cost=3067 Card=1 Bytes=114) 6 5 NESTED LOOPS (Cost=3066 Card=1 Bytes=110) 7 6 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_CLAIM' ( Cost=3028 Card=19 Bytes=1482) 8 7 INDEX (RANGE SCAN) OF 'CLAIM_GROUP_FK_I' (NO N-UNIQUE) (Cost=45 Card=19) 9 6 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_MEMBER' (Cost=2 Card=1 Bytes=32) 10 9 INDEX (UNIQUE SCAN) OF 'MEMBER_PK' (UNIQUE) (Cost=1 Card=1) 11 5 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHARMACY_N ETWORK' (Cost=1 Card=44 Bytes=176) 12 11 INDEX (UNIQUE SCAN) OF 'PHRNET_PK' (UNIQUE) 13 4 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHARMACY' (C ost=1 Card=101750 Bytes=6410250) 14 13 INDEX (UNIQUE SCAN) OF 'PHARMACY_PK' (UNIQUE) 15 3 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_DRUG' (Cost=2 Card=200344 Bytes=7012040) 16 15 INDEX (UNIQUE SCAN) OF 'DRUG_PK' (UNIQUE) (Cost=1 Card=200344) 17 2 TABLE ACCESS (BY INDEX ROWID) OF 'PBM_PHYSICIAN' (Cost =2 Card=1924035 Bytes=61569120) 18 17 INDEX (UNIQUE SCAN) OF 'PHYSICIAN_PK' (UNIQUE) (Cost =1 Card=1924035) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 308069 consistent gets 259415 physical reads 960 redo size 1239 bytes sent via SQL*Net to client 1011 bytes received via SQL*Net from client 1 SQL*Net roundtrips to/from client 7 sorts (memory) 0 sorts (disk) 0 rows processed ¬¬¬¬¬¬¬¬¬ TKPROF: Release 8.1.7.3.0 - Production on Wed Jan 30 19:37:10 2008 (c) Copyright 2000 Oracle Corporation. All rights reserved. Trace file: stndby_ora_8973.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 obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1 from obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:6 or subname is null and :6 is null) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 9 17 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 9 17 0 5 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0), audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1), nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0) ,nvl(spare2,0),spare4,nvl(spare3,0) from tab$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 16 25 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 16 25 0 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#= :1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#= :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 24 0.00 0.00 13 56 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 36 0.00 0.00 13 56 0 15 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select pos#,intcol#,col#,spare1 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 40 0.00 0.00 6 80 0 25 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 58 0.00 0.00 6 80 0 25 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, charsetid,charsetform,spare1,spare2 from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 118 0.00 0.00 0 31 0 109 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 130 0.00 0.00 0 31 0 109 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 1 0 1 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 4 3 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ 2 INDEX UNIQUE SCAN (object id 107) ******************************************************************************** select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0) from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# 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 20 0.00 0.00 15 60 0 19 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 0.00 0.00 15 60 0 19 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 19 SORT ORDER BY 19 NESTED LOOPS OUTER 20 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ 20 INDEX RANGE SCAN (object id 116) 19 TABLE ACCESS BY INDEX ROWID OBJ$ 38 INDEX UNIQUE SCAN (object id 33) ******************************************************************************** select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP', defschclass) from user$ where user#=: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 1 0.00 0.00 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER USER$ 1 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** select order#,columns,types from access$ where d_obj#=: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 7 0.00 0.00 3 14 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 3 14 0 6 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 6 TABLE ACCESS BY INDEX ROWID ACCESS$ 7 INDEX RANGE SCAN (object id 118) ******************************************************************************** select /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from idl_sb4$ where obj#=:1 and version<=:2 and (part=0 or part=2) and piece#=0 _ call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 3 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 3 16 0 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 2 INLIST ITERATOR 2 INDEX RANGE SCAN (object id 113) ******************************************************************************** select i.obj# from ind$ i, obj$ o where i.obj# = o.obj# and i.bo# = :1 and o.name = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 1 30 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.00 1 30 0 5 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS CLUSTER IND$ 1 INDEX UNIQUE SCAN (object id 3) 1 TABLE ACCESS BY INDEX ROWID OBJ$ 1 INDEX UNIQUE SCAN (object id 33) ******************************************************************************** select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 3 23 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.00 3 23 0 5 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ 3 INDEX RANGE SCAN (object id 113) ******************************************************************************** select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 1 0 1 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 6 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 7 20 1 5 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ 2 INDEX RANGE SCAN (object id 110) ******************************************************************************** select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 3 11 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 3 11 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ 2 INDEX RANGE SCAN (object id 111) ******************************************************************************** select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 1 0 1 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 8 20 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 9 20 1 3 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 TABLE ACCESS BY INDEX ROWID IDL_UB2$ 3 INDEX RANGE SCAN (object id 112) ******************************************************************************** select grantee#,privilege#,nvl(col#,0),max(nvl(option$,0)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 215 0.00 0.00 24 37 0 211 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 222 0.00 0.00 24 37 0 211 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** BEGIN svenkatesh.in_load_elgcc; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 1458 ******************************************************************************** select col#, grantee#, privilege#,max(nvl(option$,0)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 4 7 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 4 7 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ 2 INDEX RANGE SCAN (object id 100) ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 3 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.00 3 6 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID CDEF$ 4 INDEX RANGE SCAN (object id 49) ******************************************************************************** select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 33 0.00 0.00 3 41 0 29 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39 0.00 0.00 3 41 0 29 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 22 TABLE ACCESS CLUSTER CDEF$ 6 INDEX UNIQUE SCAN (object id 27) ******************************************************************************** select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 58 0.00 0.00 8 116 0 29 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 89 0.00 0.00 8 116 0 29 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 22 TABLE ACCESS BY INDEX ROWID CCOL$ 44 INDEX RANGE SCAN (object id 52) ******************************************************************************** SELECT BATCH_ID FROM ELG_BATCH WHERE BATCH_ID = (SELECT MAX(BATCH_ID) FROM ELG_BATCH WHERE BATCH_ID LIKE 'IND%' ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 2 2 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 4 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 1595 (recursive depth: 1) ******************************************************************************** SELECT EL.MEMBER_ID,EL.IN_GRP_ID,EL.IN_PLAN_ID,EL.EFFECTIVE_BEGIN, EL.EFFECTIVE_END,EL.DEPT_NO,EL.STATUS FROM ELG_LOAD EL WHERE (EL.ELGBATCH_PK = (SELECT EB.PK FROM ELG_BATCH EB WHERE EB.BATCH_ID = (SELECT MAX(BATCH_ID) FROM ELG_BATCH WHERE BATCH_ID LIKE 'IND%' ) ) ) AND (EL.IN_GRP_ID IN ( '8100','8102','8103','8104', '8105','8106' ))ORDER BY EL.MEMBER_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 1 5 0 0 Fetch 2862 0.00 0.00 10173 5627 509 2862 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2864 0.00 0.00 10174 5632 509 2862 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 1595 (recursive depth: 1) ******************************************************************************** select user#,type# from user$ where name=: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 1 0.00 0.00 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID USER$ 1 INDEX UNIQUE SCAN (object id 41) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 3 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 3 9 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ 1 INDEX UNIQUE SCAN (object id 9) ******************************************************************************** select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname, o.dataobj#,o.flags from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 1 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 1 6 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ$ 2 INDEX UNIQUE SCAN (object id 33) ******************************************************************************** select node,owner,name from syn$ where obj#=: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 1 0.00 0.00 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 3 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SYN$ 1 INDEX UNIQUE SCAN (object id 98) ******************************************************************************** select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$ from seq$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 5 13 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 6 15 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select privilege#,nvl(col#,0),max(nvl(option$,0)) from objauth$ where obj#=:1 and grantee#=:2 group by privilege#,nvl(col#,0) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 4 5 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 4 5 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj# 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 1 0.00 0.00 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY 0 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID TRIGGER$ 1 INDEX RANGE SCAN (object id 119) 0 TABLE ACCESS BY INDEX ROWID OBJ$ 0 INDEX UNIQUE SCAN (object id 33) 0 TABLE ACCESS CLUSTER USER$ 0 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** INSERT INTO CMONREAL.ELG_CONTINUITYCARE ( PK,MEMBER_ID,IN_GRP_ID,IN_PLAN_ID, EFFECTIVE_BEGIN,EFFECTIVE_END,DEPT_NO,STATUS,BATCH_ID,TPA_ID ) VALUES ( OPS_JOB_STATUS_SEQ.NEXTVAL,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 41 123 1 0 Execute 2861 0.00 0.00 133 98 41687 40 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2862 0.00 0.00 174 221 41688 40 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 1595 (recursive depth: 1) ******************************************************************************** update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 144 0.00 0.00 0 0 0 0 Execute 144 0.00 0.00 12 144 432 144 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 288 0.00 0.00 12 144 432 144 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SEQ$ 1 INDEX UNIQUE SCAN (object id 99) ******************************************************************************** select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2822 0.00 0.00 0 0 0 0 Execute 2822 0.00 0.00 0 0 0 0 Fetch 2822 0.00 0.00 30 5644 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8466 0.00 0.00 30 5644 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID CDEF$ 1 INDEX RANGE SCAN (object id 50) 0 TABLE ACCESS BY INDEX ROWID CON$ 0 INDEX UNIQUE SCAN (object id 46) 0 TABLE ACCESS CLUSTER USER$ 0 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2821 0.00 0.00 0 0 0 0 Execute 2821 0.00 0.00 0 0 0 0 Fetch 2821 0.00 0.00 58 16926 0 2821 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8463 0.00 0.00 58 16926 0 2821 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID OBJ$ 1 INDEX UNIQUE SCAN (object id 33) 1 TABLE ACCESS CLUSTER USER$ 1 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext, dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=: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 1 0.00 0.00 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 2 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER TS$ 1 INDEX UNIQUE SCAN (object id 7) ******************************************************************************** select file# from file$ where ts#=: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 5 0.00 0.00 2 9 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 2 9 0 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID FILE$ 5 INDEX RANGE SCAN (object id 39) ******************************************************************************** select distinct(-privilege#),nvl(option$,0) from sysauth$ where grantee#=:1 and privilege#<0 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 10 0.00 0.00 2 3 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 2 3 0 9 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 9 SORT UNIQUE 9 TABLE ACCESS BY INDEX ROWID SYSAUTH$ 10 INDEX RANGE SCAN (object id 102) ******************************************************************************** select blocks,maxblocks,grantor#,priv1,priv2,priv3 from tsq$ where ts#=:1 and user#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 4 9 1 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 4 12 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER TSQ$ 1 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 where ts#=:1 and user#=:2 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 5 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 5 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE TSQ$ 2 TABLE ACCESS CLUSTER TSQ$ 2 INDEX UNIQUE SCAN (object id 11) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5859 0.00 0.00 53 145 5 0 Execute 8785 0.00 0.00 148 254 42120 185 Fetch 9109 0.00 0.00 10414 28861 509 6190 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23753 0.00 0.00 10615 29260 42634 6375 Misses in library cache during parse: 34 4 user SQL statements in session. 5856 internal SQL statements in session. 5860 SQL statements in session. ******************************************************************************** Trace file: stndby_ora_8973.trc Trace file compatibility: 8.00.04 Sort options: default 1 session in tracefile. 4 user SQL statements in trace file. 5856 internal SQL statements in trace file. 5860 SQL statements in trace file. 39 unique SQL statements in trace file. 87148 lines in trace file.