Re: Timeout any SQL?

kp1wong_at_cs.hku.hk (-=[ CE Raymond ]=-) wrote:

>Hello all!
 

>If I submitted a SQL statement which listed out the join of all tables in
>my view, is it possible to "kill" the query if the Oracle server not
>returned the result in a certain period of time?

Yes.
If u use SQL*Plus, you can normally type Ctrl-C.

or :

u can set the CPU_PER_SESSION limits to al lower number. Received on Wed Nov 06 1996 - 00:00:00 CST