I created a google graph treemap based on the output of proutil -C dbanalys.
It's in an early stage, I don't wont to spend more time on this if something similar already exists.
I'll put it on codeshare if it seems useful .
Looks interesting that.
Very cool! If such a thing exists already, I haven't seen it. I'd love to have the code if you're willing to share.
Check out www.progresstalk.com/.../how-much-free-information-is-too-much.140432 for ideas and possible cross fertilization.
The code is available at https://github.com/cverbiest/dbanalys-charts
Thanks, interesting link
Looks interesting to say the least. I could definitely see this expanded to show more information about each area/table... especially which objects are in need of a tablemove, RPB change or index rebuilds.
Another possible future enhancement is to read data from the CSV files produced in 11.4+ dbanalys with -csoutput. They're a lot nicer than the report for programmatic parsing.
Sorry, I just looked at GitHub and saw you're already doing that!
Just run it against my DB. Looking good. One comment though - it doesn't take into account LOBs. I know it's bad practise to have LOBs in Data Areas, but at the moment we do, and as a result it's mis-representing the size of our biggest area by around 150GB! :)
Of course LOBs aren't reflected in dbanalys - I forgot that was a shortfall PSC haven't addressed yet.