Tuning queires
Hi All,
I need to tune some insert,update and select statements. I see that their parse calls is almost equal to the execution times.
and cursor_sharing is 'exact' now.
I tried using sql_tuning and explain plan but I didn't get any recommendations. Please suggest me how to to tune these statements.
1) update LASTDISPATCHEDMESSAGE set VERSION_NUM=:1, LASTPROCESSEDTIMESTAMP=:2 where LASTDISPATCHEDMESSAGEID=:3 and VERSION_NUM=:4; ( have index on VERSION_NUM)
2) insert into DEVICETRAVELLOCATION (ADDR1, ADDR2, CITY, COUNTY, STATE, POSTALCD, COUNTRY, CROSSSTREET, STATEPROVCD, ROADTYPECD, TOLLROADFLAG, SPEEDLIMITMILESPH, DEVICETRAVELSTATUSHISTORYID) values (:1, :2, , :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); ( have index)
Give me some suggesstions, or guidelines how to tune these sql.
I need to tune some insert,update and select statements. I see that their parse calls is almost equal to the execution times.
and cursor_sharing is 'exact' now.
I tried using sql_tuning and explain plan but I didn't get any recommendations. Please suggest me how to to tune these statements.
1) update LASTDISPATCHEDMESSAGE set VERSION_NUM=:1, LASTPROCESSEDTIMESTAMP=:2 where LASTDISPATCHEDMESSAGEID=:3 and VERSION_NUM=:4; ( have index on VERSION_NUM)
2) insert into DEVICETRAVELLOCATION (ADDR1, ADDR2, CITY, COUNTY, STATE, POSTALCD, COUNTRY, CROSSSTREET, STATEPROVCD, ROADTYPECD, TOLLROADFLAG, SPEEDLIMITMILESPH, DEVICETRAVELSTATUSHISTORYID) values (:1, :2, , :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); ( have index)
Give me some suggesstions, or guidelines how to tune these sql.
0