I think Statspack is the way to go, it will show you your most offending queries. Then you can use TkProf or TOra to examine the execution plan for them.
But, no, I'm not aware of any tools that will automatically tell you -- "hey, you're missing an index here!"
