TKPROF: Release 8.0.6.0.0 - Production on Sat May 15 11:45:42 2010 (c) Copyright 1999 Oracle Corporation. All rights reserved. Trace file: e:\orant\rdbms80\trace\ora02532.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 ******************************************************************************** The following statement encountered a error during parse: SELECT BUS_UNIT,REQUEST_NO,REQUEST_DATE,REQUEST_TIME,REG_NO,TOP_BRASS_YN,REQUEST_ADMT_THEATRE_FLAG,PT_CODE,PT_NAME,CTYP_CUST_TYPE,CUST_CUSTOMER,PRIORTY,ROWID FROM A_INP_THEATRE_ADMT WHERE bus_unit = :1 and trunc(request_date) >= (trunc(sysdate)-90) order by request_no desc Error encountered: ORA-01446 ******************************************************************************** SAVEPOINT FM_1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.06 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.06 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT USER FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 7 0.00 0.02 0 0 0 0 Fetch 14 0.00 0.00 0 7 21 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.02 0 7 21 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT SYSDATE FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 14 0.00 0.05 0 0 0 0 Fetch 28 0.00 0.00 0 14 42 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.05 0 14 42 14 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT BU_NAME1 FROM BUS_UNIT WHERE BU_BUS_UNIT = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.10 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 21 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28 0.00 0.10 0 21 0 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID BUS_UNIT 2 INDEX RANGE SCAN (object id 5476) ******************************************************************************** select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID VIEW$ ******************************************************************************** SELECT BUS_UNIT,REQUEST_NO,REQUEST_DATE,REQUEST_TIME,REG_NO,TOP_BRASS_YN, REQUEST_ADMT_THEATRE_FLAG,PT_CODE,PT_NAME,CTYP_CUST_TYPE,CUST_CUSTOMER, PRIORTY FROM A_INP_THEATRE_ADMT WHERE bus_unit = :1 and trunc(request_date) >= (trunc(sysdate)-90) order by request_no desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.04 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.11 0.11 0 36606 0 11 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.11 0.15 0 36606 0 11 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 81 SORT ORDER BY 81 VIEW A_INP_THEATRE_ADMT 81 SORT UNIQUE 81 UNION-ALL 46 NESTED LOOPS 7629 TABLE ACCESS BY INDEX ROWID A_INP_THEATRE_REQUEST 7630 INDEX RANGE SCAN (object id 418783) 59 TABLE ACCESS BY INDEX ROWID A_PT_MASTER 118 INDEX RANGE SCAN (object id 5282) 35 NESTED LOOPS 28279 TABLE ACCESS BY INDEX ROWID A_INP_ADMT_MSSG 28280 INDEX RANGE SCAN (object id 418787) 43 TABLE ACCESS BY INDEX ROWID A_PT_MASTER 86 INDEX RANGE SCAN (object id 5282) ******************************************************************************** SELECT REQUEST_APPL_TYPE FROM A_INP_THEATRE_REQUEST WHERE BUS_UNIT = :b1 AND REQUEST_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.07 0 0 0 0 Execute 42 0.00 0.00 0 0 0 0 Fetch 42 0.00 0.00 0 91 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 86 0.00 0.07 0 91 0 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID A_INP_THEATRE_REQUEST 10 INDEX UNIQUE SCAN (object id 418783) ******************************************************************************** SELECT BF_DESC FROM BUS_FUN WHERE BF_BUS_FUN = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.01 0.14 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 24 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 0.01 0.14 0 24 0 8 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID BUS_FUN 1 INDEX RANGE SCAN (object id 5474) ******************************************************************************** SAVEPOINT FM_2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.12 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.12 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT NVL(BLCK_TOOLBAR_YN,'N') FROM BUS_FUN WHERE BF_BUS_FUN = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.08 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 18 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.08 0 18 0 6 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID BUS_FUN 1 INDEX RANGE SCAN (object id 5474) ******************************************************************************** ROLLBACK TO FM_2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.06 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.06 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT SYSDATE FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 3 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.03 0 1 3 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT WARD_CODE , WARD_NAME_E FROM A_WARD_MASTER WHERE BUS_UNIT = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.03 2 9 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.04 2 9 0 8 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT NVL(BFTA_ADD_ACCESS,BFTA_EDIT_ACCESS) FROM BUS_FUNC_TASK_ACCESS WHERE BFTA_BUS_UNIT = :b1 AND BFTA_BUS_FUNCTION = 'A_IOR600' AND BFTA_TASK_ID = '01' AND BFTA_USERID = USER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.03 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT NVL(BFTA_ADD_ACCESS,BFTA_EDIT_ACCESS) FROM BUS_FUNC_TASK_ACCESS WHERE BFTA_BUS_UNIT = :b1 AND BFTA_BUS_FUNCTION = 'A_IOR601' AND BFTA_TASK_ID = '01' AND BFTA_USERID = USER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT PT_CODE,BUS_UNIT,TOP_BRASS_YN,ROOM_CLASS_CODE,WARD_CODE, ADMIT_STATUS_FLAG,PT_ADMIT_DATE,PT_ADMIT_TIME,MD_CODE,REQUEST_NO,REG_NO, INP_REG_NO,MOTHER_PT_CODE,CRE_NOTES,PT_DIAGNOSIS_NOTE, TMP_CLINIC_DISCHARGE_DATE,ROOM_CODE,BED_CODE,ROWID FROM A_INP_PATIENTS_ADMT WHERE bus_unit = :1 and admit_status_flag = 'C' and nvl(clinical_discharge_yn,'N') not in ('Y','C') and (ward_code = :2 or :3 = '007') order by room_code call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.14 26.61 2306 47604 0 33 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.14 26.64 2306 47604 0 33 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT PT_FIRST_NAME_E || ' ' || PT_SECOND_NAME_E || ' ' || PT_LAST_NAME_E ,ROUND(((TRUNC(SYSDATE) - TRUNC(PT_DOB) ) / 365 ),1),DECODE(PT_SEX,'M', 'Male','F','Female','Male') FROM A_PT_MASTER WHERE PT_CODE = :b1 AND BUS_UNIT = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 33 0.00 0.00 0 0 0 0 Fetch 65 0.00 0.59 49 164 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 99 0.00 0.60 49 164 0 32 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT PT_COMPLAINT FROM A_INP_THEATRE_REQUEST WHERE BUS_UNIT = :b1 AND REQUEST_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 32 0.00 0.00 0 67 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 65 0.00 0.03 0 67 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT SURGERY_STAY_DAYS FROM A_INP_THEATRE_REQUEST WHERE BUS_UNIT = :b1 AND REQUEST_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 32 0.00 0.00 0 67 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 65 0.00 0.03 0 67 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT DECODE(PT_CASH_PRIVATE,'C','CASH','I','INSURANCE','D','DIRECT BILLING', 'P','VIP','S','SPONSOR','E','EMERGENCY','R','PRE-OPERATIVE', NULL ), CTYP_CUST_TYPE,CUST_CUSTOMER FROM A_PT_BILL_MASTER WHERE BUS_UNIT = :b1 AND REG_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 64 0.00 0.12 24 128 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 97 0.00 0.15 24 128 0 32 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT PT_CASH_PRIVATE FROM A_PT_BILL_MASTER WHERE BUS_UNIT = :b1 AND REG_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 32 0.00 0.00 0 128 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 65 0.00 0.02 0 128 0 32 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT APNTMNT_SUPERVISOR_YN FROM ULTIMA_USERS WHERE EU_USERNAME = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.02 0 0 0 0 Execute 32 0.00 0.00 0 0 0 0 Fetch 64 0.00 0.02 3 96 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 97 0.02 0.04 3 96 0 32 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT PT_COMPLAINT FROM A_INP_ADMT_MSSG WHERE BUS_UNIT = :b1 AND REQUEST_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 29 0.00 0.02 1 110 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.00 0.03 1 110 0 23 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT BUS_UNIT,AS_APPLICATION,PT_CODE,REG_NO,CTYP_CUST_TYPE,CUST_CUSTOMER, POLICY_NUMBER,CLASS_CODE,ROWID FROM A_PT_BILL_MASTER WHERE REG_NO = :1 AND BUS_UNIT = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.10 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.10 0 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_PT_BILL_MASTER 1 INDEX UNIQUE SCAN (object id 5249) ******************************************************************************** SELECT A.PT_FIRST_NAME_E || ' ' || A.PT_SECOND_NAME_E || ' ' || A.PT_LAST_NAME_E ,A.PT_DOB,((TRUNC(SYSDATE) - TRUNC(A.PT_DOB) ) / 365 ), DECODE(A.PT_SEX,'M','MALE','F','FEMALE'),A.PT_CURNT_STATUS,A.PT_TITLE_CODE, A.PT_CITIZENSHIP_CODE,DECODE(NVL(A.PT_CASH_PRIVATE,'C'),'C','CASH','P', 'VIP','I','INSURANSE','D','DIRECT BILLING','S','SPONSOR','CASH') FROM A_PT_MASTER A WHERE A.PT_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.22 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 15 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.22 0 15 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_PT_MASTER 2 INDEX RANGE SCAN (object id 5282) ******************************************************************************** SELECT DECODE(NVL(PT_CASH_PRIVATE,'C'),'C','CASH','P','VIP','I','INSURANSE', 'D','DIRECT BILLING','S','SPONSOR','E','EMERGENCY','CASH') FROM A_PT_BILL_MASTER WHERE BUS_UNIT = :b1 AND PT_CODE = :b2 AND REG_NO = :b3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.05 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.05 0 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_PT_BILL_MASTER 1 INDEX UNIQUE SCAN (object id 5249) ******************************************************************************** SELECT WARD_CODE,ROOM_CODE FROM A_INP_PATIENTS_ADMT WHERE BUS_UNIT = :b1 AND INP_REG_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.10 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.05 3 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.15 3 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_INP_PATIENTS_ADMT 1 INDEX RANGE SCAN (object id 628839) ******************************************************************************** SELECT WARD_NAME_E FROM A_WARD_MASTER WHERE WARD_CODE = :b1 AND BUS_UNIT = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.06 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.06 0 8 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_WARD_MASTER 1 INDEX UNIQUE SCAN (object id 5466) ******************************************************************************** SELECT HOSP_DEPT_CODE,PX_DATE FROM A_MD_OPTREG WHERE REG_NO = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.02 0.09 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.06 4 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.02 0.15 4 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_MD_OPTREG 1 INDEX RANGE SCAN (object id 5159) ******************************************************************************** SELECT PX_DATE FROM A_MD_OPTREG WHERE PX_DATE = (SELECT MAX(PX_DATE) FROM A_MD_OPTREG WHERE PT_CODE = :b1 AND HOSP_DEPT_CODE = :b2 AND PX_DATE != :b3 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.10 0 0 0 0 Execute 4 0.00 0.06 4 20 0 0 Fetch 4 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.16 4 20 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX RANGE SCAN (object id 5158) 0 SORT AGGREGATE 1 TABLE ACCESS BY INDEX ROWID A_MD_OPTREG 2 INDEX RANGE SCAN (object id 5156) ******************************************************************************** SELECT CITIZENSHIP_DESC_E FROM A_CD_CITIZENSHIP WHERE CITIZENSHIP_CODE = :b1 AND BUS_UNIT = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.09 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.01 2 8 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.10 2 8 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_CD_CITIZENSHIP 1 INDEX RANGE SCAN (object id 4752) ******************************************************************************** SELECT MD_CODE FROM A_INP_PATIENTS_ADMT WHERE BUS_UNIT = :b1 AND INP_REG_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.11 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.11 0 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_INP_PATIENTS_ADMT 1 INDEX RANGE SCAN (object id 628839) ******************************************************************************** SELECT CTYP_DESC FROM CUST_TYPES WHERE CTYP_BUS_UNIT = :b1 AND CTYP_CUST_TYPE = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.01 0.09 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.01 3 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.01 0.10 3 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID CUST_TYPES 1 INDEX UNIQUE SCAN (object id 3635) ******************************************************************************** SELECT CUST_NAME1 FROM CUSTOMERS WHERE CUST_BUS_UNIT = :b1 AND CUST_CUSTOMER = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.07 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.03 3 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.10 3 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID CUSTOMERS 1 INDEX UNIQUE SCAN (object id 3599) ******************************************************************************** SELECT CLS_CLASS_DESC FROM A_INSURANCE_CLASSES_SETUP WHERE CLS_BUS_UNIT = :b1 AND CLS_CLASS_CODE = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.07 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.01 3 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.08 3 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_INSURANCE_CLASSES_SETUP 1 INDEX UNIQUE SCAN (object id 5123) ******************************************************************************** SELECT TOP_BRASS_YN FROM A_INP_PATIENTS_ADMT WHERE BUS_UNIT = :b1 AND INP_REG_NO = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.08 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.08 0 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_INP_PATIENTS_ADMT 1 INDEX RANGE SCAN (object id 628839) ******************************************************************************** SELECT A.TRANSPORT_MODE_CODE,B.TRANSPORT_MODE_DESC_E FROM A_MD_OPTREG A,A_CD_TRANSPORT_MODE B WHERE A.REG_NO = :b1 AND A.TRANSPORT_MODE_CODE = B.TRANSPORT_MODE_CODE AND A.BUS_UNIT = :b2 AND B.BUS_UNIT = :b3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.06 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 16 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.06 0 16 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID A_MD_OPTREG 2 INDEX RANGE SCAN (object id 5159) 0 TABLE ACCESS BY INDEX ROWID A_CD_TRANSPORT_MODE 0 INDEX UNIQUE SCAN (object id 4902) ******************************************************************************** SELECT MD_NAME_E FROM A_MD_MASTER WHERE MD_CODE = :b1 AND BUS_UNIT = :b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.02 0.07 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.03 3 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.02 0.10 3 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID A_MD_MASTER 1 INDEX RANGE SCAN (object id 590435) ******************************************************************************** SELECT ORDER_NO,AS_APPLICATION,ORD_END_DATE,CRE_BY,CRE_DATE,CRE_NOTES,REG_NO, BUS_UNIT,ORD_STATUS,ROWID FROM A_PT_ORDER_MASTER WHERE bus_unit = :1 and substr(order_no,1,3) = 'LAB' and (AS_APPLICATION=:2) and (REG_NO=:3) and (BUS_UNIT=:4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.05 4 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.07 4 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID A_PT_ORDER_MASTER 3 INDEX RANGE SCAN (object id 5299) ******************************************************************************** SELECT 1 FROM A_PT_ORD_SRVC_RQRMNTS WHERE SEQ_NO = :b1 AND ORDER_NO = :b2 AND BUS_UNIT = :b3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX RANGE SCAN (object id 5324) ******************************************************************************** SELECT ORDER_NO,AS_APPLICATION,ORD_END_DATE,PREGNANCY_FLAG,PREGNANCY_LMP, CRE_BY,CRE_DATE,CRE_NOTES,REG_NO,BUS_UNIT,ORD_STATUS,ROWID FROM A_PT_ORDER_MASTER WHERE bus_unit = :1 and substr(order_no,1,3) = 'DIA' and (AS_APPLICATION=:2) and (REG_NO=:3) and (BUS_UNIT=:4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID A_PT_ORDER_MASTER 3 INDEX RANGE SCAN (object id 5299) ******************************************************************************** SELECT ORDER_NO,AS_APPLICATION,ORD_END_DATE,PT_BLOOD_PRESSURE,ECG_AMB_FLAG, ECG_BED_FLAG,ECG_EMG_FLAG,ECG_DIG_FLAG,ECG_QUIN_FLAG,CRE_BY,CRE_DATE, CRE_NOTES,REG_NO,BUS_UNIT,ORD_STATUS,ROWID FROM A_PT_ORDER_MASTER WHERE bus_unit = :1 and substr(order_no,1,3) = 'ECG' and (AS_APPLICATION=:2) and (REG_NO=:3) and (BUS_UNIT=:4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.05 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.05 0 4 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 675 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID A_PT_ORDER_MASTER 3 INDEX RANGE SCAN (object id 5299) ******************************************************************************** SELECT A.PT_FIRST_NAME_E || ' ' || A.PT_SECOND_NAME_E || ' ' || A.PT_LAST_NAME_E ,A.PT_DOB,((TRUNC(SYSDATE) - TRUNC(A.PT_DOB) ) / 365 ), DECODE(A.PT_SEX,'M','MALE','F','FEMALE'),A.PT_CURNT_STATUS,A.PT_TITLE_CODE, A.PT_CITIZENSHIP_CODE FROM A_PT_MASTER A WHERE A.PT_CODE = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.03 0 5 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** SELECT ORDER_NO,AS_APPLICATION,ORD_END_DATE,CRE_BY,CRE_DATE,CRE_NOTES,REG_NO, BUS_UNIT,ORD_STATUS,ROWID FROM A_PT_ORDER_MASTER WHERE bus_unit = :1 and substr(order_no,1,3) = 'VAC' and (AS_APPLICATION=:2) and (REG_NO=:3) and (BUS_UNIT=:4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 0 4 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 675 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 111 0.08 2.44 0 0 0 0 Execute 389 0.00 0.13 4 20 0 0 Fetch 526 0.25 27.76 2413 85377 66 313 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1026 0.33 30.33 2417 85397 66 313 Misses in library cache during parse: 3 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 2 0 1 Misses in library cache during parse: 0 113 user SQL statements in session. 1 internal SQL statements in session. 114 SQL statements in session. ******************************************************************************** Trace file: e:\orant\rdbms80\trace\ora02532.trc Trace file compatibility: 7.03.02 Sort options: default 1 session in tracefile. 113 user SQL statements in trace file. 1 internal SQL statements in trace file. 114 SQL statements in trace file. 44 unique SQL statements in trace file. 1688 lines in trace file.