Hi all,
In addition to the Oracle Enterprise Manager , I want to create a weekly report with some status data about Database (tablespaces usage, top 10 segments, unused indexes, jobs status, stale statistics, expired users, invalid objects, alert.log errors, listener errors).
The goal is to generate charts and tables and then perform a critical analysis.
Any tool that you suggest to generate the automatic part of this report? I was thinking in use python / cx_oracle / python matlab tools. I've done a small PoC and I had some hard work to create a flexible tool.
Thank you very much