We have all our reporting (including jobs and statistics and analysis data recalculation) being done in one userspace. This is a standard Oracle user.
We're now considering moving this reporting to it's own database, but I need to know exactly how much resources this user is consuming.
In terms of HDD space, CPU usage, memory usage, and other stats.
Ideally I was looking for some analysis software I could just run to determine this, but even after Googling for a while I haven't found any.
So a) Can this be done and b) If yes, how is this done?