Re: Parameter resumable_timeout
From: Yong Huang <"Yong>
Date: Fri, 21 Oct 2016 14:33:05 +0000 (UTC)
Message-ID: <307917422.337936.1477060385532_at_mail.yahoo.com>
> system wide, we still have to issue an *alter session enable resumable *to
> use this feature?
Date: Fri, 21 Oct 2016 14:33:05 +0000 (UTC)
Message-ID: <307917422.337936.1477060385532_at_mail.yahoo.com>
> 1. In Oracle 10g+, along setting the *resumable_timeout *parameter
> system wide, we still have to issue an *alter session enable resumable *to
> use this feature?
Luis,
My test in 11.2.0.3 and 12.1.0.2 shows that you don't have to. A system-wide non-zero value for this parameter will enable resumable with this timeout value for the session that runs out of space. But if the session explicitly enables resumable, it will have a timeout of 7200 seconds (if not set) or whatever timeout it explicitly sets. Confusingly, in the former case, dba_resumable only shows the session already starting to hang waiting for more space, while in the latter case, the view shows the session as soon as it enables resumable.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 21 2016 - 16:33:05 CEST