| High parse count over db_link from 9i to 9i? [message #185028] |
Sun, 30 July 2006 05:04  |
kareem2020
Messages: 4
Registered: July 2006
|
Junior Member |
|
|
i traced a dblink sesssion at remote end,From tkprof i found the connection from 9i to 9i over db link, there is high in parse count... when i run same query from 8i to 8i over db link, parse count is 1... but 9i to 9i over db link is parse count is high..Both end cursor_sharing set to exact... any comments. how to fix it..
the query has where join condition from local db column to remote db column.. Normally how we do control high soft parse count with in db?
9i to 9i
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 16306 0.87 0.81 0 0 0 0
Execute 16306 1.52 1.36 0 0 0 0
Fetch 32612 1.34 1.19 61 32612 0 16306
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 65224 3.73 3.38 61 32612 0 16306
same query result in 8i to 8i
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 16306 2.30 2.06 0 0 0 0
Fetch 16306 1.08 1.09 61 32612 0 16306
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 32613 3.38 3.15 61 32612 0 16306
ELASPED : 00:01:47.67
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
