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

Last updated on JANUARY 29, 2024

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.

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

Applies to:

Goal

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!