Use to monitor and capture data during a SQL queries session.
The following table shows the available actions.
| Element | Description |
|---|---|
|
Results |
|
|
|
Click to pause the live results display. |
|
|
Click to update the live results display. |
|
|
Click to either show delta values or absolute values. |
| Collected Data | |
|
|
Click to take a snapshot of the session. |
|
|
Click to reset the collected results. |
| Process | |
|
|
Click to create a textual dump of all active threads and monitors of the profiled application. |
|
|
Click to save an image of the current heap content of the profiled process in .hprof format. |
|
|
Click to request the JVM of the profiled process to invoke garbage collection. |
| Click to display and select or hide the profiling options: All queries or Defined queries. | |
| Profile | |
| All Queries | Displays and profiles all queries contained in your application. |
| Defined Queries | Displays and profiles specified queries in your application. |
| SQL Query | Displays a list of queries. You can sort the list by clicking a column heading. |
| Total Time | Displays total of time spent on a SQL query. You can sort the list by clicking a column heading. |
| Invocations | Displays the number of the selected query invocations. You can sort the list by clicking a column heading. |
| Statement Type | Displays the type of an SQL query. The options are: Callable, Prepared, Regular. You can sort the list by clicking a column heading. |
| Command Type | Displays the type of a SQL command (for example, Select or Delete). You can sort the list by clicking a column heading. |
| Table | Displays the name of a database table that a SQL query accesses. You can sort the list by clicking a column heading. |
| Statements | |
| Regular | Select to display queries with regular Statements in the SQL Query table. |
| Prepared | Select to display queries with PreparedStatements in the SQL Query table. |
| Callable | Select to display queries with CallableStatements in the SQL Query table. |
| Commands | Specify the value of a command for a query to be displayed in the SQL Query table. |
| Tables | Specify the value of a table for a query to be displayed in the SQL Query table. |
| Apply | Click to apply the selected Statements options and specified Commands and Tables options. |
| Filter | Specify the value of a filter. |
| Click to apply the specified filter. | |
| Filter type | Opens a submenu that enables you to select a filter for the types of queries to display. You can select any of the following filters: |
| Displays queries that contain the specified filter value. | |
| Displays queries that do not contain the specified filter value. | |
| Displays queries that contain the specified regular expression. | |
| Click to filter for the queries that match the case of the specified filter value. |
Related Topics
Developing Applications with NetBeans IDE,
| Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0. |