Database Tuning (MOSC)

MOSC Banner

Tkprof - Elapsed

Dear Experts,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center