SELECT p1.id, SUM(i.area) AS total_area_intersected
FROM your_table_partitioned p1
INNER JOIN (
  SELECT p2.id, SDO_GEOM.SDO_AREA(SDO_GEOM.SDO_INTERSECTION(p1.geom, SDO_GEOM.SDO_BUFFER(p2.geom, 150))) AS area
  FROM your_table_partitioned p2
  WHERE p1.id <> p2.id
  AND SDO_RELATE(p1.geom, SDO_GEOM.SDO_BUFFER(p2.geom, 150), 'MASK=ANYINTERACT') = 'TRUE'
) i ON p1.id = i.id
GROUP BY p1.id;