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: max execution time for sql-statement

Re: max execution time for sql-statement

From: Matthias Gresz <nospam_at_newsranger.com>
Date: Fri, 07 Sep 2001 08:21:52 GMT
Message-ID: <As%l7.7663$4z.32628@www.newsranger.com>


In article <9n9u64$6et93$1_at_ID-5007.news.dfncis.de>, Tino Korth says...
>
>hello *,
>
>is there a possibility to set an maximum execution time for a sql-statement?
>
>example.
>the following sql-statement should have a max execution time of 60 seconds.
>something like "select * from tblXYZ, MAXEXEC 60"?
>
>bye
>
>tino
>
>

Hi Tino,

use profiles.

Matthias Received on Fri Sep 07 2001 - 03:21:52 CDT

Original text of this message

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