Re: Is there a way to initiate a timeout on long running queries ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Aug 2003 22:48:01 +0200
Message-ID: <vkni8mk4qr867c@corp.supernews.com>

"Iyman Zakhary" <izakhary_at_vibrant-1.com> wrote in message news:b01cd916.0308261225.e220c63_at_posting.google.com...
> I have a query that could take upto 15 minutes based on used parameters.
> Is there a way to timeout after 5 minutes ?

Look into setting up a profile and or setting up resource limits.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Aug 26 2003 - 15:48:01 CDT

This message: [ Message body ]
Next message: Joel Garry: "Re: Avoiding any locks in SQL Servers - read and understand....itsmagic."
Previous message: Iyman Zakhary: "Is there a way to initiate a timeout on long running queries ?"
In reply to: Iyman Zakhary: "Is there a way to initiate a timeout on long running queries ?"
Next in thread: Edgar Chupit: "Re: Is there a way to initiate a timeout on long running queries ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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