Overquoted before. What I said was: First: =20 OS? OS version? Database version? Always, always, always! ;-) Second: Define "fail", as used below. =20 Does it crash? If so, with what error? Does it hang? If so, what's V$SESSION_WAIT have to say about the session trying to do the explain plan? Hope that helps, -Mark > > I have two tables with basic views on top of them. And I=20 > > need to run some > > basic > > sql against the database. The stuff you see in the body of=20 > > the explain plan. > > Neither table is that big. About 2000 records in each of=20 > > them. The weird > > part > > is that even trying to run an explain plan locks up whatever=20 > > I'm running it > > from. =20 > > =20 > > Does anybody have any idea what would make an explain plan=20 > > request fail and > > what to do about it? =20 > > =20 > > Thanks, Ben > > =20 > > This is what crashes. (With or without the first line) =20 > > [SMSYSPLAN is my > > plan_table] > > =20 > > explain plan set statement_id =3D 'cr_weird' into SMSYSPLAN for > > SELECT > > Clients."Title", Clients."InActive:", Clients."Client=20 > Full Name", > > Clients."Classification", Clients."Home Country Name", > > Incident."InActive:", Incident."Visit Date", Incident."GA=20 > > Host Text" > > FROM > > "_SMDBA_"."Clients" Clients, > > "_SMDBA_"."Incident" Incident > > WHERE > > Clients."Sequence" =3D Incident."Seq.Client" (+) > > AND > > Incident."Visit Date" >=3D TO_DATE('2004-12-01 00:00:00',=20 > > 'YYYY-MM-DD > > HH:MI:SS') AND > > Incident."Visit Date" < TO_DATE('2004-12-10 00:00:00',=20 > 'YYYY-MM-DD > > HH:MI:SS') AND > > Clients."InActive:" =3D 0=20 > > AND > > Incident."InActive:" =3D 0 > > ORDER BY > > Clients."Classification" ASC -- //www.freelists.org/webpage/oracle-l