Re: Identify source of a query

A little more of the query would have been
helpful, as I think we would have seen some
very boring column aliases as well as a CASE
statement, and possible a SAMPLE clause.

It looks like the start of a query run by run-time
dynamic sampling - during which dynamic sampling
is switched off, bind variable substitution is blocked,
and column_monitoring is disabled.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Lily" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi All,
>
> I have trouble identifying the source of this query:
>
> =====================
> SELECT /*+cursor_sharing_exact dynamic_sampling(0) no_monitoring*/
> COUNT(*).......
> .
> .
> .
> from tablename
> ====================
>
> Please help, any help is greatly appreciated,
>
> Thanks,
>
> Lily