Question on UNDO tablespace retention guarantee

From: Anurag Verma <anuragdba_at_gmail.com>
Date: Tue, 26 Mar 2019 19:03:41 -0700
Message-ID: <CAFJhYoAUsarPVQqoQcTJ9jqC2iWE5oO=-YaqRiTh5uem60LLRQ_at_mail.gmail.com>

If I use the below to avoid "snapshot too old" errors, will it cause any performance issues to DML statements ?

alter tablespace undotbs1 retention guarantee;
--

For example, if large transactions running and if it consumed all free UNDO space, will the new DMLs have to wait for getting free UNDO space ?

Thanks,
Anurag Verma

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 27 2019 - 03:03:41 CET