RE: killing oracle processes

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <mschmitt@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 17 Aug 2009 13:38:40 -0400

    I'm going to assume that your atleast on Oracle 9i.  If so have you
tried enabling resource limits in their profiles?  I normally create a
developer profile that kills a statement after 30 minutes of CPU time.
It always seems to work.

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Schmitt
Sent: Monday, August 17, 2009 11:34 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: killing oracle processes


Hi All,


I had a quick question that I was hoping the list could help me out
with.  We have a group of developers who are requesting the ability to
kill their own processes in the database (PRD/DEV/TST).  For example, if
a poorly written report gets kicked off, one of their jobs chooses a
poor execution plan, or an OWB process gets left out there.  The only
reason they can really offer is that they do not have to wait for the
DBA team to respond.  I am trying to think of technical reasons why this
would not work.


I can write a script to limit the process to be killed to their stuff,
but something about this still makes me feel uneasy.  Is there anything
that I should worry about?  


Any thoughts?        



Other related posts: