Re: ora_kglr7_dependencies

On 6/16/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> See Metalink 1944773 and 264174.999. I suggest you log a TAR.
>
> 2006/6/15, Alfonso León <aleon68_at_gmail.com>:
> > 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
> --
> http://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_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l