Why does Drop table run so slowly?
Hi All,
My DB is 11.1.
Today I wrote a procedure, the logic of which is to rename tableA to tableA_bk, then create a new tableA and copy data from tableA_bk to new tableA. After that drop tableA_bk. Both tableA and tableA_bk have 7 partitions that in turn have 40 subpartitions respectively.
I find that it cost me 10 mins to drop tableA_bk. I guessed it might be related to checkpointing the dirty blocks. But I didn't do any operations on table_bk, there shouldn't be too much dirty blocks. Correct?
Could it be because of too much subpartitions?
My DB is 11.1.
Today I wrote a procedure, the logic of which is to rename tableA to tableA_bk, then create a new tableA and copy data from tableA_bk to new tableA. After that drop tableA_bk. Both tableA and tableA_bk have 7 partitions that in turn have 40 subpartitions respectively.
I find that it cost me 10 mins to drop tableA_bk. I guessed it might be related to checkpointing the dirty blocks. But I didn't do any operations on table_bk, there shouldn't be too much dirty blocks. Correct?
Could it be because of too much subpartitions?
0