Sample TKPROF Out from a sample trace file. 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 1.20 1.21 0 86091 4 15 ------- ----- ------ ------- --- -------- --------- - — — — — total 4 1.20 1.21 0 86091 4 15 1. A high (near 100%) parse count to execute count ratio when the execute count is greater 1 – if ratio is 1, then the query is parsed each and every time its execute and that needs to be corrected. The ratio should approach zero. The ideal is parse count should be 1 and execute count would be higer.