Hi there,
A request came in - "Which are the top 10 used tables and indexes, files and tablespaces please".

Ok, v$filestat gives me file and effectively tablespace as well....

How the hell do I monitor segment usage ? I cant find anywhere that tells me how much io a segment is getting. Any ideas? I have even looked in capacity planner in OEM and cant find anything...