How to detect Partitioning feature usage?

By using dba_part_tables view

column Partitioning format a15;
SELECT DECODE(COUNT(*), 0, 'No', 'Yes') Partitioning
FROM
  (SELECT 1
  FROM dba_part_tables
  WHERE owner NOT IN ('SYSMAN', 'SH', 'SYS', 'SYSTEM')
  AND rownum       = 1
  );

Sample output:-