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.