Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Explain Plan Hangs. DBA on 3 week holiday, and his name is Mu

RE: Explain Plan Hangs. DBA on 3 week holiday, and his name is Mu

From: <LBhat_at_LEVI.com>
Date: Mon, 24 Jul 2000 19:43:30 -0700
Message-Id: <10568.112824@fatcity.com>


May be that region is united with the UN properly!!!

Bhat

-----Original Message-----
From: Patrick Mullen [mailto:Patrick.Mullen_at_wfp.org] Sent: Monday, July 24, 2000 8:45 PM
To: Multiple recipients of list ORACLE-L Subject: Explain Plan Hangs. DBA on 3 week holiday, and his name is Murphy!

I have a query which did nothing over the entire weekend. When I try to see what it is doing the explain plan hangs. So now I understand (I think) why the query does nothing - oracle doesn't even manage to get past the query optimizer or whatever it is that does the query plans.

No errors or anything, it just sits there for days...

Oracle 8.0.5.0.0 running on NT4 sp3.

Removing a single column from the results set changes everything. Though this column is in a table from which other columns are already returned, so it is difficult to understand why it should change the explain plan!!! For example (this is an example the full sql is a bit bigger):

select sum(trans_amt),account_code,rcpt.short_dsc,rcpt.region from glm ,rcpt
where glm.rcpt_code = rcpt.rcpt_code
group by
account_code,rcpt.short_dsc,rcpt.region

wont work, but if I remove rcpt.region from the sql it works fine.

What's the deal here then?.

Thanks

PAtrick Mullen

Data Warehouse Officer
United Nations World Food Programme

-- 
Author: Patrick Mullen
  INET: Patrick.Mullen_at_wfp.org

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).
Received on Mon Jul 24 2000 - 21:43:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US