My Oracle Support Banner

Is there a way to automatically kill long running SQL statements (Oracle DB only) at the database after a pre-determined maximum waiting time ? DisableExecuteRetry (Doc ID 753941.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.

Goal


Is there a way to automatically kill long running SQL statements at the database after a pre-determined maximum waiting time ?

these SQLs will be triggered by inbound web service calls, which represent 60% of the expected transaction volume in this customer specific scenario.

the driver for the question is performance

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!


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