Table Split Partition
Dears,
I have Oracle rac database 19c on linux 7 2 nodes.
One of my tables contain clob columns, this table is already partitioned on monthly basis and only one partition is kept online, but this partition is reaching almost 300GB, the plan is to make it weekly partition but this would require downtime as doing it online would impact performance as its heavily accesses.
our solution is to split this partition at the middle of the month into 2 partitions and drop the first partition.
I would like to know if there is any performance impact during this activity on the table knowing that it contain around 8M records on monthly basis.
I have Oracle rac database 19c on linux 7 2 nodes.
One of my tables contain clob columns, this table is already partitioned on monthly basis and only one partition is kept online, but this partition is reaching almost 300GB, the plan is to make it weekly partition but this would require downtime as doing it online would impact performance as its heavily accesses.
our solution is to split this partition at the middle of the month into 2 partitions and drop the first partition.
I would like to know if there is any performance impact during this activity on the table knowing that it contain around 8M records on monthly basis.
Tagged:
0