APPLSYSD and APPLSYSX Tablespaces Growing Fast (Doc ID 1079108.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Workflow - Version 11.5.10.2 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

Symptoms

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)

Cause

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