| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" |
| "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| |
| --> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> |
| <head> |
| <title>Profile Window with SQL Queries</title> |
| <link rel="stylesheet" href="ide.css" title="Oracle BLAFDoc" type="text/css"/> |
| </head> |
| |
| <body> |
| <p><a id="ProfileSQL.HelpCtx" name="ProfileSQL.HelpCtx"></a></p> |
| <!-- infolevel="all" infotype="General" --><a id="sthref449" name="sthref449"></a> |
| <h1>Profile Window with SQL Queries</h1> |
| <a name="BEGIN" id="BEGIN"></a> |
| <p>Use to monitor and capture data during a SQL queries session.</p> |
| <p>The following table shows the available actions.</p> |
| |
| <table summary="User interface elements and descriptions" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> |
| <col width="31%" /> |
| <col width="*" /> |
| <thead> |
| <tr align="left" valign="top"> |
| <th align="left" valign="bottom" id="r1c1-t42">Element</th> |
| <th align="left" valign="bottom" id="r1c2-t42">Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr align="left" valign="top"> |
| <td align="left" id="r2c1-t42" headers="r1c1-t42"> |
| <p>Results</p> |
| </td> |
| <td align="left" headers="r2c1-t42 r1c2-t42"></td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r3c1-t42" headers="r1c1-t42"> |
| <p><img width="19" height="19" src="img/pause_live_results.png" alt="Pause live results icon" title="Pause live results icon" />Pause live results</p> |
| </td> |
| <td align="left" headers="r3c1-t42 r1c2-t42">Click to pause the live results display.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r4c1-t42" headers="r1c1-t42"> |
| <p><img width="21" height="20" src="img/update_live_results.png" alt="Update live results icon" title="Update live results icon" />Update live results</p> |
| </td> |
| <td align="left" headers="r4c1-t42 r1c2-t42">Click to update the live results display.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r5c1-t42" headers="r1c1-t42"> |
| <p><img width="18" height="17" src="img/show_delta_values.png" alt="Show delta values icon" title="Show delta values icon" />Show delta values</p> |
| </td> |
| <td align="left" headers="r5c1-t42 r1c2-t42">Click to either show delta values or absolute values.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r6c1-t42" headers="r1c1-t42">Collected Data</td> |
| <td align="left" headers="r6c1-t42 r1c2-t42"></td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r7c1-t42" headers="r1c1-t42"> |
| <p><img width="20" height="20" src="img/take_snapshot.png" alt="Take snapshot icon" title="Take snapshot icon" />Snapshot</p> |
| </td> |
| <td align="left" headers="r7c1-t42 r1c2-t42">Click to take a snapshot of the session.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r8c1-t42" headers="r1c1-t42"> |
| <p><img width="16" height="16" src="img/reset_results.png" alt="Reset collected results icon" title="Reset collected results icon" />Reset Collected Results</p> |
| </td> |
| <td align="left" headers="r8c1-t42 r1c2-t42">Click to reset the collected results.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r9c1-t42" headers="r1c1-t42">Process</td> |
| <td align="left" headers="r9c1-t42 r1c2-t42"></td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r10c1-t42" headers="r1c1-t42"> |
| <p><img width="18" height="18" src="img/take_thread_dump.png" alt="Thread dump icon" title="Thread dump icon" />Thread Dump</p> |
| </td> |
| <td align="left" headers="r10c1-t42 r1c2-t42">Click to create a textual dump of all active threads and monitors of the profiled application.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r11c1-t42" headers="r1c1-t42"> |
| <p><img width="17" height="17" src="img/take_heap_dump.png" alt="Heap dump icon" title="Heap dump icon" />Heap Dump</p> |
| </td> |
| <td align="left" headers="r11c1-t42 r1c2-t42">Click to save an image of the current heap content of the profiled process in .hprof format.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r12c1-t42" headers="r1c1-t42"> |
| <p><img width="18" height="20" src="img/gc.png" alt="Garbage collection icon" title="Garbage collection icon" />GC</p> |
| </td> |
| <td align="left" headers="r12c1-t42 r1c2-t42">Click to request the JVM of the profiled process to invoke garbage collection.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r13c1-t42" headers="r1c1-t42"><img width="17" height="17" src="img/settings.png" alt="Settings button" title="Settings button" />Settings</td> |
| <td align="left" headers="r13c1-t42 r1c2-t42">Click to display and select or hide the profiling options: All queries or Defined queries.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r14c1-t42" headers="r1c1-t42">Profile</td> |
| <td align="left" headers="r14c1-t42 r1c2-t42"></td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r15c1-t42" headers="r1c1-t42">All Queries</td> |
| <td align="left" headers="r15c1-t42 r1c2-t42">Displays and profiles all queries contained in your application.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r16c1-t42" headers="r1c1-t42">Defined Queries</td> |
| <td align="left" headers="r16c1-t42 r1c2-t42">Displays and profiles specified queries in your application.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r17c1-t42" headers="r1c1-t42">SQL Query</td> |
| <td align="left" headers="r17c1-t42 r1c2-t42">Displays a list of queries. You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r18c1-t42" headers="r1c1-t42">Total Time</td> |
| <td align="left" headers="r18c1-t42 r1c2-t42">Displays total of time spent on a SQL query. You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r19c1-t42" headers="r1c1-t42">Invocations</td> |
| <td align="left" headers="r19c1-t42 r1c2-t42">Displays the number of the selected query invocations. You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r20c1-t42" headers="r1c1-t42">Statement Type</td> |
| <td align="left" headers="r20c1-t42 r1c2-t42">Displays the type of an SQL query. The options are: Callable, Prepared, Regular. You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r21c1-t42" headers="r1c1-t42">Command Type</td> |
| <td align="left" headers="r21c1-t42 r1c2-t42">Displays the type of a SQL command (for example, Select or Delete). You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r22c1-t42" headers="r1c1-t42">Table</td> |
| <td align="left" headers="r22c1-t42 r1c2-t42">Displays the name of a database table that a SQL query accesses. You can sort the list by clicking a column heading.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r23c1-t42" headers="r1c1-t42">Statements</td> |
| <td align="left" headers="r23c1-t42 r1c2-t42"></td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r24c1-t42" headers="r1c1-t42">Regular</td> |
| <td align="left" headers="r24c1-t42 r1c2-t42">Select to display queries with regular Statements in the SQL Query table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r25c1-t42" headers="r1c1-t42">Prepared</td> |
| <td align="left" headers="r25c1-t42 r1c2-t42">Select to display queries with PreparedStatements in the SQL Query table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r26c1-t42" headers="r1c1-t42">Callable</td> |
| <td align="left" headers="r26c1-t42 r1c2-t42">Select to display queries with CallableStatements in the SQL Query table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r27c1-t42" headers="r1c1-t42">Commands</td> |
| <td align="left" headers="r27c1-t42 r1c2-t42">Specify the value of a command for a query to be displayed in the SQL Query table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r28c1-t42" headers="r1c1-t42">Tables</td> |
| <td align="left" headers="r28c1-t42 r1c2-t42">Specify the value of a table for a query to be displayed in the SQL Query table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r29c1-t42" headers="r1c1-t42">Apply</td> |
| <td align="left" headers="r29c1-t42 r1c2-t42">Click to apply the selected Statements options and specified Commands and Tables options.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r30c1-t42" headers="r1c1-t42">Filter</td> |
| <td align="left" headers="r30c1-t42 r1c2-t42">Specify the value of a filter.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r31c1-t42" headers="r1c1-t42"><img width="21" height="19" src="img/filter_sql.png" alt="Filter results" title="Filter results" />Filter results</td> |
| <td align="left" headers="r31c1-t42 r1c2-t42">Click to apply the specified filter.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r32c1-t42" headers="r1c1-t42">Filter type</td> |
| <td align="left" headers="r32c1-t42 r1c2-t42">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:</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r33c1-t42" headers="r1c1-t42"><img width="21" height="19" src="img/contains.png" alt="Contains" title="Contains" />Contains</td> |
| <td align="left" headers="r33c1-t42 r1c2-t42">Displays queries that contain the specified filter value.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r34c1-t42" headers="r1c1-t42"><img width="20" height="19" src="img/does_not_contain.png" alt="Does not contain" title="Does not contain" />Does Not Contain</td> |
| <td align="left" headers="r34c1-t42 r1c2-t42">Displays queries that do not contain the specified filter value.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r35c1-t42" headers="r1c1-t42"><img width="20" height="20" src="img/reg_expression.png" alt="Regular expession" title="Regular expession" />Regular Expression</td> |
| <td align="left" headers="r35c1-t42 r1c2-t42">Displays queries that contain the specified regular expression.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r36c1-t42" headers="r1c1-t42"><img width="19" height="18" src="img/match_case.png" alt="Match case" title="Match case" />Match case</td> |
| <td align="left" headers="r36c1-t42 r1c2-t42">Click to filter for the queries that match the case of the specified filter value.</td> |
| </tr> |
| </tbody> |
| </table> |
| <br /> |
| <!-- --> |
| <a id="sthref450" name="sthref450"></a> |
| <hr><p><b>Related Topics</b></p> |
| <p><i>Developing Applications with NetBeans IDE</i>, |
| <object classid="java:org.netbeans.modules.javahelp.BrowserDisplayer"> |
| <param name="content" value="http://www.oracle.com/pls/topic/lookup?ctx=nb8200&id=NBDAG659"> |
| <param name="text" value="<html><u>"Testing and Profiling Java Application Projects"</u></html>"> |
| <param name="textFontSize" value="medium"> |
| <param name="textColor" value="blue"> |
| </object> |
| </p> |
| |
| <!-- --> |
| <!-- Start Footer --> |
| |
| |
| <table summary="" cellspacing="0" cellpadding="0" width="100%"> |
| <tr> |
| <td align="left" width="86%"><a href="legal_notice.htm"> |
| Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0.</a> |
| </td> |
| </tr> |
| </table> |
| <!-- --> |
| </body> |
| </html> |