I have two partitions on table named Partition A and Partition B .
I am inserting the data into the partitioned table and truncating Partition B at the same time.
Thus ,the truncating is taking very long time . Please advise if we can do any thing to optimise the Truncate performace.
Session 1 :
Insert into partitioned_table ()
Session 2 :
Alter table partitioned_table truncate partition PARTITION B
Thanks in advance.
[EDITED by LF: removed superfluous empty lines]
[Updated on: Tue, 24 July 2012 09:14] by Moderator
Report message to a moderator