Yes, I really am stuck with nowhere to write. The ipsec people have pretty much every file on the machine ( E10000 ) accounted for...
Adam ----- Original Message ----- From: "Bill Moseley" <[EMAIL PROTECTED]> To: "Adam Kennedy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:01 AM Subject: Re: Open cursors after disconnection > At 09:23 PM 12/6/2001 +1100, Adam Kennedy wrote: > >The Situation > > >Oracle seems to have this lovely property where if you don't explicitly > close a statement, the cursor hangs around forever... overflowing the open > cursor and process limits... > > Hopefully, someone will answer with a DBI solution. > > So, you need to send a huge file to a client, but if the client aborts the > database is left in an unstable state, not freeing resources. > > Are you really stuck with no place to cache the output? Is there another > machine on the LAN where you could redirect the request, which would then > grab the data (LWP or proxy), cache it and deliver or make available? > Seems like you don't want to use Oracle to waste time writing to a client. > > If you are running mod_perl, you can watch the connection and deal with it > when it's aborted, but sending huge files to slow clients is not a good use > of heavy mod_perl processes. > > > > > Bill Moseley > mailto:[EMAIL PROTECTED] >
