Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: Session hangs on "buffer busy waits"

GoLeM

2007-05-19

Replies:

Message
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.

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.