Fetch in tkprof

Posted by satish on Apr 20, 2022; 3:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Fetch-in-tkprof-tp10851.html

Dear erman,

In below tkprof figures,it is the sql that took highest elapsed time. The execution time is less but looks fetch takes more time. From your experince,please let us know the reasons how can we avoid this.
SQL ID: 9w44sa4ant350 Plan Hash: 2559300826
 
SELECT CHT.CHALLAN_ID, CHT.CHALLAN_AMOUNT, CHT.PROPERTY_ID, CHT.PARTY_ID
FROM
 XXTTD.XXTTD_AR_DCB_CHALLANS_HDR_TBL CHT, XXTTD.XXTTD_AR_DCB_PROP_V DPV,
 XXTTD.XXTTD_AR_DCB_PROPS_HDR_TBL PHT WHERE DPV.LOCATION_ID =
 PHT.LOCATION_ID AND PHT.PROPERTY_ID = CHT.PROPERTY_ID AND CHT.ATTRIBUTE2 =
 'A' AND CHT.ATTRIBUTE5 = 'A' AND CHT.CHALLAN_DATE BETWEEN :B5 AND :B4 AND
 CHT.PROPERTY_ID = :B3 AND CHT.PARTY_ID = :B2 AND DPV.PROPERTY_REGION = NVL
 (:B1 , DPV.PROPERTY_REGION) GROUP BY CHT.CHALLAN_ID, CHT.CHALLAN_AMOUNT,
 CHT.PROPERTY_ID, CHT.PARTY_ID
 
call   count    cpu  elapsed    disk   query  current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse    1   0.00    0.00     0     0     0      0
Execute 60971   3.44    3.42     0     0     0      0
Fetch  60971  5923.01  5937.42     0 1322057231     0    1664
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total  121943  5926.46  5940.85     0 1322057231     0    1664
 
Thank you