Re: extend the timeout for the SQLPLUS

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Sat, 27 Feb 2010 16:54:37 -0800 (PST)
Message-ID: <7a2036ad-20d3-4849-a1c4-ab3ce828031d_at_u9g2000yqb.googlegroups.com>

On Feb 27, 4:09 pm, happy <ehabaziz2..._at_gmail.com> wrote:
> How can I extend the timeout for the SQLPLUS sql commands entry ?

happy, by default SQLPlus itself does not have a timeout. If your sessions are being timed out then there are several ways it can be done. mgogala identified database user profiles as one method. The Oracle database resouce manager can also be used to time out sessions and kill queries that exceed resource limits.

Many DBA set up dead/idle connection detection scripts that identify and kill sessions that have not done any work in X time.

Also many Firewalls will close connections throught he firewall that have not been active for X time.

If mgogala's solution does not appear to fit whatever unposted actual message you are getting then maybe one of these other items fit.

HTH -- Mark D Powell -- Received on Sat Feb 27 2010 - 18:54:37 CST