Re: ora_kglr7_dependencies

On 6/16/06, Alex Gorbachev <gorbyx@gmail.com> wrote:

See Metalink 1944773 and 264174.999. I suggest you log a TAR.

2006/6/15, Alfonso León <aleon68@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@yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

Re: ora_kglr7_dependencies

Connor McDonald

2006-06-16