Query: kms_key_lifecycle_state

select
  case when lifecycle_state = 'DISABLED' then 'disabled' else 'ok' end as status,
  count(*)
from
  oci_kms_key
where
  lifecycle_state <> 'DELETED'
group by
  status;