Re: Identify source of a query

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 02 Dec 2003 14:19:39 -0800
Message-ID: <1070403610.112516@yasure>

Lily wrote:

> 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

And you aren't going to tell us what Oracle version or edition.
And you aren't going to tell us what front-end tools are installed.
And you aren't going to tell us what middle-tier may be involved.
And you aren't going to tell us what applications are being run.
And you aren't going to give us patch levels.

Heck you aren't even going to give us the SQL statement you used to create this pseudo-query.

I guess it is coming from magenta. To be more specific a very deep magenta with a sort of mesh pattern with silver bells on it. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Dec 02 2003 - 16:19:39 CST