On, Off

Off

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

If you set this option temporarily, that setting applies to the current connection only. Different connections under the same user ID can have different settings for this option.

Intra-query parallelism is not used for connections with background_priority set to on.

When this option is set to On, requests execute at the Background priority level. When this option is set to Off, requests execute at the value specified by the Priority option.

• priority option
• max_priority option
• background_priority connection property