Core Workflow - EBS (MOSC)

MOSC Banner

Question about APPS_TS_QUEUES

edited Oct 5, 2016 5:00AM in Core Workflow - EBS (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center