Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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.