Re: truncate WRI$ tables !

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 10 Jan 2018 08:51:51 -0500

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

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2018