Trace file: orcl_ora_1908.trc Sort options: prsdsk exedsk fchdsk execpu fchcpu ******************************************************************************** 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 DISTINCT PM.PARTY_CODE, PM.PARTY_NAME, PM.PARTY_CODE STATUS_CUST, PM.DEFAULTPURCHASER FROM PR_INDENT_DET ID_DET, PR_INDENT_MAST ID_MAST, ITEM ITM, EMPLOYEE EMP, ( SELECT POI.INDENT_NO, POI.INDENT_DATE, POI.ITEM_CODE, POI.QTY_ORD - NVL (T.EXTENDED_QTY, :"SYS_B_00") QTY_ORD FROM PURCHASE_ORDER PO, PURCHASE_ORDER_ITEM POI, ( SELECT PO_NO, PO_DATE, ITEM_CODE, SUM (NVL (EXTENDED_QTY, :"SYS_B_01")) EXTENDED_QTY, INDENT_NO, INDENT_DATE FROM TBL_PO_ADJUSTMENT GROUP BY PO_NO, PO_DATE, ITEM_CODE, INDENT_NO, INDENT_DATE) T WHERE PO.PO_NO = POI.PO_NO AND PO.PO_DATE = POI.PO_DATE AND POI.PO_NO = T.PO_NO(+) AND POI.PO_DATE = T.PO_DATE(+) AND POI.INDENT_NO = T.INDENT_NO(+) AND POI.INDENT_DATE = T.INDENT_DATE(+) AND POI.ITEM_CODE = T.ITEM_CODE(+) AND PO.CANC_STATUS = :"SYS_B_02" AND PO.CCODE = :"SYS_B_03" AND NVL (POI.APPROVAL_STATUS, :"SYS_B_04") = :"SYS_B_05" ORDER BY :"SYS_B_06" DESC) POI, PARTY_MASTER PM, ACCOUNT A, (SELECT Q.QUOT_COMP_NO, Q.QUOT_COMP_DATE, Q.SUPP_CODE, ITEM.PART_NO, ITEM.CCODE FROM QUOT_COMPARISON_DTL Q, QUOT_COMPARISON_MST QM, ( SELECT MAX (Q.QUOT_COMP_NO) QUOT_COMP_NO, Q.QUOT_COMP_DATE, Q.ITEM_CODE, M.CCODE FROM QUOT_COMPARISON_DTL Q, QUOT_COMPARISON_MST M, ( SELECT MAX (QM.QUOT_COMP_DATE) QUOT_COMP_DATE, ITEM_CODE, CCODE FROM QUOT_COMPARISON_DTL QD, QUOT_COMPARISON_MST QM WHERE QM.QUOT_COMP_NO = QD.QUOT_COMP_NO AND QM.QUOT_COMP_DATE = QD.QUOT_COMP_DATE AND QM.CCODE = :"SYS_B_07" GROUP BY QD.ITEM_CODE, QM.CCODE) MAX_DATE WHERE M.QUOT_COMP_NO = Q.QUOT_COMP_NO AND M.QUOT_COMP_DATE = Q.QUOT_COMP_DATE AND Q.QUOT_COMP_DATE = MAX_DATE.QUOT_COMP_DATE AND Q.ITEM_CODE = MAX_DATE.ITEM_CODE AND M.CCODE = :"SYS_B_08" GROUP BY Q.QUOT_COMP_DATE, Q.ITEM_CODE, M.CCODE) MAX_NO, ITEM WHERE QM.QUOT_COMP_NO = Q.QUOT_COMP_NO AND QM.QUOT_COMP_DATE = Q.QUOT_COMP_DATE AND QM.CCODE = :"SYS_B_09" AND Q.QUOT_COMP_NO = MAX_NO.QUOT_COMP_NO AND Q.QUOT_COMP_DATE = MAX_NO.QUOT_COMP_DATE AND Q.ITEM_CODE = MAX_NO.ITEM_CODE AND SUPP_TYPE = :"SYS_B_10" AND Q.ITEM_CODE = ITEM.ITEM_CODE AND ITEM.CCODE = :"SYS_B_11") IVD WHERE ID_MAST.INDENT_NO = ID_DET.INDENT_NO AND A.SUPP_CODE = PM.PARTY_CODE AND A.CCODE = PM.CCODE AND A.FREEZE = :"SYS_B_12" AND ID_MAST.INDENT_DATE = ID_DET.INDENT_DATE AND ID_DET.ITEM_CODE = ITM.ITEM_CODE AND ID_MAST.CCODE = :"SYS_B_13" AND ITM.CCODE = :"SYS_B_14" AND ID_MAST.APPROVAL_STATUS = :"SYS_B_15" AND ID_MAST.FYCODE = :"SYS_B_16" AND ID_MAST.EMPLOYEE_CODE = EMP.EMPLOYEE_CODE AND ITM.PART_NO = IVD.PART_NO AND IVD.SUPP_CODE = PM.PARTY_CODE AND ID_DET.INDENT_NO = POI.INDENT_NO(+) AND ID_DET.INDENT_DATE = POI.INDENT_DATE(+) AND ID_DET.ITEM_CODE = POI.ITEM_CODE(+) AND ITM.PART_NO IN (SELECT PART_NO FROM ITEM WHERE STORE_CODE = :"SYS_B_17") AND ITM.STORE_CODE = :"SYS_B_18" GROUP BY ID_DET.IND_SEQ_NO, ID_DET.INDENT_NO, ID_DET.INDENT_DATE, ID_DET.ITEM_CODE, ID_DET.ITEM_RATE, ID_DET.IND_QTY, ID_MAST.EMPLOYEE_CODE, ITM.ITEM_NAME, EMP.EMPLOYEE_NAME, ID_DET.IND_PURPOSE, IVD.SUPP_CODE, ITM.STORE_CODE, PM.PARTY_CODE, PM.PARTY_NAME, PM.DEFAULTPURCHASER HAVING (ID_DET.IND_QTY - NVL (SUM (POI.QTY_ORD), :"SYS_B_19")) > :"SYS_B_20" ORDER BY :"SYS_B_21" 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 1 0.00 0.00 0 0 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 22 Misses in library cache during parse: 0 Parsing user id: 56 (???) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5366 1.14 37.06 direct path write temp 12 0.00 0.00 direct path read temp 12 0.00 0.07 SQL*Net message from client 1 0.00 0.00 SQL*Net message to client 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 1 0.00 0.00 0 0 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 22 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 5366 1.14 37.06 direct path write temp 12 0.00 0.00 direct path read temp 12 0.00 0.07 SQL*Net message from client 1 0.00 0.00 SQL*Net message to client 1 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 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 1 user SQL statements in session. 0 internal SQL statements in session. 1 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: orcl_ora_1908.trc Trace file compatibility: 10.01.00 Sort options: prsdsk exedsk fchdsk execpu fchcpu 2 sessions in tracefile. 1 user SQL statements in trace file. 0 internal SQL statements in trace file. 1 SQL statements in trace file. 1 unique SQL statements in trace file. 5629 lines in trace file. 0 elapsed seconds in trace file.