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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.