If all else fails start up Oracle Enterprise Manager and use Oracle Expert to give you some advice about tuning. It will pick up commonly used statements and suggest indexes that may help you out.

Remember, automated tuning products are only as good as the people who wrote them and the data sample you give them to work on.

Good luck.