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

Thread: Query Time Out

  1. 03-17-2001, 01:53 AM #1
    sai
    sai is offline Junior Member
    Join Date
    Mar 2001
    Posts
    1
    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.)?
    Reply With Quote Reply With Quote
  2. 03-28-2001, 09:53 PM #2
    browned
    browned is offline Junior Member
    Join Date
    Feb 2001
    Posts
    62
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width