Re: DBMS_XPLAN

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 11 Nov 2003 20:50:28 -0000
Message-ID: <boria9$eqc$1$8302bc10@news.demon.co.uk>

The column name in the plan_table is NODE. This is the table queue for parallel queries, but the database link name for lines that identify the REMOTE portion of a distributed query.

I'd guess that the WO LD bits could be a badly formatted chunk of a bit of your
domain name like "WORLD".

--
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
____Belgium__November (EOUG event - "Troubleshooting")
____UK_______December (UKOUG conference - "CBO")


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


"Rob Cowell" <rjc4687_at_hotmail.com> wrote in message
news:3FB0C92D.1947751C_at_hotmail.com...


> Can anyone point me at some documentation that might explain the

> contents of the TQ column?

>

> The Oracle Docs just say it's the table queue number for parallel

query,


> but I'm seeing values of WO and LD in there for remote access.

>

> Thanks

Received on Tue Nov 11 2003 - 14:50:28 CST