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 MARCH 21, 2018

Applies to:

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

Goal

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 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 CM, DM and DB.

Another example could be a very long query on the database within a real-time, or 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.

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
References

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