There are so many funny things that can go on around the edges with TRUNCATE - especially when the tablespace is defined with the autoallocate option for extents and you do things with large objects.
How to reduce a truncate from 6 minutes to 2 seconds:
https://jonathanlewis.wordpress.com/2014/09/08/assm-truncate/

Comments