Query: compute_instance_by_type

select
  shape as "Shape",
  count(*) as "Instances"
from
  oci_core_instance
where
  lifecycle_state <> 'TERMINATED'
group by
  shape
order by
  shape;