On, Off

Off

Can be set as a temporary option only, for the duration of the current connection. DBA authority required.

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 will be able to gather information about the state of the database server if it becomes otherwise unresponsive.

• dedicated_task connection property