Query Time Out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Query Time Out

  1. #1
    Join Date
    Mar 2001
    Is there a way to set a query timeout in oracle?

    Is there a way to cancel running query if it exceeds more than centain time limit (say 2mins.)?

  2. #2
    Join Date
    Feb 2001
    no. You can only use CONTROL-C as far as I know.

    There may be a parameter in the sqlnet.ora that can be set for expire time, but I think this is only for lack of i/o, which would not be the case in your case.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width