I've had a look at v$waitstat and nearly all of the waits are on data blocks. v$latch shows the most sleeps on shared pool / library cache / cache buffer chains.

How can I find out what the hot tables/indexes are (I'm getting a crash course in tuning today!!)?