Top100 will support you in profiling your applications for finding the most resource or time consuming SQL statements. This utility for the Oracle database administrator and the oracle developer offers a very simple user Interface and is extraordinary easy to use. The key functionality is: The SQL statements are transferred to the client using highly optimized multithreaded array fetches.

The execution plan for all statements is automatically analyzed and evaluated on the server side. Colored syntax highlighting. The SQL statements can be modified and analyzed using different optimizer goals. The table containing the SQL statements is fully customizable and the data can be sorted by multiple columns.

The statements to retrieve can be filter using several filter criteria including statement type, user, resource consumption or statement text. It is possible to find similar statements. The shared pool can be flushed. The results can be exported to CSV, HTML or XML files.