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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.