How Detecting DeadLocked Processes?

Login or Register to Ask a Question and Join Our Community

How Detecting DeadLocked Processes?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How Detecting DeadLocked Processes?

07-11-2006

Registered User

8, 0

Join Date: Jul 2006

Last Activity: 16 June 2008, 2:22 AM EDT

Posts: 8

Thanks Given: 0

Thanked 0 Times in 0 Posts

How Detecting DeadLocked Processes?

Hi,
First let me inform you about the environment:

We have four servers (sun machines), connected via WAN to centralized Oracle Database Server.

Each sun server has a lot of users,

The Problem is
I don't a Unix Monitor tool to tell me which Process is deadlocked to kill.
all we can do is to wait the user complain about unexpected long runtime, then we begin to ask the programmers about this long time and do some queries to be sure that is a Deadlocked Process to Kill.

Is there any Unix Tool to inform me about Deadlocked Process?

Thanks for your Help

so_friendly

View Public Profile for so_friendly

Find all posts by so_friendly

07-11-2006

Registered User

11,728, 1,345

Join Date: Feb 2004

Last Activity: 8 May 2020, 9:07 AM EDT

Location: NM

Posts: 11,728

Thanks Given: 903

Thanked 1,345 Times in 1,201 Posts

This sounds more like a programming/DBA problem - assuming that the problem is an Oracle deadlock, ie. two processes are using something like:

Code:

LOCK TABLE IN ROW EXCLUSIVE MODE

on the same resource.

Someone in your shop has to have a subscription to Oracle's metalink - assuming you have a valid Oracle license. There are tons of articles and sql snippets to help you out on that site.

jim mcnamara

View Public Profile for jim mcnamara

Find all posts by jim mcnamara

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need help in detecting errors

Hi All , I need a script to find errors in a particular and in a particular path Actually in my logs i`ve so many kinds of errors(i can even say as 100 types also).if i run the script i need to know the error (some errors can aviod ) so finally the script o/p should be a numeric...

2. Shell Programming and Scripting

Finding the age of a unix process, killing old processes, killing zombie processes

I had issues with processes locking up. This script checks for processes and kills them if they are older than a certain time. Its uses some functions you'll need to define or remove, like slog() which I use for logging, and is_running() which checks if this script is already running so you can...

3. AIX

AIX not detecting LUN

Hello All, Really hoping someone can help. We have an AIX server connected to a Quantum SDLC sitting in front of an S10K library. The library has 3 logical partitions (two LTO4, one LTO3), so it requires 3 distinct medium changers. The SDLC presents the 3 luns (which are the medium...

4. Solaris

Identifying and grouping OS processes and APP processes

Hi Is there an easy way to identify and group currently running processes into OS processes and APP processes. Not all applications are installed as packages. Any free tools or scripts to do this? Many thanks.

5. UNIX for Advanced & Expert Users

Monitoring Processes - Killing hung processes

Is there a way to monitor certain processes and if they hang too long to kill them, but certain scripts which are expected to take a long time to let them go? Thank you Richard

6. Programming

Detecting interruptions in C

Hi. You may know how to detect when a interruption succeeded programming in C. Just like receiving a signal without blocking. Knowing when it was a keystroke (IRQ 2), or a mouse movement (12), or a disk access, etc. and getting actually for example the letter typed. Thanks a lot.

7. UNIX for Dummies Questions & Answers

Detecting Second disk

Hello all, first of all, I apologise if I may ask stupid or obvious questions, but I'm new to UNIX and I think I need a little bit of help before I start gearing up :) Anyway, I have installed a Solaris 8 on a Sun machine, and it has 2 physical disks in it. However, it seems that it is only...

8. IP Networking

Detecting NIC in Solaris10

I have an E420 server that has a TPE Slot / NIC installed. However there is no interface file installed eg /etc/hostname.hme0 or equivalent. I have placed a private ip entry int the hosts file to accompany the loop back entry i.e. 127.0.0.1 localhost 172.16.0.10 loghost se420 ...

9. Programming

Deadlocked App

Hello All - We have a legacy C program running non stop on one of our servers, with several instances often running at once. Fairly regularly, one of the instances while stop outputting to the log file and will just deadlock/hang. They must be then 'kill'ed by myself. When I gdb into one of...

10. UNIX for Dummies Questions & Answers

detecting drives

I know that Unix is different from windows in that it needs more manual configuring but how do I get Solaris 8 (Intel version) to recognize my floppy drive and cd-rom?? I mean does it automatically detect the drives at startup and I have to mount them or do I have to create the drives somehow and...

Login or Register to Ask a Question