If you have a problem with your Oracle database performance you have several options and tools for tuning it. If the problem is caused by a wrong execution plan, then you can use Store Outlines, SQL Profiles or SQL Plan Management (SPM) to give oracle more informations for better optimizer decissions and execution plan stability.