Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Session hangs on "buffer busy waits"

RE: Session hangs on "buffer busy waits"

From: Vasu Balla <appsdba_at_gmail.com>
Date: Sat, 19 May 2007 15:01:24 +0530
Message-ID: <000001c799f8$7f3223c0$0501a8c0@h0me> 





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. 




--
http://www.freelists.org/webpage/oracle-l


Received on Sat May 19 2007 - 04:31:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US