Re: Inserting with billion of rows faster

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 1 Apr 2021 12:36:27 +0100
Message-ID: <CAGtsp8n-4X4Ryp5tW1BfOZTjFLiru1w90TyjSvo=FzDAQH=cOQ_at_mail.gmail.com>

Follow-up to my previous comments about dropping or affecting the size of undo segments. Read MOS nod 1580182.1
The basic comment is that you can hit this problem if you have very long running transactions and a very large undo retention - and it probably needs a reasonable level of concurrency as well, but that's not stressed.

It is possible to set a debug parameter that allows you to shrink undo segments by name - details in the note.
It seems to work.

Regards
Jonathan Lewis

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

Received on Thu Apr 01 2021 - 13:36:27 CEST

This message: [ Message body ]
Next message: Lok P: "Re: Inserting with billion of rows faster"
Previous message: Pap: "Slow running Delete query for same data volume"
Maybe in reply to: Jonathan Lewis: "Re: Inserting with billion of rows faster"
Next in thread: Lok P: "Re: Inserting with billion of rows faster"
Reply: Lok P: "Re: Inserting with billion of rows faster"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message