Oracle: V$BGPROCESS

v$bgprocess displays information about background processes.

Instance critical processes

Instance critical processes can be found using the attributes json value:

select
   b.name,
   b.description,
   b.*
from
   v$bgprocess b
where
   json_value(attributes, '$.instance_critical') = 'yes'
-- and paddr <> '00'
;

Oracle: V$BGPROCESS

Instance critical processes

See also