(no subject)

It looks like you have a partitioned table with a parallel or parallel index definition.

The :Qxxxxyyy are the 'table queues' used by parallel query slaves to pass messages between the layers of slaves operating the query.

The SQL with the hints in it is the SQL
generated by the query co-ordinator as
it breaks down your original query for
parallel execution.

I don't think that tkprof makes a very neat (or complete) job of presenting such query plans, but it is quite hard to do anything good when they get complex. I tend to run my own 'explain plan' script (see the website noted below) to split the parallel query SQL from the rest of the plan as this tends to make things a little cleaner.

Jonathan Lewis

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

Author of:
Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research.

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 27 August 2001 19:22

|I am running tkprof and explain plan on the following SQL statement:
|
|SELECT DISTINCT CNFR_NO,
|SPLT_PAY_TYPE, ACH_AMT
|FROM whse_dbo.ACH_TRAN
|WHERE ACCT_NO = '46807' AND
| TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
| STATUS = '2' AND
| CNFR_NO >0 AND
| (SPLT_PAY_TYPE = '810' OR
| SPLT_PAY_TYPE = '820' );
|
|I'm not really looking for advice on tuning this query but rather
just
|wanted to have some general questions answered regarding the
|results i got using tkprof.
|
|This is the first time I've ever run tkprof on a statement and gotten
|an explain plan with :Q in it (followed by numbers). What does the
|:Q mean?
|
|Also, there is not hint embedded in the select statement I ran but
|the explain plan output shows hints in the explain plan. Or at least
|the explain plan list the output in hint format. Why is it doing
that,
|when there were no hints in the original source?
|
|Thanks in advance,
|
|Cherie Machler
|Oracle DBA
|Gelco Information Network

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).