To get the text and details of the queries displayed on the
Query Analyzer page, click one of the icons
to the right of the Browse Queries label in
the separator bar. The query information is exported as
comma-separated data in a .csv file, with
fields corresponding to the columns shown in the Dashboard, and
the time of the export encoded in the filename in UTC format. The
icon representing a single page exports the query information for
the currently displayed page only. The icon representing a stack
of pages exports the query information for all available pages of
query information.
Within the Query Analyzer popup, you can also
export information about each data group as a
.csv text file or a .png
image file, using icons next to the labels on the left side. The
output file is named according to the pattern
Statement_Report_Summary_%server/group%_%creationtimestamp%.csv
or .png. The data exported by these icons
includes:
Execution Time: Count
Executions: Exec Time, Max Exec Time, Min Exec Time, Average
Exec Time
Rows: Rows, Max Rows, Min Rows, Average Rows
Kilobytes: Bytes, Max Bytes, Average Bytes
Note
Microsoft Excel users on Windows users can import the
.csv file as a spreadsheet. If the file
contains English text, typically you can double-click it to open
in Excel. If the file contains localized Japanese text, you must
use the File > Open menu choice within
Excel to open the file.
In the Safari browser, exported files containing localized data
might contain %NN
character sequences in their names, due to browser issues with
UTF-8 and Base64 encodings.
© 2013, Oracle Corporation and/or its affiliates
