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 DECEMBER 01, 2016

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

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