RE: Is there a way/hack to allow the query only to run for specified duration in Oracle and kill it.

From: Jeff Smith <jeff.d.smith_at_oracle.com>
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
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.

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:

The query that i want to run is a big select sql , which unfortunately i cannot paste here.

-- 

Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 01 2019 - 17:52:37 CEST

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

Original text of this message