Question about APPS_TS_QUEUES
Hi
we found APPS_TS_QUEUES grow rapidly from 8/27 to 8/30
DATE TABLESPCE NAME TOTAL(MB) MAX(MB) USED(MB) FREE(MB) RATE STATUS
2016/08/27 04:22:54 APPS_TS_QUEUES 1000 1000 675 325 67.46 NORMAL
2016/08/30 04:24:47 APPS_TS_QUEUES 1000 1000 804 196 80.38 WARNING
By the SQL below,we found WF_JAVA_DEFERRED and WF_DEFERRED occupy most space
select owner, segment_name, segment_type, (bytes/1024/1024) MB from dba_segments where tablespace_name ='APPS_TS_QUEUES' order by bytes desc;
OWNER SEGMENT_NAME SEGMENT_TYPE MB
-------------------------------------------------------------------------------
APPLSYS WF_JAVA_DEFERRED TABLE 333
APPLSYS WF_DEFERRED TABLE 129.375
APPLSYS WF_NOTIFICATION_OUT TABLE 63.375
APPLSYS WF_DEFERRED_TABLE_M TABLE 28.75
From Workflow Agent Listener Service log,we found Workflow Agent Listener Service are running at that time,for detail,please check the attachment.