RE: Is there a way/hack to allow the query only to run for specified duration in Oracle and kill it.
Date: Wed, 1 May 2019 08:52:37 -0700 (PDT)
Message-ID: <c545184f-4f52-4f15-ade5-a9a7ef4592cb_at_default>
Sounds like you want a Resource Manager plan with a directive around Execution Time Limit…then make sure your script goes through with users attached to that resource plan
From: kunwar singh <krishsingh.111_at_gmail.com>
Sent: Wednesday, May 1, 2019 11:46 AM
Hi Listers,
Small question.
I currently working on a remote database in which i can only pass a query through a tool and i want to kill it after letting it run only for 1 minute
The reason for this is i have to try different underscore parameters at session to check if the issue is fixed or not.
I am looking for any solution which is completely in a single sql . What i pass to the tool is a .sql file , thats all.
If you have a simple solution in shell then i will try that one as well. Meaning i can run a shell command like this:
!hostname
The query that i want to run is a big select sql , which unfortunately i cannot paste here.
To: ORACLE-L <oracle-l_at_freelists.org>
Subject: Is there a way/hack to allow the query only to run for specified duration in Oracle and kill it.
--
Cheers,
Kunwar
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 01 2019 - 17:52:37 CEST