Oracle: V$RESOURCE_LIMIT

select
   rl.resource_name,
   nvl2(pm.name, 'X', '') also_init_parameter   
from
   v$resource_limit  rl                                           left join
   v$parameter       pm on rl.resource_name = pm.name
order by
   rl.resource_name;