My Oracle Support Banner

How to Monitor the Engine To-Do Items in Regards to Expired Execution Items (Doc ID 1384583.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 5.7 to 10.3
Information in this document applies to any platform.


When BPM process instances seem to be stuck, operations to instances take long times, or there is a general slowness in the system it is recommended to monitor the To-Do Items table and queue.

This article provides an example of how to query the PTODOITEMS table to detect any expired (or non-later) items along with their oldest due date. This document applies to BPM versions 10g and earlier.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Querying the number of expired to-do items
 Querying the count of expired items per instance
 Monitoring the JMS system
 Reviewing recovery thread settings
 Contacting BPM Support

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.