RE: Session hangs on "buffer busy waits" - oracle-l - FreeLists

RE: Session hangs on "buffer busy waits"

From: "Vasu Balla" <appsdba@xxxxxxxxx>
To: <Naveen.Nahata@xxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>
Date: Sat, 19 May 2007 15:01:24 +0530

probably you need some purging on these workflow tables n queues. check
whether following concurrent programs are scheduled to run periodically in
your instance
 
Purge Obsolete Workflow Runtime Data
Workflow Control Queue Cleanup
 
vasu

 

I tracked down the block to AQ$_WF_JAVA_DEFERRED_I table.

References:
- Session hangs on "buffer busy waits"
  - From: Nahata, Naveen

Other related posts:

» Session hangs on "buffer busy waits"
» RE: Session hangs on "buffer busy waits"