How to view only hidden parameters that have been modified
hi,
How to view hidden parameters that have been modified from their default value? I don't want to see all the hidden parameters (because they are too many), I just want to see the ones that were modified/change from their default value.
According to (Doc ID 315631.1) I can view hidden parameters using below query. But I don't want to see all, I only want to view the hidden parameters that have been changed. Thanks.
set linesize 2000 COLUMN parameter FORMAT a37 COLUMN description FORMAT a75 WORD_WRAPPED COLUMN session_value FORMAT a10 COLUMN instance_value FORMAT a10 SELECT a.ksppinm AS parameter, a.ksppdesc AS description, b.ksppstvl AS session_value, c.ksppstvl AS instance_value FROM x$ksppi a, x$ksppcv b, x$ksppsv c WHERE a.indx = b.indx AND a.indx = c.indx AND a.ksppinm LIKE '/_%' escape '/' ORDER BY a.ksppinm;