Saturday, September 6, 2008

RESUMABLE_TIMEOUT

Temp tablespace filling up and you can't work out who is doing it ?

set RESUMABLE_TIMEOUT. The session will hang when it runs out of space, and you can decide whether to kill the session, or add space. Note that while the temp tablespace is full other sessions will hang also, so think carefully whether you would prefer consumers of abnormally large amounts of space to terminate, or potentially hang other sessions.