If you're using the stand alone version of OEM you can just look for blocking locks and kill them.
________________________________________
From: Ramesh [oracledba-ezmlmshield-x52049330.[Email address protected]
Sent: Monday, February 11, 2008 12:22 PM
To: LazyDBA Discussion
Subject: RE: Locking Problem
You should be able to see from v$locked_object, which are locked. But
you have views which show, what is that session waiting for.
I usually use toad, it is pretty easy to identify from that.
Thanks and Regards,
Ramesh.
-----Original Message-----
From: Victor Marquez
[mailto:oracledba-ezmlmshield-x73647180.[Email address protected]
Sent: Monday, February 11, 2008 9:52 AM
To: LazyDBA Discussion
Subject: Locking Problem
Hello you all;
I do have a situation that I need help with. It is an application that
is locking and stop the rest of users to continue working. How can I do
to identify what part of Oracle is locking at the Database level and
what is locking.?????
Help.!!!
Victor Marquez
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Email Firewall made the following annotations
------------------------------------------------------------------------ NOTICE ---
This message is for the designated recipient only and may contain confidential, privileged or proprietary information. If you have received it in error, please notify the sender immediately and delete the original and any copy or printout. Unintended recipients are prohibited from making any other use of this e-mail. Although we have taken reasonable precautions to ensure no viruses are present in this e-mail, we accept no liability for any loss or damage arising from the use of this e-mail or attachments, or for any delay or errors or omissions in the contents which result from e-mail transmission.
---------------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page