Re: Question on global index maintenance
Date: Fri, 07 Jan 2022 21:08:35 +0000
Message-ID: <ycfE9kjib0TlNa2IOMUPzgiLLyBntRGNDWKrBis38WQAcr5oGx9YlsSvtA4BlopDpot8CcnZMrJtT-FizISrURb3_pQ5TLhaCgD0v5exq8k=_at_klockmail.com>
Hi Lok,
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, January 7th, 2022 at 3:35 PM, Lok P <loknath.73_at_gmail.com> wrote:
Global indexes are still feasible and sometimes necessary (unique constraints, for example), but because of the maintenance you speak of, local indexes would be preferred where appropriate.
Partition DROPS and TRUNCATES are measurably faster now that Oracle is deferring the cleaning up of orphaned entries, but your concerns are still very valid. Depending on size, I've had cases where cleaning wasn't able to complete within the maintenance window, even with parallelism enabled. There were also cases where sessions were being blocked by the clean job and those segments had to be deferred and index rebuilds had to be done during downtime windows. And worthy of note (though kind of obvious), if the clean jobs aren't able to complete then those segments are continuously growing.
Andy K
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 07 2022 - 22:08:35 CET