Dedicates a request handling task to handling requests from a single connection.
Option can be set as a temporary option only, for an individual connection or for the PUBLIC role, for the duration of the current connection.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
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.