Re: truncate WRI$ tables !
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 10 Jan 2018 08:51:51 -0500
Message-ID: <6f1935b9-74a3-13d0-d1c3-006dc2d16ede_at_gmail.com>
Date: Wed, 10 Jan 2018 08:51:51 -0500
Message-ID: <6f1935b9-74a3-13d0-d1c3-006dc2d16ede_at_gmail.com>
On 01/09/2018 11:40 AM, Stefan Knecht wrote:
> Personally, I'd refrain from just truncating them. I'd instead use
> dbms_stats.purge_stats to purge the entire history, and then, IF the
> tables are empty, truncate them.
>
I wouldn't do that. Those tables will be re-populated and the space will
be allocated again. By leaving the space allocated, one can save some
time on the next DBMS_STATS runs.
Regards
-- Mladen Gogala Database Consultant http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 10 2018 - 14:51:51 CET