Weird Behavior

From: Ben Sauer <SauerBL_at_ldschurch.org>
Date: Thu, 09 Dec 2004 14:50:21 -0700
Message-ID: <s1b86643.029@inet-wh1.gmhwh.org>

I have two tables with basic views on top of them. And I need to run some basic
sql against the database. The stuff you see in the body of the explain plan. Neither table is that big. About 2000 records in each of them. The weird part
is that even trying to run an explain plan locks up whatever I'm running it from.

Does anybody have any idea what would make an explain plan request fail and what to do about it?

Thanks, Ben

This is what crashes. (With or without the first line) [SMSYSPLAN is my plan_table]

explain plan set statement_id = 'cr_weird' into SMSYSPLAN for SELECT
Clients."Title", Clients."InActive:", Clients."Client Full Name", Clients."Classification", Clients."Home Country Name",

    Incident."InActive:", Incident."Visit Date", Incident."GA Host Text" FROM
"_SMDBA_"."Clients" Clients,
"_SMDBA_"."Incident" Incident

WHERE
    Clients."Sequence" = Incident."Seq.Client" (+) AND
    Incident."Visit Date" >= TO_DATE('2004-12-01 00:00:00', 'YYYY-MM-DD HH:MI:SS') AND
    Incident."Visit Date" < TO_DATE('2004-12-10 00:00:00', 'YYYY-MM-DD HH:MI:SS') AND
    Clients."InActive:" = 0
AND
    Incident."InActive:" = 0
ORDER BY
    Clients."Classification" ASC

But this works fine

SELECT
    Clients."Title", Clients."InActive:", Clients."Client Full Name", Clients."Classification", Clients."Home Country Name", Incident."InActive:", Incident."Visit Date", Incident."GA Host Text" FROM
"_SMDBA_"."Clients" Clients,
"_SMDBA_"."Incident" Incident

WHERE
    Clients."Sequence" = Incident."Seq.Client" (+) AND
    Clients."InActive:" = 0
ORDER BY
    Clients."Classification" ASC

This message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 09 2004 - 15:51:02 CST