Sort segment request

Oracle: sort segement request

ØSMON allocates sort space in Temp Tablespace

ØIf SMON is busy this can cause waits for sort space

ØSMON may be stuck rolling back