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 APRIL 09, 2025

Applies to:

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

Goal

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.

Solution

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
Goal
Solution
 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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.