Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. 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


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.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating