Truncate table oracle 11.2
Version: Oracle 11.2.0.3.0
Having performance issues on truncate table, try to use it with [drop all storage]:
truncate table foo: t seconds
truncate table foo drop storage: t seconds
truncate table foo reuse storage: t seconds
truncate table foo drop all storage : t/3 seconds
Having performance issues on truncate table, try to use it with [drop all storage]:
truncate table foo: t seconds
truncate table foo drop storage: t seconds
truncate table foo reuse storage: t seconds
truncate table foo drop all storage : t/3 seconds
Yorumlar