Oracle教程

Oracle 视图 DBA_WORKLOAD_FILTERS 官方解释，作用，如何使用详细说明

本站中文解释

主用于视图负载过滤器，负载过滤器用于指定某些过滤条件，帮助数据库实现跟踪和测试负载调整，以最大限度的提升性能。该视图的功能主要用于显示数据库中已配置的功能过滤器列表，例如操作系统平台、应用程序、错误代码、登录名称、事务掩码等。使用该表的方法是，在Oracle的每个会话中设定过滤器：

SQL> ALTER SESSION SET FILTER={OS’WIN’};

每个会话都可以设定多个过滤器：

SQL> ALTER SESSION SET FILTER=(OS=’UNIX’,APPLICATION!=’SQL*Server’);

这样当另外一个会话运行某个操作时，Oracle将自动过滤掉不符合“OS”和“应用程序”过滤条件的操作。用户可以使用SELECT语句从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. Starting with Oracle Database 11gR2, filters of type REPLAY are supported.

Column Datatype NULL Description

TYPE

VARCHAR2(30)

Type of the workload filter (CAPTURE or REPLAY)

ID

VARCHAR2(40)

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.

SET_NAME

VARCHAR2(1000)

Name of the filter set to which the filter belongs

NAME

VARCHAR2(128)

Name of the workload filter

ATTRIBUTE

VARCHAR2(128)

Name of the attribute on which the filter is defined

VALUE

VARCHAR2(4000)

Value of the attribute on which the filter is defined. Wildcards such as % and _ are supported if the attribute is of string type.


数据运维技术 » Oracle 视图 DBA_WORKLOAD_FILTERS 官方解释，作用，如何使用详细说明
分享到：

相关推荐