APPLSYSD and APPLSYSX Tablespaces Growing Fast
(Doc ID 1079108.1)
Last updated on OCTOBER 24, 2016
Oracle Workflow - Version 22.214.171.124 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 18-JAN-2014
APPLSYSD and APPLSYSX are growing very quickly after an upgrade. As soon as the Workflow Agent Listener is started then the WFERRORs start getting initiated again at a very fast rate.
Error Message [WF_ERROR] ERROR_MESSAGE=ORA-00604: error occurred at recursive SQL level 1 ORA-01631: max # extents (505) reached in table APPLSYS.WF_NOTIFICATION_OUT ERROR_STACK= WF_EVENT_OJMSTEXT_QH.enqueue(APPLSYS.WF_NOTIFICATION_OUT, SQL error is ORA-00604: error occurred at recursive SQL level 1 ORA-01631: max # extents (505) reached in table APPLSYS.WF_NOTIFICATION_OUT) Wf_Event.Enqueue(oracle.apps.wf.notification.send, WF_EVENT_OJMSTEXT_QH) Wf_Event.Send(oracle.apps.wf.notification.send) Wf_Rule.Default_Rule(oracle.apps.wf.notification.send, F31CD467F54ECFDCE0301DAC0C036959)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms