select m.name,c.cost
from sys.resource_cost$ c, sys.resource_map m where
c.resource# = m.resource#
and m.type# = 0
and c.resource# in (2, 4, 7, 8)
View Text - HTML Formatted
SELECT M.NAME , C.COST
FROM SYS.RESOURCE_COST$ C , SYS.RESOURCE_MAP M WHERE
C.RESOURCE# = M.RESOURCE#
AND M.TYPE# = 0
AND C.RESOURCE# IN (2 , 4 , 7 , 8)