8. SQL Statements : SET : Session With Priority
Session With Priority
The SESSION_PRIORITY option sets the relative importance of a session. A session can have a higher (more important) or lower (less important) priority than a session with the base or normal priority.
Only users with the SESSION_PRIORITY resource privilege can change their session priority, subject to the limit defined by the system administrator. Three fixed settings and one variable setting are available:
Uses the value known at session startup.
Uses the lowest (least important) priority.
Uses the highest (most important) priority.
Uses the session priority defined. The priority variable is specified as an integer. A positive value sets a higher priority than the base priority. A negative value sets a lower priority than the base priority. Due to operating system restrictions, the number of values above and below the base priority may be limited.