Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Uknown query

Re: Uknown query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 30 Dec 2006 16:25:35 -0000
Message-ID: <9rmdnTrPO-EaDwvYnZ2dnUVZ8qaqnZ2d@bt.com>

<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
Received on Sat Dec 30 2006 - 10:25:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US