Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

ora_kglr7_dependencies

Alfonso León

2006-06-15

Replies:

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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.