Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
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:
|
|
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. |