truncate WRI$ tables !
From: Nitin Saxena <ntnsxn7_at_gmail.com>
Date: Tue, 9 Jan 2018 07:44:35 -0800
Message-ID: <CAM+YwA8Hn-7yD-nvX6Rd9ucaA54b6nSbmph3SeO5YA+9weff5Q_at_mail.gmail.com>
Hi All,
Date: Tue, 9 Jan 2018 07:44:35 -0800
Message-ID: <CAM+YwA8Hn-7yD-nvX6Rd9ucaA54b6nSbmph3SeO5YA+9weff5Q_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 09 2018 - 16:44:35 CET