Use this WHERE clause in a definition query or the Select By Attributes window:
sde.st_numgeometries(shape) > 1
There is a known bug in versioned Oracle SDE.ST_GEOMETRY FCs. The above WHERE clause will throw an error: ORA-00904 Invalid Identifier "SHAPE".
Use a subquery.
sde.st_numgeometries(shape) > 1)
That bug only happens for SDE.ST_GEOMETRY.
Whereas if the FC was SDO_GEOMETRY, then spatial functions would work fine — even if the FC was versioned.
sdo_util.getnumelem(shape) > 1