Oracle DB 12.2(12cR2)的一个新特性:硬解析失败的SQL语句(需要符合一定条件)打印到alert_sid.log中.

转载于 2016-11-23 17:19:01 发布 · 1.5k 阅读

文章标签：

#12c #12.2 #hard parse #硬解析 #alert

Oracle DB 12c 同时被 2 个专栏收录

62 篇文章

订阅专栏

Oracle DB 12c新特性

39 篇文章

订阅专栏

本文介绍了一种诊断增强功能，该功能可在Oracle警报日志中提前警告频繁发生的解析失败，并自动收集有关这些失败的信息。通过隐藏参数_kks_parse_error_warning可以调整标记重复解析错误的采样间隔，默认情况下，每100次针对同一SQL语句的解析失败会在60分钟内记录一次警告。

转自:

How to Identify Hard Parse Failures (Doc ID 1353015.1)
Bug 16945190 - Diagnostic enhancement to dump parse failure information automatically (Doc ID 16945190.8)

This is a diagnostic enhancement that will give an early warning
in the alert log if there are excessive parse failures occuring, and will 
collection information about the failures.
 
The sampling interval for flagging recurring parse errors can be fine tuned with the 
hidden parameter "_kks_parse_error_warning".
By default the diagnostic will dump the parse error along with warning in alert log 
every 100 parse errors for a given SQL within a 60 minutes period.
 
If there is already a known parse issue then one can use existing event 10035
to dump similar information.