SELECT DISTINCT pll.po_line_id, ploc.line_location_id, (SELECT ptl.line_type FROM apps.po_line_types_tl ptl WHERE ptl.line_type_id = pll.line_type_id AND ptl.LANGUAGE = 'US') "Line_Type", ploc.quantity_accepted, NULL release_approved_date, NULL release_date, NULL release_hold_flag, NULL release_type, DECODE (ploc.po_release_id, NULL, NULL, ploc.quantity) released_quantity, (SELECT items.preprocessing_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "PreProcessing_LT", (SELECT items.full_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "Processing_LT", (SELECT items.postprocessing_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "PostProcessing_LT", ploc.firm_status_lookup_code, NVL ( (SELECT pla.promised_date FROM apps.po_line_locations_archive_all pla WHERE pla.po_header_id = pha.po_header_id AND pla.po_line_id = pll.po_line_id AND pla.line_location_id = ploc.line_location_id AND pla.revision_num = (SELECT MIN (revision_num) FROM apps.po_line_locations_archive_all plla2 WHERE plla2.promised_date IS NOT NULL AND plla2.line_location_id = ploc.line_location_id)), ploc.promised_date) "Original_Promise_Date", (SELECT items.long_description FROM apps.mtl_system_items_tl items WHERE items.inventory_item_id = pll.item_id AND items.organization_id IN (SELECT fin.inventory_organization_id FROM apps.financials_system_params_all fin WHERE fin.org_id = pha.org_id) AND items.LANGUAGE = 'US') "Item_Long_Description", NVL (ploc.approved_flag, 'N') approved_code, pvs.country "Supplier_Site_Country", pll.note_to_vendor, NVL (ploc.quantity, 0) - NVL (ploc.quantity_cancelled, 0) - NVL (ploc.quantity_received, 0) * ploc.price_override "Shipment_Amount", ploc.attribute4 "PO_Ship_Date", (SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_type = 'SHIP_METHOD' AND lookup_code = ploc.attribute9 AND language = 'US') "Ship_Method", (SELECT prla.note_to_receiver FROM apps.po_req_distributions_all prda INNER JOIN apps.po_requisition_lines_all prla ON prda.requisition_line_id = prla.requisition_line_id WHERE prda.distribution_id = pdi.req_distribution_id) "Note_To_Receiver", DECODE (pha.USER_HOLD_FLAG, 'Y', 'Y', pll.USER_HOLD_FLAG) "Hold_Flag", (SELECT ABC_CLASS_NAME FROM APPS.MTL_ABC_ASSIGNMENT_GROUPS ASG INNER JOIN APPS.MTL_ABC_ASSIGNMENTS ASSI ON ASG.ASSIGNMENT_GROUP_ID = ASSI.ASSIGNMENT_GROUP_ID INNER JOIN APPS.MTL_ABC_CLASSES classes ON ASSI.ABC_CLASS_ID = classes.ABC_CLASS_ID WHERE ASG.organization_id = ploc.SHIP_TO_ORGANIZATION_ID AND ASG.ASSIGNMENT_GROUP_NAME = 'MIN ABC Assignment' AND ASSI.inventory_item_id = pll.item_id) ABCClass, (SELECT CONCATENATED_SEGMENTS AS charge_accountsfrom FROM apps.gl_code_combinations_kfv gcc WHERE gcc.code_combination_id = pdi.code_combination_id) AS charge_accounts FROM apps.po_headers_all pha, apps.po_lines_all pll, apps.po_line_locations_all ploc, apps.po_distributions_all pdi, apps.per_all_people_f papf, apps.AP_SUPPLIERS pv, apps.AP_SUPPLIER_SITES_ALL pvs, apps.AP_SUPPLIER_CONTACTS pvc, apps.ap_terms apt, apps.po_lookup_codes plc1, apps.po_lookup_codes plc2, apps.hr_locations hlv_line_ship_to, apps.hr_locations hlv_ship_to, apps.hr_locations hlv_bill_to, apps.hr_organization_units hou, apps.hr_locations_no_join loc, apps.hr_locations_all_tl hrl1, apps.hr_locations_all_tl hrl2 WHERE 1 = 1 AND pll.po_header_id(+) = pha.po_header_id AND ploc.po_line_id(+) = pll.po_line_id AND pdi.line_location_id(+) = ploc.line_location_id AND ploc.shipment_type IN ('STANDARD', 'PLANNED') AND papf.person_id(+) = pha.agent_id AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.employee_number IS NOT NULL AND pv.vendor_id(+) = pha.vendor_id AND pvs.vendor_site_id(+) = pha.vendor_site_id AND pvc.vendor_contact_id(+) = pha.vendor_contact_id AND apt.term_id(+) = pha.terms_id AND plc1.lookup_code(+) = pha.fob_lookup_code AND plc1.lookup_type(+) = 'FOB' AND plc2.lookup_code(+) = pha.freight_terms_lookup_code AND plc2.lookup_type(+) = 'FREIGHT TERMS' AND hlv_line_ship_to.location_id(+) = ploc.ship_to_location_id AND hlv_ship_to.location_id(+) = pha.ship_to_location_id AND hlv_bill_to.location_id(+) = pha.bill_to_location_id AND hou.organization_id = pha.org_id AND hou.location_id = loc.location_id(+) AND hrl1.location_id(+) = pha.ship_to_location_id AND hrl1.LANGUAGE(+) = 'US' AND hrl2.location_id(+) = pha.bill_to_location_id AND hrl2.LANGUAGE(+) = 'US' AND hou.organization_id IN (2763) AND NVL (pha.closed_code, 'OPEN') IN ('OPEN', 'CLOSED') AND NVL (pll.closed_code, 'OPEN') IN ('OPEN', 'CLOSED') AND NVL (ploc.cancel_flag, 'N') = 'N' AND pha.authorization_status IN ('APPROVED', 'REQUIRES REAPPROVAL', 'IN PROCESS') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.46 1.75 0 3 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 50346 279.02 1059.39 179103 30146895 0 755164 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 50348 279.49 1061.14 179103 30146898 0 755164 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 678 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 9 9 9 TABLE ACCESS BY INDEX ROWID PO_LINE_TYPES_TL (cr=20 pr=0 pw=0 time=680 us cost=2 size=32 card=1) 9 9 9 INDEX UNIQUE SCAN PO_LINE_TYPES_TL_U1 (cr=11 pr=0 pw=0 time=323 us cost=1 size=0 card=1)(object id 63682480) 576365 576365 576365 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=2267756 pr=28 pw=0 time=22598079 us cost=4 size=13 card=1) 576365 576365 576365 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=1720936 pr=0 pw=0 time=4644552 us cost=3 size=0 card=1)(object id 42812859) 576365 576365 576365 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=2267747 pr=0 pw=0 time=2442479 us cost=4 size=13 card=1) 576365 576365 576365 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=1720936 pr=0 pw=0 time=1238342 us cost=3 size=0 card=1)(object id 42812859) 576365 576365 576365 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B (cr=2267743 pr=0 pw=0 time=2029190 us cost=4 size=14 card=1) 576365 576365 576365 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=1720932 pr=0 pw=0 time=967729 us cost=3 size=0 card=1)(object id 42812859) 672743 672743 672743 TABLE ACCESS BY INDEX ROWID PO_LINE_LOCATIONS_ARCHIVE_ALL (cr=5507736 pr=163043 pw=0 time=535914552 us cost=3 size=27 card=1) 672743 672743 672743 INDEX UNIQUE SCAN PO_LINE_LOCATIONS_ARCHIVE_U1 (cr=4560824 pr=163043 pw=0 time=533161038 us cost=2 size=0 card=1)(object id 42811947) 755121 755121 755121 SORT AGGREGATE (cr=3540960 pr=163043 pw=0 time=530079821 us) 1040963 1040963 1040963 TABLE ACCESS BY INDEX ROWID PO_LINE_LOCATIONS_ARCHIVE_ALL (cr=3540960 pr=163043 pw=0 time=534243973 us cost=5 size=15 card=1) 1776649 1776649 1776649 INDEX RANGE SCAN PO_LINE_LOCATIONS_ARCHIVE_U1 (cr=1123074 pr=6392 pw=0 time=37128373 us cost=3 size=0 card=2)(object id 42811947) 587486 587486 587486 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_TL (cr=3436629 pr=3564 pw=0 time=64125044 us cost=5 size=34 card=1) 587486 587486 587486 INDEX RANGE SCAN MTL_SYSTEM_ITEMS_TL_U1 (cr=2852930 pr=869 pw=0 time=45628505 us cost=4 size=0 card=1)(object id 136492495) 1 1 1 TABLE ACCESS BY INDEX ROWID FINANCIALS_SYSTEM_PARAMS_ALL (cr=645351 pr=0 pw=0 time=5743158 us cost=2 size=10 card=1) 322268 322268 322268 INDEX SKIP SCAN FINANCIALS_SYSTEM_PARAMS_U1 (cr=323083 pr=0 pw=0 time=5104895 us cost=1 size=0 card=1)(object id 42770563) 10 10 10 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=51 pr=1 pw=0 time=3620 us cost=5 size=60 card=1) 20 20 20 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=31 pr=1 pw=0 time=2133 us cost=4 size=0 card=1)(object id 42759866) 634276 634276 634276 NESTED LOOPS (cr=3540930 pr=5535 pw=0 time=181518759 us cost=5 size=28 card=1) 634276 634276 634276 TABLE ACCESS BY INDEX ROWID PO_REQ_DISTRIBUTIONS_ALL (cr=1631471 pr=5253 pw=0 time=65405333 us cost=3 size=12 card=1) 634276 634276 634276 INDEX UNIQUE SCAN PO_REQ_DISTRIBUTIONS_U1 (cr=994522 pr=5252 pw=0 time=31023194 us cost=2 size=0 card=1)(object id 42788583) 634276 634276 634276 TABLE ACCESS BY INDEX ROWID PO_REQUISITION_LINES_ALL (cr=1909459 pr=282 pw=0 time=115275921 us cost=2 size=16 card=1) 634276 634276 634276 INDEX UNIQUE SCAN PO_REQUISITION_LINES_U1 (cr=944449 pr=268 pw=0 time=12285440 us cost=1 size=0 card=1)(object id 42789681) 511989 511989 511989 NESTED LOOPS (cr=3533763 pr=6 pw=0 time=8999321 us cost=5 size=55 card=1) 511989 511989 511989 NESTED LOOPS (cr=2850293 pr=6 pw=0 time=7086027 us cost=4 size=45 card=1) 576055 576055 576055 TABLE ACCESS BY INDEX ROWID MTL_ABC_ASSIGNMENT_GROUPS (cr=612378 pr=0 pw=0 time=2002832 us cost=2 size=29 card=1) 576055 576055 576055 INDEX UNIQUE SCAN MTL_ABC_ASSIGNMENT_GROUPS_U2 (cr=36323 pr=0 pw=0 time=951307 us cost=1 size=0 card=1)(object id 42783622) 511989 511989 511989 TABLE ACCESS BY INDEX ROWID MTL_ABC_ASSIGNMENTS (cr=2237915 pr=6 pw=0 time=4672006 us cost=3 size=16 card=1) 511989 511989 511989 INDEX UNIQUE SCAN MTL_ABC_ASSIGNMENTS_U1 (cr=1551490 pr=4 pw=0 time=2533524 us cost=2 size=0 card=1)(object id 42757737) 511989 511989 511989 TABLE ACCESS BY INDEX ROWID MTL_ABC_CLASSES (cr=683470 pr=0 pw=0 time=1488045 us cost=1 size=10 card=1) 511989 511989 511989 INDEX UNIQUE SCAN MTL_ABC_CLASSES_U1 (cr=171481 pr=0 pw=0 time=693745 us cost=0 size=0 card=1)(object id 42789694) 13320 13320 13320 TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS (cr=34801 pr=0 pw=0 time=802675 us cost=3 size=49 card=1) 13320 13320 13320 INDEX UNIQUE SCAN GL_CODE_COMBINATIONS_U1 (cr=21481 pr=0 pw=0 time=397344 us cost=2 size=0 card=1)(object id 42775044) 755164 755164 755164 HASH UNIQUE (cr=30147018 pr=179103 pw=0 time=1058922684 us cost=749257 size=197349453 card=482517) 768890 768890 768890 HASH JOIN (cr=7289842 pr=6926 pw=0 time=244582512 us cost=696202 size=197349453 card=482517) 140451 140451 140451 TABLE ACCESS FULL PER_ALL_PEOPLE_F (cr=38207 pr=0 pw=0 time=313692 us cost=18484 size=13278261 card=428331) 768890 768890 768890 NESTED LOOPS OUTER (cr=7251635 pr=6926 pw=0 time=242897348 us cost=672652 size=30016980 card=79410) 755121 755121 755121 NESTED LOOPS OUTER (cr=5538283 pr=6031 pw=0 time=154841427 us cost=443987 size=28382903 card=78623) 755121 755121 755121 NESTED LOOPS OUTER (cr=5508916 pr=6031 pw=0 time=153523676 us cost=443982 size=18184959 card=51809) 755121 755121 755121 NESTED LOOPS OUTER (cr=5386279 pr=6031 pw=0 time=151985656 us cost=443978 size=11642422 card=34142) 755121 755121 755121 NESTED LOOPS (cr=5090949 pr=6031 pw=0 time=139220421 us cost=375644 size=11574138 card=34142) 792959 792959 792959 NESTED LOOPS (cr=1747964 pr=134 pw=0 time=64597738 us cost=109035 size=19934760 card=73560) 254919 254919 254919 HASH JOIN OUTER (cr=315780 pr=6 pw=0 time=14811187 us cost=29121 size=5413350 card=22650) 254919 254919 254919 NESTED LOOPS OUTER (cr=286919 pr=0 pw=0 time=12395919 us cost=13792 size=5209500 card=22650) 254919 254919 254919 HASH JOIN RIGHT OUTER (cr=107134 pr=0 pw=0 time=12153146 us cost=13790 size=3868572 card=17426) 3834 3834 3834 VIEW HR_LOCATIONS (cr=3913 pr=0 pw=0 time=15826 us cost=125 size=360 card=60) 3834 3834 3834 NESTED LOOPS (cr=3913 pr=0 pw=0 time=15055 us cost=125 size=1080 card=60) 3834 3834 3834 TABLE ACCESS FULL HR_LOCATIONS_ALL (cr=262 pr=0 pw=0 time=11211 us cost=125 size=304 card=38) 3834 3834 3834 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=3651 pr=0 pw=0 time=6183 us cost=0 size=20 card=2)(object id 42783719) 254919 254919 254919 HASH JOIN RIGHT OUTER (cr=103221 pr=0 pw=0 time=11917174 us cost=13666 size=3764016 card=17426) 3834 3834 3834 VIEW HR_LOCATIONS (cr=3898 pr=0 pw=0 time=14651 us cost=125 size=360 card=60) 3834 3834 3834 NESTED LOOPS (cr=3898 pr=0 pw=0 time=14267 us cost=125 size=1080 card=60) 3834 3834 3834 TABLE ACCESS FULL HR_LOCATIONS_ALL (cr=247 pr=0 pw=0 time=9532 us cost=125 size=304 card=38) 3834 3834 3834 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=3651 pr=0 pw=0 time=9539 us cost=0 size=20 card=2)(object id 42783719) 254919 254919 254919 HASH JOIN RIGHT OUTER (cr=99323 pr=0 pw=0 time=11817243 us cost=13541 size=3659460 card=17426) 45 45 45 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (cr=21 pr=0 pw=0 time=614 us cost=4 size=49 card=1)(object id 63685210) 254919 254919 254919 HASH JOIN RIGHT OUTER (cr=99302 pr=0 pw=0 time=11729251 us cost=13537 size=2805586 card=17426) 59 59 59 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (cr=20 pr=0 pw=0 time=445 us cost=4 size=49 card=1)(object id 63685210) 254919 254919 254919 NESTED LOOPS (cr=99282 pr=0 pw=0 time=11653162 us cost=13533 size=1951712 card=17426) 1 1 1 NESTED LOOPS OUTER (cr=116 pr=0 pw=0 time=113273 us cost=3 size=40 card=1) 1 1 1 NESTED LOOPS (cr=113 pr=0 pw=0 time=113227 us cost=2 size=32 card=1) 1 1 1 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=110 pr=0 pw=0 time=113164 us cost=1 size=17 card=1)(object id 63680720) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=3 pr=0 pw=0 time=59 us cost=1 size=15 card=1) 1 1 1 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=2 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 42789144) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_LOCATIONS_ALL (cr=3 pr=0 pw=0 time=42 us cost=1 size=8 card=1) 1 1 1 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=2 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 42797079) 254919 254919 254919 TABLE ACCESS BY INDEX ROWID PO_HEADERS_ALL (cr=99166 pr=0 pw=0 time=11505632 us cost=13530 size=1254672 card=17426) 255397 255397 255397 INDEX SKIP SCAN PO_HEADERS_ALL_X3 (cr=1753 pr=0 pw=0 time=725236 us cost=352 size=0 card=37674)(object id 42773719) 254883 254883 254883 INDEX UNIQUE SCAN AP_TERMS_TL_U1 (cr=179785 pr=0 pw=0 time=183291 us cost=0 size=8 card=1)(object id 42798416) 482528 482528 482528 TABLE ACCESS FULL AP_SUPPLIER_SITES_ALL (cr=28861 pr=6 pw=0 time=227983 us cost=13727 size=4323123 card=480347) 792959 792959 792959 TABLE ACCESS BY INDEX ROWID PO_LINES_ALL (cr=1432184 pr=128 pw=0 time=53002963 us cost=5 size=96 card=3) 793375 793375 793375 INDEX RANGE SCAN PO_LINES_U2 (cr=504726 pr=20 pw=0 time=17603112 us cost=2 size=0 card=5)(object id 42755253) 755121 755121 755121 TABLE ACCESS BY INDEX ROWID PO_LINE_LOCATIONS_ALL (cr=3342985 pr=5897 pw=0 time=71357938 us cost=4 size=68 card=1) 1138558 1138558 1138558 INDEX RANGE SCAN PO_LINE_LOCATIONS_N15 (cr=1707311 pr=5830 pw=0 time=37903421 us cost=3 size=0 card=2)(object id 63697005) 723002 723002 723002 VIEW PUSHED PREDICATE HR_LOCATIONS (cr=295330 pr=0 pw=0 time=11391536 us cost=2 size=2 card=1) 723002 723002 723002 NESTED LOOPS (cr=295330 pr=0 pw=0 time=11004720 us cost=2 size=18 card=1) 723002 723002 723002 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=146911 pr=0 pw=0 time=1391389 us cost=1 size=10 card=1)(object id 42783719) 723002 723002 723002 TABLE ACCESS BY INDEX ROWID HR_LOCATIONS_ALL (cr=148419 pr=0 pw=0 time=9233363 us cost=1 size=8 card=1) 723002 723002 723002 INDEX UNIQUE SCAN HR_LOCATIONS_PK (cr=117800 pr=0 pw=0 time=836734 us cost=0 size=0 card=1)(object id 42797079) 755119 755119 755119 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=122637 pr=0 pw=0 time=829404 us cost=0 size=20 card=2)(object id 42783719) 755121 755121 755121 INDEX UNIQUE SCAN HR_LOCATIONS_ALL_TL_PK (cr=29367 pr=0 pw=0 time=716408 us cost=0 size=20 card=2)(object id 42783719) 768883 768883 768883 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL (cr=1713352 pr=895 pw=0 time=75314769 us cost=3 size=17 card=1) 768883 768883 768883 INDEX RANGE SCAN PO_DISTRIBUTIONS_N1 (cr=1096671 pr=874 pw=0 time=24392643 us cost=2 size=0 card=1)(object id 42782429) EXPLAIN PLAN SET STATEMENT_ID='PLUS1711339597' FOR SELECT DISTINCT pll.po_line_id, ploc.line_location_id, (SELECT ptl.line_type FROM apps.po_line_types_tl ptl WHERE ptl.line_type_id = pll.line_type_id AND ptl.LANGUAGE = 'US') "Line_Type", ploc.quantity_accepted, NULL release_approved_date, NULL release_date, NULL release_hold_flag, NULL release_type, DECODE (ploc.po_release_id, NULL, NULL, ploc.quantity) released_quantity, (SELECT items.preprocessing_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "PreProcessing_LT", (SELECT items.full_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "Processing_LT", (SELECT items.postprocessing_lead_time FROM apps.mtl_system_items_b items WHERE items.inventory_item_id = pll.item_id AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID) "PostProcessing_LT", ploc.firm_status_lookup_code, NVL ( (SELECT pla.promised_date FROM apps.po_line_locations_archive_all pla WHERE pla.po_header_id = pha.po_header_id AND pla.po_line_id = pll.po_line_id AND pla.line_location_id = ploc.line_location_id AND pla.revision_num = (SELECT MIN (revision_num) FROM apps.po_line_locations_archive_all plla2 WHERE plla2.promised_date IS NOT NULL AND plla2.line_location_id = ploc.line_location_id)), ploc.promised_date) "Original_Promise_Date", (SELECT items.long_description FROM apps.mtl_system_items_tl items WHERE items.inventory_item_id = pll.item_id AND items.organization_id IN (SELECT fin.inventory_organization_id FROM apps.financials_system_params_all fin WHERE fin.org_id = pha.org_id) AND items.LANGUAGE = 'US') "Item_Long_Description", NVL (ploc.approved_flag, 'N') approved_code, pvs.country "Supplier_Site_Country", pll.note_to_vendor, NVL (ploc.quantity, 0) - NVL (ploc.quantity_cancelled, 0) - NVL (ploc.quantity_received, 0) * ploc.price_override "Shipment_Amount", ploc.attribute4 "PO_Ship_Date", (SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_type = 'SHIP_METHOD' AND lookup_code = ploc.attribute9 AND language = 'US') "Ship_Method", (SELECT prla.note_to_receiver FROM apps.po_req_distributions_all prda INNER JOIN apps.po_requisition_lines_all prla ON prda.requisition_line_id = prla.requisition_line_id WHERE prda.distribution_id = pdi.req_distribution_id) "Note_To_Receiver", DECODE (pha.USER_HOLD_FLAG, 'Y', 'Y', pll.USER_HOLD_FLAG) "Hold_Flag", (SELECT ABC_CLASS_NAME FROM APPS.MTL_ABC_ASSIGNMENT_GROUPS ASG INNER JOIN APPS.MTL_ABC_ASSIGNMENTS ASSI ON ASG.ASSIGNMENT_GROUP_ID = ASSI.ASSIGNMENT_GROUP_ID INNER JOIN APPS.MTL_ABC_CLASSES classes ON ASSI.ABC_CLASS_ID = classes.ABC_CLASS_ID WHERE ASG.organization_id = ploc.SHIP_TO_ORGANIZATION_ID AND ASG.ASSIGNMENT_GROUP_NAME = 'MIN ABC Assignment' AND ASSI.inventory_item_id = pll.item_id) ABCClass, (SELECT CONCATENATED_SEGMENTS AS charge_accountsfrom FROM apps.gl_code_combinations_kfv gcc WHERE gcc.code_combination_id = pdi.code_combination_id) AS charge_accounts FROM apps.po_headers_all pha, apps.po_lines_all pll, apps.po_line_locations_all ploc, apps.po_distributions_all pdi, apps.per_all_people_f papf, apps.AP_SUPPLIERS pv, apps.AP_SUPPLIER_SITES_ALL pvs, apps.AP_SUPPLIER_CONTACTS pvc, apps.ap_terms apt, apps.po_lookup_codes plc1, apps.po_lookup_codes plc2, apps.hr_locations hlv_line_ship_to, apps.hr_locations hlv_ship_to, apps.hr_locations hlv_bill_to, apps.hr_organization_units hou, apps.hr_locations_no_join loc, apps.hr_locations_all_tl hrl1, apps.hr_locations_all_tl hrl2 WHERE 1 = 1 AND pll.po_header_id(+) = pha.po_header_id AND ploc.po_line_id(+) = pll.po_line_id AND pdi.line_location_id(+) = ploc.line_location_id AND ploc.shipment_type IN ('STANDARD', 'PLANNED') AND papf.person_id(+) = pha.agent_id AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.employee_number IS NOT NULL AND pv.vendor_id(+) = pha.vendor_id AND pvs.vendor_site_id(+) = pha.vendor_site_id AND pvc.vendor_contact_id(+) = pha.vendor_contact_id AND apt.term_id(+) = pha.terms_id AND plc1.lookup_code(+) = pha.fob_lookup_code AND plc1.lookup_type(+) = 'FOB' AND plc2.lookup_code(+) = pha.freight_terms_lookup_code AND plc2.lookup_type(+) = 'FREIGHT TERMS' AND hlv_line_ship_to.location_id(+) = ploc.ship_to_location_id AND hlv_ship_to.location_id(+) = pha.ship_to_location_id AND hlv_bill_to.location_id(+) = pha.bill_to_location_id AND hou.organization_id = pha.org_id AND hou.location_id = loc.location_id(+) AND hrl1.location_id(+) = pha.ship_to_location_id AND hrl1.LANGUAGE(+) = 'US' AND hrl2.location_id(+) = pha.bill_to_location_id AND hrl2.LANGUAGE(+) = 'US' AND hou.organization_id IN (2763) AND NVL (pha.closed_code, 'OPEN') IN ('OPEN', 'CLOSED') AND NVL (pll.closed_code, 'OPEN') IN ('OPEN', 'CLOSED') AND NVL (ploc.cancel_flag, 'N') = 'N' AND pha.authorization_status IN ('APPROVED', 'REQUIRES REAPPROVAL', 'IN PROCESS') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.38 0.39 0 3 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.39 0.39 0 3 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 678 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 0.00 0.00 ******************************************************************************** SQL ID: 8sd1v66dnj4m4 Plan Hash: 238457506 select inst_id, blk_num, blk_seq, blk_dat from gv$result_cache_rd where inst_id = :1 and key = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.05 0 0 0 0 Fetch 10 0.00 0.03 0 0 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.00 0.09 0 0 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 PX COORDINATOR (cr=0 pr=0 pw=0 time=34314 us cost=0 size=583 card=1) 0 0 0 PX SEND QC (RANDOM) :TQ10000 (cr=0 pr=0 pw=0 time=0 us cost=0 size=583 card=1) 0 0 0 VIEW GV$RESULT_CACHE_RD (cr=0 pr=0 pw=0 time=0 us) 0 0 0 FIXED TABLE FIXED INDEX X$QESRCRD (ind:1) (cr=0 pr=0 pw=0 time=0 us cost=0 size=583 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ enq: PS - contention 13 0.01 0.02 PX Deq: reap credit 72 0.01 0.01 PX Deq: Join ACK 5 0.01 0.02 PX Deq: Parse Reply 5 0.00 0.01 PX Deq: Execute Reply 5 0.00 0.00 reliable message 10 0.00 0.01 PX Deq: Signal ACK RSG 5 0.00 0.00 PX Deq: Signal ACK EXT 5 0.00 0.00 IPC send completion sync 5 0.00 0.00 PX Deq: Slave Session Stats 5 0.00 0.00 KJC: Wait for msg sends to complete 3 0.00 0.00 ******************************************************************************** SQL ID: 99qa3zyarxvms Plan Hash: 0 insert into plan_table (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other,optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml ) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21, :22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 85 0.03 0.03 0 10 148 85 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 86 0.03 0.03 0 10 148 85 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=0 pw=0 time=420 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ enq: TO - contention 2 0.00 0.00 enq: TT - contention 1 0.00 0.00 Disk file operations I/O 2 0.00 0.00 CSS operation: action 2 0.00 0.00 CSS initialization 1 0.00 0.00 CSS operation: query 6 0.00 0.00 direct path write temp 1 0.00 0.00 gc current grant 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: 1mjd9xp80vuqa Plan Hash: 3023518864 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 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.03 0 24 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.03 0 24 0 6 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=4 pr=0 pw=0 time=28 us cost=3 size=30 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=3 pr=0 pw=0 time=11 us cost=2 size=0 card=1)(object id 77) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 gc current block 2-way 2 0.00 0.00 gc current block 3-way 2 0.01 0.03 ******************************************************************************** SQL ID: 9dsuyxzwbqhkh Plan Hash: 1610166289 SELECT ev_col_id, base_tbl_col_name FROM evcol$ WHERE ev_obj#=:1 ORDER BY ev_col_id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 431 0.00 0.00 0 868 0 425 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 438 0.00 0.02 0 868 0 425 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 32 32 32 TABLE ACCESS BY INDEX ROWID EVCOL$ (cr=67 pr=0 pw=0 time=20 us cost=5 size=750 card=30) 32 32 32 INDEX RANGE SCAN I_EVCOL1 (cr=35 pr=0 pw=0 time=77 us cost=3 size=0 card=30)(object id 131) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.01 0.01 gc current block 2-way 2 0.00 0.00 gc current block 3-way 7 0.00 0.00 ******************************************************************************** SQL ID: 2xyb5d6xg9srh Plan Hash: 785096182 select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 70 0.00 0.00 0 0 0 0 Execute 70 0.00 0.00 0 0 0 0 Fetch 77 0.00 0.02 0 168 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 217 0.00 0.02 0 168 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=6 us cost=2 size=12 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ row cache lock 1 0.00 0.00 library cache lock 2 0.00 0.00 library cache pin 2 0.00 0.00 gc current block 3-way 7 0.01 0.02 ******************************************************************************** SQL ID: d4f616c4jc9up Plan Hash: 4294204668 SELECT base_tbl_owner#, base_tbl_name FROM ev$ WHERE ev_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 15 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.02 0 15 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID EV$ (cr=3 pr=0 pw=0 time=11 us cost=2 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN I_EV1 (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 128) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.01 0.01 gc current block 3-way 1 0.00 0.00 gc current block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: g3wrkmxkxzhf2 Plan Hash: 749386351 select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.01 0 28 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.01 0 28 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID VIEW$ (cr=4 pr=0 pw=0 time=1149 us cost=3 size=60 card=1) 1 1 1 INDEX UNIQUE SCAN I_VIEW1 (cr=3 pr=0 pw=0 time=1129 us cost=2 size=0 card=1)(object id 75) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 KJC: Wait for msg sends to complete 1 0.00 0.00 library cache pin 1 0.00 0.00 gc current block 3-way 2 0.01 0.01 gc current block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: bd4bznqbq73hk Plan Hash: 2595917966 select bo#, intcol# from icoldep$ where obj#=: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 10 0.00 0.00 0 20 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.01 0 20 0 9 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 9 9 9 TABLE ACCESS BY INDEX ROWID ICOLDEP$ (cr=20 pr=0 pw=0 time=18 us cost=2 size=45 card=3) 9 9 9 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=11 pr=0 pw=0 time=22 us cost=1 size=0 card=3)(object id 115) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 2 0.00 0.00 library cache pin 2 0.00 0.01 KJC: Wait for msg sends to complete 1 0.00 0.00 ******************************************************************************** SQL ID: dm5qmv0xq5qbn Plan Hash: 1191833520 select obj# from obj$ o where name=:1 and owner#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.01 0 32 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.00 0.01 0 32 0 8 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=4 pr=0 pw=0 time=10 us cost=4 size=31 card=1)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 2-way 1 0.01 0.01 ******************************************************************************** SQL ID: f0a1c90fu7jtd Plan Hash: 1388734953 SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ extractvalue(xmlval, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "sql_patch"]'), extractvalue(xmlval, '/*/info[@type = "baseline"]'), extractvalue(xmlval, '/*/info[@type = "outline"]'), extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'), extractvalue(xmlval, '/*/info[@type = "dop"]'), extractvalue(xmlval, '/*/info[@type = "dop_reason"]'), extractvalue(xmlval, '/*/info[@type = "queuing_reason"]'), extractvalue(xmlval, '/*/info[@type = "row_shipping"]') , extractvalue(xmlval, '/*/info[@type = "index_size"]'), extractvalue(xmlval, '/*/info[@type = "result_checksum"]'), extractvalue(xmlval, '/*/info[@type = "cardinality_feedback"]'), extractvalue(xmlval, '/*/info[@type = "xml_suboptimal"]'), extractvalue(xmlval,'/*/info[@type = "plan_hash"]') from (select xmltype(:v_other_xml) xmlval from dual) 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 1 0.01 0.01 0 297 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 0 297 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 2q93zsrvbdw48 Plan Hash: 2874733959 select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 271 0.00 0.01 1 97 0 256 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 287 0.00 0.01 1 97 0 256 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 3-way 3 0.00 0.00 gc current block 2-way 3 0.00 0.00 gc cr grant 2-way 1 0.00 0.00 db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 9rfqm06xmuwu0 Plan Hash: 832500465 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 48 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.01 0 48 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SELECT /*+ opt_param('parallel_execution_enabled','false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth, operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost , time, partition_start, partition_stop, object_node, other_tag, distribution, projection, access_predicates, filter_predicates , other, qblock_name, object_alias, nvl(other_xml, remarks) other_xml, null sql_profile, null sql_plan_baseline, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null from PLAN_TABLE where plan_id = (select max(plan_id) from PLAN_TABLE where id=0 and statement_id = :stmt_id) order by 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 0 0 0 0 Fetch 86 0.00 0.00 4 18 26 85 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 88 0.00 0.01 4 18 26 85 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 85 85 85 SORT ORDER BY (cr=91 pr=5 pw=0 time=30539 us cost=5 size=10840 card=1) 85 85 85 TABLE ACCESS FULL PLAN_TABLE$ (cr=14 pr=0 pw=0 time=135 us cost=2 size=10840 card=1) 1 1 1 SORT AGGREGATE (cr=7 pr=0 pw=0 time=33 us) 1 1 1 TABLE ACCESS FULL PLAN_TABLE$ (cr=7 pr=0 pw=0 time=29 us cost=2 size=43 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ direct path read temp 4 0.00 0.00 ******************************************************************************** SQL ID: 15knr3nbjkrcw Plan Hash: 2501920895 SELECT ORA_PLAN_ID_SEQ$.NEXTVAL FROM DUAL 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 0 0 1 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 1 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE ORA_PLAN_ID_SEQ$ (cr=5 pr=0 pw=0 time=5060 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 row cache lock 2 0.00 0.00 ******************************************************************************** SQL ID: 8ka48qwy5qcua Plan Hash: 0 begin :con := "EMR_HIDE_COLUMN_DATA_FUNC"(:sn, :on); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 36 0.00 0.00 0 0 0 0 Execute 36 0.00 0.00 0 0 0 8 Fetch 28 0.00 0.00 0 56 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 100 0.00 0.00 0 56 0 8 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) ******************************************************************************** SQL ID: g3f3cw3zy5aat Plan Hash: 992138068 SELECT PLAN_TABLE_OUTPUT FROM TABLE(CAST(DBMS_XPLAN.PREPARE_RECORDS(:B1 , :B2 ) AS SYS.DBMS_XPLAN_TYPE_TABLE)) 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 2 0.00 0.00 0 15 20 165 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 15 20 165 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 165 165 165 COLLECTION ITERATOR PICKLER FETCH PREPARE_RECORDS (cr=403 pr=5 pw=0 time=49530 us cost=49 size=16336 card=8168) ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 1423211129 select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 74 0.00 0.00 0 0 0 0 Execute 74 0.00 0.00 0 0 0 0 Fetch 74 0.00 0.00 0 155 0 46 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 222 0.00 0.00 0 155 0 46 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=27 us cost=7 size=76 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=26 us cost=6 size=47 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=26 us cost=2 size=16 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=4 size=31 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=29 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 2874733959 select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) 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 1 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 15 0.00 0.00 0 45 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31 0.00 0.00 0 45 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 3-way 6 0.00 0.00 gc current block 2-way 2 0.00 0.00 ******************************************************************************** SQL ID: 9g485acn2n30m Plan Hash: 3483575214 select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc 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 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID REFCON$ (cr=1 pr=0 pw=0 time=8 us cost=2 size=42 card=3) 0 0 0 INDEX RANGE SCAN I_REFCON2 (cr=1 pr=0 pw=0 time=7 us cost=1 size=0 card=3)(object id 94) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 KJC: Wait for msg sends to complete 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: 0fr8zhn4ymu3v Plan Hash: 1231101765 select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 20 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 20 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: 6qz82dptj0qr7 Plan Hash: 2819763574 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 11 0.00 0.00 0 48 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31 0.00 0.00 0 48 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 1 SORT ORDER BY (cr=4 pr=0 pw=0 time=12 us cost=4 size=110 card=2) 0 0 1 TABLE ACCESS CLUSTER LOB$ (cr=4 pr=0 pw=0 time=7 us cost=3 size=110 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=4 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 30qw3zbtwhn3d Plan Hash: 509061060 select gname,pname,stmt_type,check_opt,enable_flag,pfschma,ppname,pfname from rls$ 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 2 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID RLS$ (cr=4 pr=0 pw=0 time=13 us cost=2 size=69 card=1) 1 1 1 INDEX RANGE SCAN I_RLS2 (cr=3 pr=0 pw=0 time=10 us cost=1 size=0 card=1)(object id 377) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 KJC: Wait for msg sends to complete 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3755742892 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 27 0.00 0.00 0 0 0 0 Fetch 27 0.00 0.00 0 108 0 27 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 55 0.00 0.00 0 108 0 27 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=0 pw=0 time=12 us cost=3 size=72 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=0 pw=0 time=8 us cost=2 size=0 card=1)(object id 9) ******************************************************************************** SQL ID: g72kdvcacxvtf Plan Hash: 2637181423 DELETE FROM PLAN_TABLE WHERE STATEMENT_ID=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 7 104 85 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 7 104 85 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE PLAN_TABLE$ (cr=0 pr=0 pw=0 time=5 us) 0 0 0 TABLE ACCESS FULL PLAN_TABLE$ (cr=0 pr=0 pw=0 time=2 us cost=2 size=17 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 157.17 157.17 gc current grant 2-way 6 0.00 0.00 ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 46 0.00 0.00 0 0 0 0 Execute 46 0.00 0.00 0 0 0 0 Fetch 46 0.00 0.00 0 99 0 46 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 138 0.00 0.00 0 99 0 46 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=7 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: 3s1hh8cvfan6w Plan Hash: 2137789089 SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE', :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 12 0.00 0.00 0 0 0 165 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 0 0 165 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 165 165 165 COLLECTION ITERATOR PICKLER FETCH DISPLAY (cr=403 pr=5 pw=0 time=50702 us cost=49 size=16336 card=8168) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 12 0.00 0.00 library cache pin 1 0.00 0.00 SQL*Net message from client 12 0.00 0.00 ******************************************************************************** SQL ID: 1gu8t96d0bdmu Plan Hash: 2035254952 select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols, nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans, t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln, t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1), nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0), nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 31 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 31 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN OUTER (cr=7 pr=0 pw=0 time=252 us cost=4 size=196 card=1) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=5 pr=0 pw=0 time=232 us cost=3 size=157 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=16 us cost=2 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=2 pr=0 pw=0 time=14 us cost=1 size=39 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=0 pw=0 time=6 us cost=1 size=39 card=1) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=0 pw=0 time=6 us cost=0 size=0 card=1)(object id 454) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 2-way 3 0.00 0.00 ******************************************************************************** SQL ID: 32bhha21dkv0v Plan Hash: 3765558045 select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 723 0.00 0.00 0 48 0 713 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 734 0.00 0.00 0 48 0 713 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 3954488388 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 35 0.00 0.00 0 0 0 0 Fetch 70 0.00 0.00 0 175 0 35 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 105 0.00 0.00 0 175 0 35 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 3nkd3g3ju5ph1 Plan Hash: 2853959010 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 15 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 15 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=5 pr=0 pw=0 time=32 us cost=5 size=85 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=4 pr=0 pw=0 time=28 us cost=4 size=0 card=1)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: axmdf8vq7k1rh Plan Hash: 2203911306 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$, flags from seq$ where 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 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SEQ$ (cr=3 pr=0 pw=0 time=322 us cost=2 size=69 card=1) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=7 us cost=1 size=0 card=1)(object id 79) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc cr block 3-way 2 0.00 0.00 ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 2191121161 select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 18 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.00 0 36 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.00 0.00 0 36 0 18 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=0 pw=0 time=4 us cost=1 size=15 card=1) ******************************************************************************** select /*+ opt_param('parallel_execution_enabled', 'false') EXEC_FROM_DBMS_XPLAN */ * from PLAN_TABLE where 1=0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 678 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FILTER (cr=0 pr=0 pw=0 time=1 us) 0 0 0 TABLE ACCESS FULL PLAN_TABLE$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=11081 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 gc current block 2-way 2 0.00 0.00 ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 2570921597 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 48 0.00 0.00 0 80 0 35 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 62 0.00 0.00 0 80 0 35 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: f3g84j69n0tjh Plan Hash: 2335623859 select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc 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 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID NTAB$ (cr=1 pr=0 pw=0 time=8 us cost=2 size=34 card=2) 0 0 0 INDEX RANGE SCAN I_NTAB2 (cr=1 pr=0 pw=0 time=6 us cost=1 size=0 card=2)(object id 90) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: dha5nv6urcumf Plan Hash: 3081038021 select binaryDefVal, lengthb(binaryDefVal) from ecol$ where tabobj# = :1 and colnum = :2 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 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID ECOL$ (cr=3 pr=0 pw=0 time=15 us cost=2 size=119 card=1) 1 1 1 INDEX RANGE SCAN ECOL_IX1 (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 126) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 2542797530 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,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (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.obj# = ist.obj#(+) and i.bo#=:1 order by i.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 2 0.00 0.00 0 9 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 9 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=9 pr=0 pw=0 time=373 us cost=8 size=204 card=1) 1 1 1 HASH JOIN OUTER (cr=9 pr=0 pw=0 time=359 us cost=7 size=204 card=1) 1 1 1 NESTED LOOPS OUTER (cr=6 pr=0 pw=0 time=21 us cost=3 size=161 card=1) 1 1 1 TABLE ACCESS CLUSTER IND$ (cr=5 pr=0 pw=0 time=16 us cost=3 size=109 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=8 us cost=2 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=3 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=3 us cost=0 size=0 card=1)(object id 456) 0 0 0 VIEW (cr=3 pr=0 pw=0 time=214 us cost=4 size=43 card=1) 0 0 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=213 us cost=4 size=17 card=1) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=3 pr=0 pw=0 time=207 us cost=3 size=17 card=1) 0 0 0 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=0 pw=0 time=204 us cost=2 size=0 card=1)(object id 30) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 3-way 1 0.00 0.00 ******************************************************************************** SQL ID: 4m7m0t6fjcs5x Plan Hash: 1935744642 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 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 2 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 2 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE SEQ$ (cr=2 pr=0 pw=0 time=241 us) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=3 us cost=1 size=69 card=1)(object id 79) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 3-way 1 0.00 0.00 ******************************************************************************** SQL ID: 7nuw4xwrnuwxq Plan Hash: 1720483994 select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 48 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 48 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 1224215794 select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3 from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 13 0.00 0.00 0 26 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 0.00 0 26 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: bh7jda5rbamvk Plan Hash: 0 ALTER SESSION SET sql_trace=FALSE 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 mode: ALL_ROWS Parsing user id: 678 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 ID: 9n44pcmzv6bzk Plan Hash: 3937172027 SELECT COUNT(*) FROM DUAL WHERE SYS_CONTEXT('userenv', 'session_user') IN ('APPS','APPLSYS',:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 0 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 0 0 8 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=10 us) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=5 us) 0 0 0 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 22nharvcdzu2p Plan Hash: 498808026 SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 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 0 15 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 15 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FILTER (cr=7 pr=0 pw=0 time=64 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=24 us cost=5 size=70 card=1) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=4 pr=0 pw=0 time=14 us cost=4 size=0 card=1)(object id 42759866) 1 1 1 SORT GROUP BY NOSORT (cr=2 pr=0 pw=0 time=25 us cost=3 size=33 card=1) 1 1 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=21 us) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_TYPES_U1 (cr=2 pr=0 pw=0 time=10 us cost=3 size=33 card=1)(object id 63684402) ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 299250003 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ 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 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=3 pr=0 pw=0 time=164 us cost=5 size=32 card=1) 0 0 0 INDEX RANGE SCAN I_ICOL1 (cr=3 pr=0 pw=0 time=161 us cost=3 size=0 card=1)(object id 42) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 3-way 1 0.00 0.00 ******************************************************************************** SQL ID: f3g84j69n0tjh Plan Hash: 914792125 select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 43 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 43 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 9g485acn2n30m Plan Hash: 2544153582 select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 43 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 43 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 0g9p9jq4j9yn1 Plan Hash: 21361296 SELECT SECURITY_PROFILE_ID FROM PER_SECURITY_PROFILES WHERE REPORTING_ORACLE_USERNAME = USER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 36 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 36 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL PER_SECURITY_PROFILES (cr=18 pr=0 pw=0 time=82 us cost=17 size=110 card=5) ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 3765558045 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, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# 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 37 0.00 0.00 0 5 0 36 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39 0.00 0.00 0 5 0 36 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 36 36 36 SORT ORDER BY (cr=5 pr=0 pw=0 time=47 us cost=4 size=5922 card=94) 36 36 36 TABLE ACCESS CLUSTER COL$ (cr=5 pr=0 pw=0 time=10 us cost=3 size=5922 card=94) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=5 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 0q8w0cndsp865 Plan Hash: 3430698792 SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_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 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=28 us cost=6 size=68 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=13 us cost=2 size=40 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2 (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 63680387) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=13 us cost=4 size=28 card=1) 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=9 us cost=2 size=0 card=1)(object id 63682152) ******************************************************************************** SQL ID: aw7fu9a9bdyus Plan Hash: 1611973141 SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 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 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=10 us cost=1 size=121 card=1) 1 1 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 42786907) ******************************************************************************** SQL ID: 1nrhwbfbmgpmw Plan Hash: 3430698792 SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_PROFILE_OPTION' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_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 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=16 us cost=6 size=68 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=8 us cost=2 size=40 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2 (cr=2 pr=0 pw=0 time=4 us cost=1 size=0 card=1)(object id 63680387) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=3 pr=0 pw=0 time=7 us cost=4 size=28 card=1) 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=6 us cost=2 size=0 card=1)(object id 63682152) ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 1218588913 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname 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 0 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 10 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=5 pr=0 pw=0 time=17 us cost=5 size=40 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=4 pr=0 pw=0 time=12 us cost=4 size=0 card=1)(object id 36) ******************************************************************************** SQL ID: bkaaqaa5aj3gf Plan Hash: 1922647006 SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_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 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=22 us cost=4 size=150 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=3 pr=0 pw=0 time=10 us cost=2 size=15 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)(object id 63679490) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=12 us cost=2 size=135 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=7 us cost=1 size=0 card=1)(object id 63683726) ******************************************************************************** SQL ID: 44b45gyuam27j Plan Hash: 1658105806 select error#,errpos#,flags from sqlerror$ where sqlhash=: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 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL SQLERROR$ (cr=2 pr=0 pw=0 time=27 us cost=2 size=43 card=1) ******************************************************************************** SQL ID: f2tzfzy3qw2bp Plan Hash: 959687402 SELECT DECODE(READ_ONLY_FLAG,'U', 'Y' ,'M', 'Y' ,'K', 'Y' ,'N') SCHEMA_MODE, DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1, 10)) FROM FND_ORACLE_USERID WHERE ORACLE_USERNAME = USER 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 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=1 pr=0 pw=0 time=5 us cost=1 size=8 card=1) 0 0 0 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 42812252) ******************************************************************************** SQL ID: gryz5jc5wzzh4 Plan Hash: 354946051 SELECT LEGISLATION_CODE FROM PER_BUSINESS_GROUPS_PERF WHERE BUSINESS_GROUP_ID = :B1 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 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=6 pr=0 pw=0 time=39 us cost=4 size=52 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=14 us cost=2 size=31 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 42798084) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=24 us cost=2 size=21 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=12 us cost=2 size=21 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=10 us cost=1 size=0 card=1)(object id 42796338) ******************************************************************************** SQL ID: bazquck2vuvm1 Plan Hash: 1353335585 SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_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 0 0 0 0 Fetch 2 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 230 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=2 pr=0 pw=0 time=23 us cost=5 size=10 card=1) 1 1 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=2 pr=0 pw=0 time=12 us cost=4 size=10 card=1) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.85 2.14 0 6 0 0 Execute 6 0.00 0.00 0 7 104 85 Fetch 50358 279.03 1059.39 179103 30146895 0 755329 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 50370 279.88 1061.54 179103 30146908 104 755414 Misses in library cache during parse: 3 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 50363 0.00 0.00 SQL*Net message from client 50362 157.17 227.70 row cache lock 141 0.03 0.67 library cache lock 77 0.01 0.21 library cache pin 75 0.01 0.27 Disk file operations I/O 791 0.00 0.01 gc current block 3-way 835881 0.15 305.35 gc current block 2-way 471360 0.24 144.04 KJC: Wait for msg sends to complete 40 0.00 0.00 gc cr multi block request 8 0.00 0.00 gc current block congested 10014 0.03 4.23 gc cr block 3-way 20215 0.06 4.69 gc current grant busy 20 0.00 0.00 gc cr grant 2-way 165010 0.07 25.13 db file sequential read 179103 0.05 196.31 gc cr grant congested 729 0.19 0.36 gc current block busy 71431 0.05 118.15 gc cr block 2-way 1800 0.01 0.31 latch free 3 0.00 0.00 gc cr block congested 197 0.01 0.06 latch: cache buffers chains 45 0.00 0.00 latch: gc element 15 0.00 0.00 gc cr block busy 15 0.02 0.07 latch: object queue header operation 1 0.00 0.00 KSV master wait 2 0.00 0.00 ASM file metadata operation 1 0.00 0.00 SQL*Net more data to client 1 0.00 0.00 gc current grant 2-way 6 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 298 0.00 0.08 0 0 0 0 Execute 601 0.05 0.12 0 12 150 94 Fetch 2118 0.04 0.17 5 2842 47 1968 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3017 0.10 0.38 5 2854 197 2062 Misses in library cache during parse: 2 Misses in library cache during execute: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ row cache lock 2 0.00 0.00 library cache lock 3 0.00 0.00 library cache pin 3 0.00 0.00 Disk file operations I/O 6 0.00 0.00 gc current block 3-way 54 0.02 0.13 gc current block 2-way 35 0.01 0.07 KJC: Wait for msg sends to complete 3 0.00 0.00 enq: PS - contention 13 0.01 0.02 PX Deq: reap credit 72 0.01 0.01 PX Deq: Join ACK 5 0.01 0.02 PX Deq: Parse Reply 5 0.00 0.01 PX Deq: Execute Reply 5 0.00 0.00 reliable message 10 0.00 0.01 PX Deq: Signal ACK RSG 5 0.00 0.00 PX Deq: Signal ACK EXT 5 0.00 0.00 IPC send completion sync 5 0.00 0.00 PX Deq: Slave Session Stats 5 0.00 0.00 gc cr block 3-way 2 0.00 0.00 gc cr grant 2-way 1 0.00 0.00 db file sequential read 1 0.00 0.00 enq: TO - contention 2 0.00 0.00 enq: TT - contention 1 0.00 0.00 CSS operation: action 2 0.00 0.00 CSS initialization 1 0.00 0.00 CSS operation: query 6 0.00 0.00 direct path write temp 1 0.00 0.00 gc current grant 2-way 1 0.00 0.00 direct path read temp 4 0.00 0.00 24 user SQL statements in session. 49 internal SQL statements in session. 73 SQL statements in session. ********************************************************************************