DBA_WORKLOAD_FILTERS

DBA_WORKLOAD_FILTERS displays all the workload filters that have been defined in the current database. In Oracle Database 11g, only workload filters of type CAPTURE are supported.

Column	Datatype	NULL	Description
`TYPE`	`VARCHAR2(30)`	`NOT NULL`	Type of the workload filter
`ID`	`NUMBER`	`NOT NULL`	Sequence number of the workload filter
`STATUS`	`VARCHAR2(6)`		Status of the workload filter: `NEW` - This filter will be used by the next subsequent operation such as the next workload capture. `IN USE` - This filter is currently being used by an operation that is in progress such as an active workload capture. `USED` - This filter was used in the past by some operation such as a past workload capture.
`NAME`	`VARCHAR2(100)`	`NOT NULL`	Name of the workload filter
`ATTRIBUTE`	`VARCHAR2(100)`	`NOT NULL`	Name of the attribute on which the filter is defined
`VALUE`	`VARCHAR2(4000)`	`NOT NULL`	Value of the attribute on which the filter is defined. Wildcards such as `%` and `_` are supported if the attribute is of string type.