Re: Long Sessions

On Sun, 19 Aug 2007 02:54:27 -0700, pcarr01 <paddy.carroll_at_gmail.com> wrote:

>Appreciate the comments on performance but this isnt an oracle issue
>its a network issue that affects oracle.
>I was working on a problem that was exposed because Oracle 8 had known
>issues with bitmapped indexes and that was what ruined the
>performance, we were running queries and doing updates in a diagnostic
>and recovery context that were not returning within an acceptable
>timescale & if some network device had detected no activity then ..
>bang .. query lost. There is no way I could have done this without
>some sort of client session on the target platform be it ssh, plus80
>or whatever.

Ever heard of stored procedures? From your description you are misusing the network for something which *ought* to be serverside. The firewall is not the problem. Your code is.

-- 
Sybrand Bakker
Senior Oracle DBA