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 |
---|---|---|---|
|
|
|
Unique SQL identifier generated from normalized SQL text |
|
|
|
Unique plan identifier in string form as a search key |
|
|
|
Un-normalized SQL text |
|
|
|
Unique plan identifier in numeric form as a search key |
|
|
|
CPU time threshold (in seconds) |
|
|
|
I/O threshold (in megabytes) |
|
|
|
Physical I/O threshold (number of physical I/O requests) |
|
|
|
Elapsed time threshold (in seconds) |
|
|
|
Logical I/O threshold (number of logical I/O requests) |
|
|
|
User who created the quarantine configuration |
|
|
|
Method by which the quarantine configuration was created. The only possible value is |
|
|
|
Text description |
|
|
|
Time at which the quarantine configuration was created |
|
|
|
Time at which the quarantine configuration was last used |
|
|
|
Indicates whether the quarantine configuration is enabled ( |
|
|
|
Indicates whether the quarantine configuration is auto-purged ( |
See Also:
Oracle Database SQL Tuning
Guide for more information about quarantined SQL plans