8. SQL Statements : SET : Session With Priority
 
Share this page                  
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:
INITIAL
Uses the value known at session startup.
MINIMUM
Uses the lowest (least important) priority.
MAXIMUM
Uses the highest (most important) priority.
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.