Database Procedures Window
The Database Procedures window is available for Oracle Server.
The Database Procedures window shows you the names of the Top N procedures on the database instance based on time. To see the Top N Queries that are executed in a procedure, click a procedure name and then click View Top Queries. From the Procedures top queries page, to see more details about a query you can double-click a query to open the Query Details window.