Re: truncate WRI$ tables !

There area a bunch of notes on the subject if you search MOS for those tables.

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.

Stefan

On Tue, Jan 9, 2018 at 10:44 PM, Nitin Saxena <ntnsxn7_at_gmail.com> wrote:

> Hi All,
>
> Any negative impact of truncating following tables before upgrade?
>
>
>
> WRI$_OPTSTAT_HISTHEAD_HISTORY;
> WRI$_OPTSTAT_HISTGRM_HISTORY;
>
> Do these tables have impact on current stats , performance and SPM?
>
>
> Thanks
> Nitin
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle

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