Database Administration (MOSC)

MOSC Banner

How to view only hidden parameters that have been modified

edited Aug 11, 2021 7:19PM in Database Administration (MOSC) 7 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center