I'm troubleshooting a 9i (on AIX) database that's performing badly.
In the process I've spotted a few tables that I do not recognise that are rather large and fragmented and I'm curious to know how frequently these are being used.
Is there a way I can pull figures for how often certain objects are accessed? And the associated load these put on the DB?
Thanks in advance, finding the site very useful!