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.)?
Printable View
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.)?
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.