Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Long Sessions

Re: Long Sessions

From: <sybrandb_at_hccnet.nl>
Date: Sun, 19 Aug 2007 13:42:13 +0200
Message-ID: <q1bgc39ftg1iqo283mpgqb4ooru118luhv@4ax.com>


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
Received on Sun Aug 19 2007 - 06:42:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US