Database DataWarehousing (MOSC)

MOSC Banner

¿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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center