The Database Modules window is available only for Oracle database servers. The Module field is often identical to the Program field unless it has been programmatically set with a call to DBMS_APPLICATION_INFO. Some packaged applications, such as Oracle E-Business Suite, automatically set the Module field with relevant identifiers.
The Database Modules window shows you the names of the Top N busiest modules on the Oracle database server. To see the Top N Queries run on the database by a module, click a module name and then click View Top Queries. From the Modules top queries page, to see more details about a query you can double-click a query to open the Query Details window.
Access the Database Modules Window
To access the Database Modules window:
- To view a database's modules, click the name of the database.
- Click the Modules tab.
Database Modules Window Features
From the Database Modules window, you can:
- Choose to view information for the top 10, 50, 100 or 200 modules most frequently accessing the database server.
- Double click the name of a module to view the top queries for one module in particular, or select the module and click View Top Queries.
Click the down arrow next to the database collector name at the top of the page to choose to view the modules of a different Oracle database collector by either selecting the database collector from the list or by searching for the database collector by entering text in the search bar and then clicking the refresh icon to show only database collectors that meet that search criteria.
- Click Actions to export the data on this window in a .csv formatted file that is automatically downloaded to your specified downloads directory.
From the Database Modules window, you can view:
- Module: The name of the module run by the active sessions in the database.
- Weight (%): The percentage of time the module was consuming the database resources in comparison with the usage percentage of other modules.