MDSYS, MDDATA,SPATIAL_CSW_ADMIN_USR and SPATIAL_WFS_ADMIN_USR

 Oracle Spatial and graph

These features are designed to handle complex data types such as spatial (geographic) data, graph data , GPS coordinates.
MDSYS -The Oracle Spatial and Oracle Multimedia Locator administrator account
MDDATA-  The schema used by Oracle Spatial for storing Geocoder and router data.
SPATIAL_CSW_ADMIN_USR –
SPATIAL_WFS_ADMIN_USR -

connect / as sysdba

 

 set pagesize 10000

 col owner format a12

 col table_name format a35

 col column_name format a25

 col index_name format a25

 

 -- Is Spatial being used?

 

 select owner, index_name

 from dba_indexes

 where ityp_name = 'SPATIAL_INDEX';

 

 select owner, table_name, column_name

 from dba_tab_columns

 where data_type= 'SDO_GEOMETRY'

 and owner != 'MDSYS';

If both of these queries return no rows, Spatial is not being used.