User Defined Collection (UDC) Wizard - Filters

Performance Analysis for Oracle

User Defined Collection (UDC) Wizard - Filters

Filtering each selected dimension will cause the collection to record only that activity which matches at least one of the selected values per each dimension (thereby further minimizing the size of the collected data). In this step you define which instance activity subset you want the collection to record. The filter feature works as follows:

Within each dimension for which filtered values are chosen, the activity's corresponding dimension value must be contained within the list. This condition must be met by each and every dimension for which a filter list value has been defined (Otherwise the activity is filtered out).   

For example:

  • When DB Users John_Doe and Rebecca_Smith run the Programs monthly payroll (monroll.exe) and invoice accrual (invaccr.exe), they occasionally encounter performance problems. You could create a UDC for these two users and two programs by including only DB User dimension values John_Doe and Rebecca_Smith and program dimension values monroll.exe and invaccr.exe.

The activity Search entry box specification serves a multiple role. Search entries can be used for either:

  • a dimension set initial limiting string. For example, specification of "DROP" as a Command Types filter will display only and all those commands beginning with "DROP" (for example, DROP TABLE, DROP INDEX, etc..) for your individual (>) or group (>>) item selection.

  • values not available through the displayed drop-down listing. Enter the value in the Search box and click ">" to add it to the included filter set.

Note: If no filters are specified, the UDC view will be that of the entire instance.

 

Related Topic