02 Nov 2023 07:51 AM - last edited on 20 Aug 2024 08:55 AM by Michal_Gebacki
Solved! Go to Solution.
02 Nov 2023 08:03 AM
Hi @bvypk
Sorry, but I don't quite understand what your problem is. Your question is about DB monitoring problems (is that the problem you are getting?) or lack of functionality on the DT side?
Radek
02 Nov 2023 08:08 AM
We configured oracle DB monitoring under Dynatrace but due to the below error DB is not reporting monitoring.
15 Dec 2023 11:17 AM
Hi @bvypk @radek_jasinski any update on this? Is the issue resolved?
15 Dec 2023 01:00 PM
Hi @bvypk
This error mainly related to user limits, you can run the below query to see what is the limit put for your user
SELECT
to_char(m.begin_time,'hh24:mi') "start time",
to_char(m.end_time,'hh24:mi') "end time",
m.value "current value",
s.average "average value",
m.metric_name,
m.metric_unit
FROM
v$sysmetric m,
v$sysmetric_summary s
WHERE
m.metric_id = s.metric_id
AND s.average > 0
AND ((m.value - s.average)/s.average)*100 >= 10
AND lower(m.metric_name) NOT LIKE '%ratio%';
Also, you need to make sure that you fullfiled point #3 in the below document to get all metrics supported by the extension.
https://docs.dynatrace.com/docs/shortlink/extend-oracle#before-you-begin
Thanks,
Islam