Re: Long Sessions

On Fri, 17 Aug 2007 22:38:54 -0700, pcarr01 <paddy.carroll_at_gmail.com> wrote:

>Hi,
>We have an issue with the amount of time that a firewall will hold a
>session open.
>Currently we have 72 hours, this drives the security and network
>people crazy but we have a requirement for stuff like very long
>database queries, launch an ssh or sqlplus session onto an oracle box
>and the session expires before the query finishes and we lose the
>result, very bad when you are working on a problem at 3 in the
>morning
>and the Damages for not getting the database back up by 5 are in 6
>figures.
>How does the industry in general deal with this sort of issue?

I have two remarks
a) is the query properly tuned? A query of 72 hours is cleary fully outrageous and at least I have near seen it, and I have in quite a bit of messes.
b) It looks it wasn't a very wise decision to run this query in a client/server configuration, and it would probably take much less time if one runs the query on the server, dump the results to a file and transport the file only.

But then of course you provide way too little background so this are just my
2 eurocents.

-- 

Sybrand Bakker
Senior Oracle DBA