cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle19c - Partitioning detection

mag00_75
By Level 8 Champion
Level 8 Champion

We have seen that Flexera detects Partitioning in our newly installed Oracle DBEE 19c databases. There is an ongoing Flexera case in regards to this, however I would like to get the view from the community as well if you experience the same issues with 19c databases. Since with Oracle it's always a struggle to convince if the licenses are in use or if the scripts are telling the wrong truth.

The hypothesis which I believe in, is that with this release Oracle are including Spatial in the installation which adds some table and index with Owner MDSYS. With the latest inventorysettings.xml version 45 this owner is not filtered as an Oracle system user, and by that the partitioning option is detected.

One quick way for you to see if you have similar issue would to check owners of tables which are partitioned.

SQL>  select distinct(owner) from dba_tables where PARTITIONED='YES';  

OWNER
--------------------------------------------------------------------------------

SYS
SYSTEM
AUDSYS
MDSYS (not filtered in Flexera scripts)

These are the actual evidences that triggers the Partitioning option to be in Use.

OWNER

SEGMENT_TYPE

SEGMENT_NAME

MDSYS

INDEX PARTITION

SDO_TXN_JOURNAL_REG_IDX

MDSYS

TABLE PARTITION

SDO_TXN_JOURNAL_REG

(0) Replies