Home » SQL & PL/SQL » SQL & PL/SQL » SQL Time-out
SQL Time-out [message #192177] Mon, 11 September 2006 06:29 Go to next message
rusty_ryan
Messages: 11
Registered: August 2006
Junior Member
Hi all,

I have a SQL query that is causes difficulites for one of our clients and I need to give some indications to developers on what might be worth looking again. The query runs fine once and times out when run again on one of clients server(running Linux). However, the same query works absolutely fine when I run it on my test machine no matter how many times.

Can any one please give me hints on from where should I start investigating?
Re: SQL Time-out [message #192190 is a reply to message #192177] Mon, 11 September 2006 07:16 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Two words: sql trace.
Previous Topic: SQL Query
Next Topic: Sql Insert with PK and Fk
Goto Forum:
  


Current Time: Fri Dec 09 17:14:36 CST 2016

Total time taken to generate the page: 0.12056 seconds