DEDICATED_TASK option

Function

Dedicates a request handling task to handling requests from a single connection.

Allowed values

ON, OFF

Default

OFF

Scope

Can be set as a temporary option only, for the duration of the current connection. Requires DBA permissions to set this option.

Description

When the DEDICATED_TASK connection option is set to ON, a request handling task is dedicated exclusively to handling requests for the connection. By pre-establishing a connection with this option enabled, you can gather information about the state of the database server if it becomes otherwise unresponsive.