Re: Oracle hidden parameter from sysman.mgmt$db_init_params view

Hello Mohamed,

Probably you know already but just in case, you can achieve this by creating a metric extension with the mentioned query: -> enterprise -> monitoring -> metric extensions --- actions -> create-> metric extension (target_type DB and adapter sql query) , deploy the metric on all the DBs you are interested in then query the view MGMT$METRIC_CURRENT.once all metric collects the data

Good luck.

În mie., 1 feb. 2023 la 12:57, Mohamed Houri <mohamed.houri_at_gmail.com> a scris:

> 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