Query returns a list of tablespaces that contain XMLTypes:

select distinct p.tablespace_name from dba_tablespaces p, 

  dba_xml_tables x, dba_users u, all_all_tables t where

  t.table_name=x.table_name and t.tablespace_name=p.tablespace_name

  and x.owner=u.username;