One can make Oracle suspend a session if it runs out a free space by enabling resumable timeout. This can be set by as follows and the value is in seconds: -- Set a session timeout to be 1800 SQL> alter session enable resumable timeout 1800; Session altered. -- Example: Set system wide resuamble timeout … Continue reading Resumable timeout explained →