Is statspack useful when using OEM ?
Hi all,
I've noticed that it's possible to generate OEM reports about instances with data old up to one month (sessions for example), no matter if statspack is installed on the target or not.
So I am wondering :
- Is OEM gathering statistics about targets (hosts, instances...) independantly from statspack or AWR ? If it so, how is it possible to reduce the size of MGMT_TABLESPACE in the repository ? It keeps on growing all the time...
- Is statspack really useful if OEM is able to generate reports even if it's not installed on targets ? If statspack is not installed, there is no data available for example in the performance page for an instance, but I can find most of this data in an OEM report. Why should I let statspack using space and resources on targets if OEM collects statistics anyway ?
thanks for you explanations !
regards,
Antoine