On 6/16/06, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
See Metalink 1944773 and 264174.999. I suggest you log a TAR.
2006/6/15, Alfonso León <aleon68@xxxxxxxxx>: > Hello Everyone: > > I have a internal query that is executing does anybody has saw it before? > why does it happens? > > > CPU > Elapsd > Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash > Value > --------------- ------------ -------------- ------ -------- --------- > ---------- > 30,654,962 17,075 1,795.3 43.2 177.34 174.77 > 1120568383 > select > parent_owner,parent_name,parent_link_name,parent_type,par > ent_timestamp,property from ora_kglr7_dependencies where owner=: > 1 and name=:2 and type=:3 and obj#=:4 order by order_number > > > TIA > > -- > Alfonso Leon >
-- Best regards, Alex Gorbachev
http://blog.oracloid.com -- //www.freelists.org/webpage/oracle-l
We have this same issue - generally experience with any "cross-plsql-engine" work, (ie, Forms talking the database, Reports talking to the database) although we have not managed to narrow it down much further.
(If memory serves) the view definition consists of three queries - only one is the cause of the high logical IO count - we added a couple of hints to it to reduce (but not eliminate) the problem.
hth
-- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk