Path: news.f.de.plusline.net!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!newsfeed.kamp.net!newsfeed.kamp.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!k21g2000cwa.googlegroups.com!not-for-mail
From: calberto2312@gmail.com
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: Uknown query
Date: 1 Jan 2007 11:16:00 -0800
Organization: http://groups.google.com
Lines: 48
Message-ID: <1167678960.402609.23100@k21g2000cwa.googlegroups.com>
References: <1167487185.429637.172200@h40g2000cwb.googlegroups.com>
   <9rmdnTrPO-EaDwvYnZ2dnUVZ8qaqnZ2d@bt.com>
NNTP-Posting-Host: 201.19.65.123
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1167678965 4816 127.0.0.1 (1 Jan 2007 19:16:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 1 Jan 2007 19:16:05 +0000 (UTC)
In-Reply-To: <9rmdnTrPO-EaDwvYnZ2dnUVZ8qaqnZ2d@bt.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: k21g2000cwa.googlegroups.com; posting-host=201.19.65.123;
   posting-account=wmF9Lw0AAADLHANbpDEgBJ1SrIA4p0jL
Xref: news.f.de.plusline.net comp.databases.oracle.server:191536 comp.databases.oracle.misc:77232


Jonathan Lewis escreveu:

> <calberto2312@gmail.com> wrote in message
> news:1167487185.429637.172200@h40g2000cwb.googlegroups.com...
> Hi all,
>
>   In my statspack reports, I=B4ve 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=B4s one of the queries :
>
> select a.default_cpu_cost, a.default_io_cost
> from association$ a
> where a.obj# =3D :1
>   and a.property =3D :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=B4ve noticed that just after an instance startup it run....

Regards
Carlos