Where can I find information about the use the system user has of oracle partitions ?
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: