Re: Identify source of a query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 2 Dec 2003 21:45:01 -0000
Message-ID: <bqj156$e08$1$8300dec7@news.demon.co.uk>

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" <n_nhuha_at_hotmail.com> wrote in message
news:541d6c7a.0312021219.24605d92_at_posting.google.com...


> 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

Received on Tue Dec 02 2003 - 15:45:01 CST