Re: Uknown query

Jonathan Lewis escreveu:

> <calberto2312_at_gmail.com> wrote in message
> news:1167487185.429637.172200_at_h40g2000cwb.googlegroups.com...
> Hi all,
>
> In my statspack reports, I´ve been seeing some similar queries that
> are unknown for me. They are being executed hundreds of times, but I
> want to find out who is running them. Here´s one of the queries :
>
> select a.default_cpu_cost, a.default_io_cost
> from association$ a
> where a.obj# = :1
> and a.property = :2
>
> Can you help me?
>
> Thanks in advanced,
> Carlos
>
>
>
> I think this is one of the recursive queries that runs
> when you optimise a query that uses domain indexes.
> Its purpose is to check if you have associated cost
> figures to the operator that invokes the domain index.
>
> --
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Hi Jonathan,

  I use Oracle Text. Could be possible that these queries are related to it? I´ve noticed that just after an instance startup it run....

Regards
Carlos Received on Mon Jan 01 2007 - 13:16:00 CST