How to identify SQL statements in need of tuning with Spotlight on Oracle

I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on...