Re: extend the timeout for the SQLPLUS
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 27 Feb 2010 23:27:44 +0000 (UTC)
Message-ID: <hmc9pg$92q$1_at_solani.org>
On Sat, 27 Feb 2010 13:09:16 -0800, happy wrote:
Date: Sat, 27 Feb 2010 23:27:44 +0000 (UTC)
Message-ID: <hmc9pg$92q$1_at_solani.org>
On Sat, 27 Feb 2010 13:09:16 -0800, happy wrote:
> How can I extend the timeout for the SQLPLUS sql commands entry ?
You can create profile with the limit on CONNECT_TIME, something like this
SQL> create profile myprof limit connect_time 30;
Profile created.
Elapsed: 00:00:00.38
SQL>
That will drop the connection after 30 minutes, along with any query that
might be executing at that time. You can also limit CPU_PER_CALL which is
not the exact time limit but will usually kill all the queries that take
longer than 5*CPU limit. It does take a little experimenting, though.
-- http://mgogala.freehostia.comReceived on Sat Feb 27 2010 - 17:27:44 CST