03-09-2004
well here is a thing i am sure you have thought about it but might as well state the obvious.
1) since you notice a relationship between java proccess and locked oracle procecess.
i would do the following in prouction code.
1) for every call to the db set a timeout for that session.
2) put into effect a cleanup routine so if any connections get cut or bomb out you will not have ghost processes hanging around keeping a table locked.
3) run some kinda sql query on the db via cron or other mechignisim that looks for this condition prior to it becomeing a problem.
as far as tracking down this problem.
your programmers will have to figure out which java app is makeing the offending call to the rows.
i can only assume the occurances are random but the condition is the same.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I've got a really weird situation here.... the same IP address keeps popping up in porn spam that I have rec'd in 2 different email accts. It looks to me like it's coming from UC Davis, and I suspect someone there, so I am hoping you all can verify the same thing before I call the person on this... (0 Replies)
Discussion started by: christinef
0 Replies
2. Solaris
Hello everyone,
I have a 12-thread application running on Solaris 9.
When I use the pstack command after a typical core dump, it prints the stack output of all 12 threads/lwps. This is the standard procedure as it is described in the Solaris MAN pages.
Is there a way to filter out the... (1 Reply)
Discussion started by: gregb32
1 Replies
3. Red Hat
Can someone tell me the Linux equivalent for pstack and pfiles and ptree which are Solaris commands. (1 Reply)
Discussion started by: bdsffl
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I am running solaris and I need help in deciphering the following commands:
dir_t1=`echo $0|nawk -F'/' '{print NF}'`
dir_t2=`expr $dir_t1- 1`
dir_t3=`echo $0|cut -d'/' -f1-$dir_t2`
export dir_t2
What will be the value for dir_t3?
Please help !!!!!!!!!!!!!!! (5 Replies)
Discussion started by: Phuti
5 Replies
5. Shell Programming and Scripting
Guys,
I am going through an existing code in production and found the following lines. I have used "sed" before but am unable to decipher the following statement. :(
echo ${F_NAME} | sed 's/\(.*\)............/\1/'
Any help is greatly appreciated.
Cheers,
Sid (6 Replies)
Discussion started by: sid1982
6 Replies
6. Ubuntu
Hi All
I would like to use the tool "pstack" to get a sample of the stack trace for a process.
As far as I understood It seems widely available in all Linux systems, but it is not in Ubuntu 10.10.
I tried using apt-get as per some posts in few forum, but it cannot be found in the APT... (9 Replies)
Discussion started by: manustone
9 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I'm having a problem when I run the following code for example
perl -e 'use LWP::Simple; getprint "http://google.com"'
Can't locate LWP/Simple.pm in @INC (@INC contains: /System/Library/Perl/5.8.6/darwin-thread-multi-2level /System/Library/Perl/5.8.6... (7 Replies)
Discussion started by: pawannoel
7 Replies
8. Solaris
Hi ...
Can you please share how to analyse pstack file and various options for core dump analysis (3 Replies)
Discussion started by: anand87
3 Replies
9. Shell Programming and Scripting
ssh-add -t 30 >/dev/null 2>&1
LOGNAME=`whoami`
cp $HOME/.ssh/known_hosts $HOME/.ssh/known_hosts.org grep -v localhost
$HOME/.ssh/known_hosts.org > $HOME/.ssh/known_hosts
ssh -1 -f -l $LOGNAME -o "ForwardX11 yes" -o "StrictHostKeyChecking no"
-L 6003:1.1.1.1:2222 ext-proxy-2 sleep 5... (1 Reply)
Discussion started by: llcooljatt
1 Replies
10. SuSE
ssh-add -t 30 >/dev/null 2>&1
LOGNAME=`whoami`
cp $HOME/.ssh/known_hosts $HOME/.ssh/known_hosts.org
grep -v localhost $HOME/.ssh/known_hosts.org > $HOME/.ssh/known_hosts
ssh -1 -f -l $LOGNAME -o "ForwardX11 yes" -o "StrictHostKeyChecking no" -L 6003:195.244.210.107:2222 ext-proxy-2 sleep 5... (7 Replies)
Discussion started by: llcooljatt
7 Replies
LEARN ABOUT CENTOS
wait_event_interruptible_exclusive_locked_irq
WAIT_EVENT_INTERRUPT(9) Driver Basics WAIT_EVENT_INTERRUPT(9)
NAME
wait_event_interruptible_exclusive_locked_irq - sleep until a condition gets true
SYNOPSIS
wait_event_interruptible_exclusive_locked_irq(wq, condition);
ARGUMENTS
wq
the waitqueue to wait on
condition
a C expression for the event to wait for
DESCRIPTION
The process is put to sleep (TASK_INTERRUPTIBLE) until the condition evaluates to true or a signal is received. The condition is checked
each time the waitqueue wq is woken up.
It must be called with wq.lock being held. This spinlock is unlocked while sleeping but condition testing is done while lock is held and
when this macro exits the lock is held.
The lock is locked/unlocked using spin_lock_irq/spin_unlock_irq functions which must match the way they are locked/unlocked outside of this
macro.
The process is put on the wait queue with an WQ_FLAG_EXCLUSIVE flag set thus when other process waits process on the list if this process
is awaken further processes are not considered.
wake_up_locked has to be called after changing any variable that could change the result of the wait condition.
The function will return -ERESTARTSYS if it was interrupted by a signal and 0 if condition evaluated to true.
COPYRIGHT
Kernel Hackers Manual 3.10 June 2014 WAIT_EVENT_INTERRUPT(9)