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

本站中文解释

该视图返回受应用中SQL引擎保护的所有SQL语句。

Oracle视图是以物理表形式存储的虚拟表,不实际占用磁盘空间,其形式在数据库中以常规SQL语句的形式定义,可以把表,联合,关系或它们的组合看成视图。Oracle视图是一种把查询的结果以表的形式显示的一种方式,它可以掩盖实际表的数据,只返回所需的结果,用途是可以增强数据的安全性、可控性,并可用来实现数据库中模块之间的耦合解耦,以及简化应用程序之间的数据传输过程。使用Oracle视图的方法是,使用CREATE VIEW语句定义一些视图,然后再在其他操作中使用它们即可。

官方英文解释

DBA_SQL_QUARANTINE displays information about SQL Quarantine configurations.

Each row in this view represents a quarantine configuration for a SQL plan.

Column Datatype NULL Description

SIGNATURE

NUMBER

NOT NULL

Unique SQL identifier generated from normalized SQL text

NAME

VARCHAR2(128)

NOT NULL

Unique plan identifier in string form as a search key

SQL_TEXT

CLOB

NOT NULL

Un-normalized SQL text

PLAN_HASH_VALUE

NUMBER

Unique plan identifier in numeric form as a search key

CPU_TIME

VARCHAR2(4000)

CPU time threshold (in seconds)

IO_MEGABYTES

VARCHAR2(4000)

I/O threshold (in megabytes)

IO_REQUESTS

VARCHAR2(4000)

Physical I/O threshold (number of physical I/O requests)

ELAPSED_TIME

VARCHAR2(4000)

Elapsed time threshold (in seconds)

IO_LOGICAL

VARCHAR2(4000)

Logical I/O threshold (number of logical I/O requests)

CREATOR

VARCHAR2(128)

User who created the quarantine configuration

ORIGIN

VARCHAR2(16)

Method by which the quarantine configuration was created. The only possible value is RESOURCE-MANAGER, which indicates that the quarantine configuration was created by the Resource Manager.

DESCRIPTION

VARCHAR2(500)

Text description

CREATED

TIMESTAMP(6)

NOT NULL

Time at which the quarantine configuration was created

LAST_EXECUTED

TIMESTAMP(6)

Time at which the quarantine configuration was last used

ENABLED

VARCHAR2(3)

Indicates whether the quarantine configuration is enabled (YES) or disabled (NO)

AUTOPURGE

VARCHAR2(3)

Indicates whether the quarantine configuration is auto-purged (YES) or not (NO)

See Also:

Oracle Database SQL Tuning
Guide
for more information about quarantined SQL plans


数据运维技术 » Oracle 视图 DBA_SQL_QUARANTINE 官方解释,作用,如何使用详细说明