After you find out which SQL statements are underperforming, you can view their access plans in Visual Explain. You can also tune them with Optim™ Query Tuner or Optim Performance Manager.
You can also compare current data with past data to determine whether changes that you made to SQL statements improved their performance.