Skip Headers

Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
Home | Contents | Index

## Use Query Statistics dialog

Use this dialog to specify how you collect query statistics for estimating best summaries. For example, to use query statistics where queries exceed a specified amount of CPU time.

This dialog is also known as:

Summary Wizard: Step 3

For more information, see:

"Creating summary folders manually"

"Managing summary folders"

#### Specify search criteria to obtain statistics on query performance, then click "Search"

Use these criteria to search for statistics to populate the Select a query to be summarized field.

#### Show query statistics from within the last _

Use this field to specify how recent the query statistic must be to qualify for the query list.

#### Average CPU Time exceeds _

Use this field to specify the minimum time required to execute the query on the database server.

#### Average elapsed time exceeds _

Use this field to specify the minimum time required to execute the query on the client workstation.

#### Number of queries exceeds _

Use this field to specify the minimum number of runs executed for the selected query. The runs might have been executed by different users at different times, but all used the same combination of folders and items.

#### Search

Use this button to search for query statistics matching the search criteria specified above and display them in the Select a query to be summarized list.

#### Select a query to be summarized

This list displays query statistics matching the search criteria specified.

Select a query from the list to display the query's folders, joins and items in the lower right panel of the dialog, and activate the Next button.

The #Hits column records the number of times a query has been run by end users.

#### Notes

- Summary folders built using Query statistics are refreshed by Discoverer.

- A check mark or cube icon indicates that the current query has found a matching summary folder from a previous query. The symbol indicates an exact match that includes all objects.

| Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents | Index