Re: Oracle is using lot of UNDO tablespace (Oracle 12c)

You are running 12.1.0.2. You only have shared UNDO in this version. PDB local undo is available in 12.2.

thx
jpm

Sent from my iPhone

> On Jan 15, 2017, at 12:34 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:
>
> Hi,
>
> I have a container and I have one pdb in Oracle 12c.
>
> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
> PL/SQL Release 12.1.0.2.0 - Production 0
> CORE 12.1.0.2.0 Production 0
> TNS for Linux: Version 12.1.0.2.0 - Production 0
> NLSRTL Version 12.1.0.2.0 - Production 0
>
> Connected as sysdba and as sysdba_at_instpdb I see these parameters related to undo.
>
> SQL> show parameter undo
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> temp_undo_enabled boolean FALSE
> undo_management string AUTO
> undo_retention integer 900
> undo_tablespace string UNDOTBS2
>
> Note : Look that I don´t see the local_undo_enabled parameter .
>
> I am doing a delete * from table and 7gb of tablespace undo is not being enough.
> It delete 13.000.000 lines and takes more then 15 minutes.
> It is not a production environment and I don´t want to save all data to recover in the future.
>
> I would like to know how to check if the UNDO option is on or off
> and
> How to disable the UNDO option in order to Oracle write the minimum in the undo tablespace.
>
> Regards
> Eriovaldo
>

--
http://www.freelists.org/webpage/oracle-l