Home » RDBMS Server » Performance Tuning » High parse count over db_link from 9i to 9i?
High parse count over db_link from 9i to 9i? [message #185028] Sun, 30 July 2006 05:04 Go to next message
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

Re: High parse count over db_link from 9i to 9i? [message #185106 is a reply to message #185028] Mon, 31 July 2006 01:00 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Strange. I would recommend you log a SR (TAR) with Oracle support. Please keep us posted.
Re: High parse count over db_link from 9i to 9i? [message #185126 is a reply to message #185106] Mon, 31 July 2006 01:59 Go to previous messageGo to next message
kareem2020
Messages: 4
Registered: July 2006
Junior Member
Normally how to control if there is high soft parse count in standalone db...
Re: High parse count over db_link from 9i to 9i? [message #185814 is a reply to message #185028] Thu, 03 August 2006 13:34 Go to previous message
srinivas4u2
Messages: 66
Registered: June 2005
Member
You need to correct the code to reduce the soft parse.
Previous Topic: Problem with output file using TKPROF - Oracle 9i Release 2
Next Topic: how to reduce using virtual memeory
Goto Forum:
  


Current Time: Sun Dec 04 21:04:48 CST 2016

Total time taken to generate the page: 0.26935 seconds