Database Administration (MOSC)

MOSC Banner

Where can I find information about the use the system user has of oracle partitions ?

edited Apr 7, 2025 6:17PM in Database Administration (MOSC) 4 commentsAnswered ✓

I am using a Oracle 19C release 26 on RH7 both enterprise editions. I am not sure where would I ask this question so here it goes.

I need to know if I should buy the oracle partition license even though we do not actively use partition for our tables but the oracle user system does use it; it also shows as an active option in the list provided by dba_feature_usage_statistics.

The information below is from the production database:

Partitioning (system) 204 20-DEC-2014 11:19:28 10-NOV-2018 23:24:28

Partitioning (user) 271 19-JAN-2020 14:22:18 30-MAR-2025 02:28:14

The table below is the use of Partitioning from the OEM:

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