ADD_FILTER_ITEM Procedure

This procedure adds a new filter item to an existing filter to make it more restrictive. It also creates a filter to restrict what is analyzed for the workload.

Syntax

ADD_FILTER_ITEM (
   filter_id    IN NUMBER,
   filter_name  IN VARCHAR2,
   string_list  IN VARCHAR2,
   number_min   IN NUMBER,
   number_max   IN NUMBER,
   date_min     IN VARCHAR2,
   date_max     IN VARCHAR2);

Table 34-3 ADD_FILTER_ITEM Procedure Parameters

Parameter	Datatype	Description
filter_id	NUMBER	An ID that uniquely describes the filter. It is generated by the DBMS_OLAP.CREATE_ID procedure
filter_name	VARCHAR2	APPLICATION String-workload's application column. An example of how to load a SQL Cache workload is shown below. BASETABLE String-base tables referenced by workload queries. Name must be fully qualified including owner and table name i.e. SH.SALES CARDINALITY Numerical-sum of cardinality of the referenced base tables FREQUENCY Numerical-workload's frequency column LASTUSE Date-workload's lastuse column. Not used by SQL Cache workload. OWNER String-workload's owner column. Expected in uppercase unless owner defined explicitly to be not all in uppercase. PRIORITY Numerical-workload's priority column. Not used by SQL Cache workload. RESPONSETIME Numerical-workload's responsetime column. Not used by SQL Cache workload. TRACENAME String-list of oracle trace collection names. Only used by a Trace Workload
string_list	VARCHAR2	A comma-separated list of strings. This parameter is only used by the filter items of the string type
number_min	NUMBER	The lower bound of a numerical range. NULL represents the lowest possible value. This parameter is only used by the parameters of the numerical type
number_max	NUMBER	The upper bound of a numerical range, NULL for no upper bound. NULL represents the highest possible value. This parameter is only used by the parameters of the numerical type
date_min	VARCHAR2	The lower bound of a date range. NULL represents the lowest possible date value. This parameter is only used by the parameters of the date type
date_max	VARCHAR2	The upper bound of a date range. NULL represents the highest possible date value. This parameter is only used by the parameters of the date type