Result Cache Selection Criteria Dialog
Use this dialog to choose what to display in the Result Cache Information tables: Contents Page and Objects Page.
To open the Result Cache Selection Criteria Dialog
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Result Cache | Contents | Set SQL Cache Criteria.
or Click SQL & Application Workload | Result Cache | Objects | Set SQL Cache Criteria.
Data on the Selection Criteria Dialog
| Field | Description |
|---|---|
|
Contains |
Leave this field blank to display items for ALL SQL statements whose result sets are in the Result Cache. Type a string (a word, number or phrase) to filter the results to include only items whose SQL statement contains that string. |
|
Sort By |
From the list, choose the column in the Contents or Objects table by which to sort the contents in the table. Select whether to display the results in ascending or descending order. (Descending order is selected by default: the most significant data is likely to have the largest values.) |
|
Maximum Rows |
Enter the maximum number of rows to display in the tables. |
Close the Selection Criteria Dialog
On clicking OK the data is refreshed in the Result Cache Information tables.