Query Window - Results
Query Analyzer provides 6 different query result options.
|
|
Text Results -It displays formated text, and the text is cleared for every query.
|
 Text Results
|
|
Text History Results -The Text History is formated text and is appended to the previous text.
|
 Text History Results
|
|
Oracle DBMS_OUTPUT -Oracle allows a user to print out messages from a query, PL/SQL block or stored procedure. ADS will now display this output if it is used by the user.
|
 DBMS Output
|
|
Grid Results -Results are displayed in a grid which can be sorted by clicking on column headings. One grid per statement is displayed.
|
 Grid Results
|
Client Statistics -Displays detailed statistics on the execution of the statement or script.
Total Processing: This is the amount of time it takes from the second you click Execute until
ADS finishes displaying all of the results on the screen. This is the Script Execution time plus
the UI time to process the results and display them.
Client Processing: This is the Total Processing time minus the server wait time.
Server wait time: Server wait time: This is the amount of time ADS spends waiting on the
server during server-side methods calls to execute and retrieve results. For example, the executing
of a SELECT query, ADS might wait 3 seconds for the query to execute on the server (CPU Server Cycles),
then another 5 seconds retrieving results (Network Transfer Cycles). So, this is the best estimate
ADS can make on how much time the server spends executing and sending the data to the client.
Script Parse Time: This is the amount of time it takes to parse the script. This is
usually zero, unless you have a really large file.
Script Execution Time: This is the total time it takes from the beginning to the end of the
execution of the script. This is the raw execution time which doesn't include any time ADS spends
formatting the results to be displayed on the screen.
|
 Client Statistics
|
|
Script Details - The Script Detail Results lists each statement executed in a script with detail indicating
success, failure and/or warnings. Double-clicking on an item highlights the associated lines in the script.
|
 Script Details
|
|
Pivot Grid - The Pivot Grid presents the results as a set of pivot tables. One pivot table is displayed per result set.
|
Pivot Grid Details
|
|
Printing Grid and Text results - Grid or Text results can be printed out using a physical or software printer.
The printing can be configured using options presented in the Print dialog such as: document header and footer, paper
size, margins and document orientation. Printing now provides a popup status dialog that both shows what page is currently
printing and provides the ability to cancel the print job.
|
|
