DBA_FEATURE_USAGE_STATISTICS reports Oracle Spatial is used (Doc ID 1381022.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Spatial and Graph - Version 10.1.0.3 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2013***

Symptoms

DBA_FEATURE_USAGE_STATISTICS view reports that Oracle Spatial (SDO) is being used

SQL> SELECT name,currently_used,last_usage_date,description
  2  FROM DBA_FEATURE_USAGE_STATISTICS
  3  WHERE upper(name) like '%SPATIAL%';

NAME       CURRE LAST_USAG DESCRIPTION
---------- ----- --------- ------------------------------------------
Spatial    TRUE  19-NOV-11 There is at least one usage of the Oracle
                           Spatial index metadata table.


However, DBA_REGISTRY shows that SDO is not installed.

SQL> SELECT substr(comp_id,1,12)Comp_ID, Status,
  2  substr(Version,1,10)Version,
  3  substr(Comp_Name,1,40)Comp_Name
  4  FROM DBA_Registry
  5  WHERE comp_id = 'SDO';

no rows selected


Are we using SDO?  We need to ensure that we are only using Oracle Locator in order to comply with licensing requirements.

DBA_REGISTRY shows we have Oracle Multimedia (Oracle interMedia in 10g) is installed.

SQL> SELECT substr(comp_id,1,12)Comp_ID, Status,
  2  substr(Version,1,10)Version,
  3  substr(Comp_Name,1,40)Comp_Name
  4  FROM DBA_Registry
  5  WHERE comp_id = 'ORDIM';

COMP_ID      STATUS     VERSION    COMP_NAME
------------ ---------- ---------- ----------------------------------------
ORDIM        VALID      11.1.0.7.0 Oracle Multimedia

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms