My Oracle Support Banner

How To Set A Timeout On DM For Long Queries -Database_Request_Timeout_Duration (Doc ID 790820.1)

Last updated on JULY 18, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.0.0 to 7.3.0]
Information in this document applies to any platform.


In case the DM_ORACLE is waiting for the return of a statement from the database, the Out-Of-The-Box configuration is such that the DM will wait endlessly until the database returns.

There are cases where a timeout in this process is needed, to stop the Data Manager (DM) waiting for the database.

An example is an operation which has already been timed-out on the client application, hence leaving orphan session on the Connection Manager (CM), DM and DB.

Another example could be a very long query on the database within a real-time, or Customer Relationship Management  (CRM) scenario, which should be terminated after a predefined maximum wait time.

Note that while the DM is waiting for the DB to return from the statement call, a DM backend session will be reserved for that statement and this session is unavailable to the rest of the system.


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

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