On windows, a monitor has to be hooked directly to the console, and you
use 'ORAKILL' SID p.spid where SID is the database system identifier.

-----Original Message-----
From: xian hu
[mailto:oracledba-ezmlmshield-x65615633.[Email address protected]
Sent: Wednesday, May 04, 2005 11:59 AM
To: LazyDBA Discussion
Subject: RE: PL/SQL Hung Program

The process can killed in the server by spid under unix (Linux) servers
and
the locked object (the function in this case) can be freed very soon. To
get
the spid, just query v$session and v$process joined such as,

SELECT a.*, b.*
FROM v$session a, v$process b
WHERE a.paddr = b.addr and a.username is not null
order by b.spid

Hope this helps

Xian

-----Original Message-----
From: kkenny
[mailto:oracledba-ezmlmshield-x76763860.[Email address protected]
Sent: Wednesday, May 04, 2005 9:55 AM
To: LazyDBA Discussion
Subject: PL/SQL Hung Program

Hi,
I have a PL/SQL Program that calls a function that normally runs under
an
hour. It looks to be hung up on the function call est over 50 hrs to
run.
I have gone into OEM and killed it immediate. It marks the session for
killed but it looks like it is continuing along. 2 questions, First is
is
there any way to kill it right away. The table it is writing to can be
recreated so there is no harm there. Also, why would a function not
perform all of a sudden? I just recently reloaded the table that it
calls,
could that be the issue?
Thanks


Kevin J Kenny
Manager of Support Services
Clinical Practice Management Plan
Stony Brook, NY 11790-0988
631-444-0595
Kevin.[Email address protected]

NOTICE: This e-mail and the attachments hereto, if any, may contain
privileged and/or confidential information. It is intended only for use
by the named addressee(s). If you are not the intended recipient of
this
e-mail, you are hereby notified that any dissemination, distribution or
copying of this e-mail and the attachments hereto, if any, is strictly
prohibited. If you have received this transmission in error, please
immediately notify the sender by telephone and permanently delete this
e-mail and the attachments hereto, if any, and destroy any printout
thereof.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page