If your Oracle DBA has a resource profile set for your web server user,
you can set parameter IDLE_TIME.
How to create a profile --
http://www.adp-gmbh.ch/ora/sql/create_profile.html
-Original Message-
From: Kevin Bass [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 21, 2004 4:53 AM
To
[EMAIL PROTECTED],
[EMAIL PROTECTED], (bcc: Dan Horne/IT/AKLWHG/WHNZ)
Subject:Re: Killing a Process
On Nov 22, 2004, at 5:30 AM, Bob Showalter wrote:
> Kevin Bass wrote:
>> I have a slight problem that I am attemping to solve. I am using
>> CGI/Perl (DBD Oracle) on Li
On Nov 22, 2004, at 5:30 AM, Bob Showalter wrote:
Kevin Bass wrote:
I have a slight problem that I am attemping to solve. I am using
CGI/Perl (DBD Oracle) on Linux AS 2.1 to access to the database. When
users encounter problems on the web, they cancel (or press stop) in
their browsers. This will st
On Nov 22, 2004, at 5:30 AM, Bob Showalter wrote:
Kevin Bass wrote:
I have a slight problem that I am attemping to solve. I am using
CGI/Perl (DBD Oracle) on Linux AS 2.1 to access to the database. When
users encounter problems on the web, they cancel (or press stop) in
their browsers. This will st
Kevin Bass wrote:
> I have a slight problem that I am attemping to solve. I am using
> CGI/Perl (DBD Oracle) on Linux AS 2.1 to access to the database. When
> users encounter problems on the web, they cancel (or press stop) in
> their browsers. This will stop there browser interaction and also
> ca
There ought to be a better way. I'm not very familar with web issues
but for plain CGI I'd have expected a SIGHUP and/or SIGPIPE to be
delivered to the process. Those could be caught and trigger cleanup.
Tim.
On Sun, Nov 21, 2004 at 09:12:30AM -0700, Reidy, Ron wrote:
> Look at setting the sqlnet
Look at setting the sqlnet.expire_time parameter in your server's
$ORACLE_HOME/network/admin/sqlnet.ora file.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Kevin Bass [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 21, 2004 5:53 AM
To: [EMAIL PROTE
