PROBLEM:

While doing a transaction, it was hung for few seconds and got the below error.

CAUSE & SOLUTION:

Let’s check the alert log:

It clearly shows, there was a space crunch on the tablespace TEST_2, which suspended the sql statement for the sometime before throwing timeout error.

That time duration is defined in resumable_timeout parameter

So the statement will be suspended for only 10 seconds. And any action like adding space to the tablespace need to be carried within that 10 seconds, to avoid timeout error.

Let’s set to a higher value i.e 3600 ( 1 hr), which will give us some more time, before it is being timed out.