Can you define "time out" and "crash"? Oracle won't time out a query
unless your DBA has configured a profile that limits how long a
statement runs. I've never seen a query crash-- is it doing something
like running out of temporary space?

What is the clause the forces the full table scan? Is it possible to
create an index that would eliminate the full table scan?

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x12930645.[Email address protected]
Sent: Wednesday, September 28, 2005 2:12 PM
To: LazyDBA Discussion
Subject: Full Table Scan - Query Times Out

Hi Gurus

If a full table scan causes a query to time out or crash what can I do
to investigate and resolve. Note: the query runs fine if the where
clause causing the full table scan is commented out.

Ideas greatly appreciated.

Cheers
David

------------------------------
Combined Services SFL
Thus Plc Demon.net
i : 740 4153
e : 0141 273 4153
m : 07801 452918



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page