Query Time Out

[sai]

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

[browned]

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.