How To Set A Timeout On DM For Long Queries -Database_Request_Timeout_Duration
Last updated on MARCH 21, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [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 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms