Also, you could look at cache advice ...
I think it's only available in 9i. And the DB is stuck on 8i for a few more months.

Interestingly, v$db_cache_advice is available in 8i, but you can't turn cache advice on, so the important columns are empty!

Jodie