¿Is there a way to know if partitions in a table are being used by users/application?
Oracle Database Enterprise Edition Version 19.20.0.0.0.
¿Is there a way to know if partitions in a table are being used by users/application?
In other words, ¿How can we validate in Oracle if a table or old partitions in a partitioned table are receiving select/insert/update/delete?
We have a database occupying about 60TB and we need to free up space either by dropping those old tables or partitions that are not in use or moving them to a historical area due to legal requirements.
Regards,
Deida Navidad