Oracle hidden parameter from sysman.mgmt$db_init_params view
From: Mohamed Houri <mohamed.houri_at_gmail.com>
Date: Wed, 1 Feb 2023 11:55:57 +0100
Message-ID: <CAJu8R6gSkRHjAraZWVBfpmnN+rQ=ZrgFj=iC52RR4gtQw6B8LA_at_mail.gmail.com>
Hi all
<https://twitter.com/MohamedHouri>
-- http://www.freelists.org/webpage/oracle-l Received on Wed Feb 01 2023 - 11:55:57 CET
Date: Wed, 1 Feb 2023 11:55:57 +0100
Message-ID: <CAJu8R6gSkRHjAraZWVBfpmnN+rQ=ZrgFj=iC52RR4gtQw6B8LA_at_mail.gmail.com>
Hi all
I would like to check the value of several parameters in a couple of hundred of databases. So I use the following query in the OMR sysman repository
select
substr(target_name,1,8) dbname
,name
,value
from
sysman.mgmt$db_init_params
where
name ='_addm_auto_enable'
order by
1,2;
Unfortunately, the *mgmt$db_init_params* view is based on the contents of the *v$parameter* view which does not show the values of the hidden parameters when they have not been modified.
Do you know if it is possible to get this information from the sysman tables?
Thanks
PS: The *sysman.mgmt$db_init_params_all* view does not also provide this information
-- Houri Mohamed Oracle DBA-Developer-Performance & Tuning Visit My - Blog <http://www.hourim.wordpress.com/> Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>* My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri
<https://twitter.com/MohamedHouri>
-- http://www.freelists.org/webpage/oracle-l Received on Wed Feb 01 2023 - 11:55:57 CET