This content has been marked as final. Show 3 replies
Which metric do you have problems in? Usually it is metric 16. The metric 16 is very complicated and it does not consist of just one SQL.
As for CACHE segments they are excluded from the metric.
Maybe You will need exact SQLs from the metric so you can enable DBSPI tracing and look at the trace. But it will be very hard job.
I would recommend to run reports for the metric 16 to see which segments cannot be extended.
If you have any questions, ask.
monitoring tool is triggering the below ticket frequently.Which monitoring tool raising this alert ? is it OEM ?
At first, I was really confused but I think that what I wrote above can be the right decisions.