This content has been marked as final. Show 3 replies
Thank you, much appreciated. I will try it and report back.
By the way, I guess an equivalent question would be - where can I find the data from v$archive_dest for a monitored instance in OEM's SYSMAN schema?
I can create a user-defined query but I assume this basic info is collected by default and already stored in OEM.
To identify the metric value of archive metrics (arch % full, etc)
SELECT target_name, metric_name, metric_column, value
where target_type = 'oracle_database'
and metric_name like 'arch%'
If you're actually looking for the location of arch_dest, the init params are collected and stored here.
select * from mgmt$db_init_params
where name like 'log_archive%';