Oracle: get a lot of variables

Run this query as SYS user:

SELECT ksppinm AS param_name, ksppdesc AS descr, ksppstvl AS param_value, ksppstdvl AS default_value, ksppstcmnt AS comments
FROM x$ksppi
INNER JOIN x$ksppcv USING(indx)
WHERE ksppinm LIKE '%bind_capture%' -- This line is optional, of course
ORDER BY ksppinm;