Top100 - The Oracle Shared Pool Profiler
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
- 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
- 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
- It is possible to find similar statements.
- The shared pool can be flushed.
- The results can be exported to CSV, HTML or XML files.