[20170628]完善ooerr腳本.txt

[20170628]完善ooerr腳本.txt

--//註意不是oracle的oerr,是我寫的一個小腳本,下麵會提到.很簡單.^_^.
--//參考鏈接:blog.itpub.net/267265/viewspace-2122258/

--//前幾天我看一個事件號43905.
$ oerr ora 43905
43905, 0000, "result cache tracing event"
// *Document: NO
// *Cause:    This is an internal event.
// *Action:   N/A

$ ooerr 43905
--//沒有輸出,奇怪.

$ ooerr result
10040, 00000, "disable result-cache"
10843, 00000, "Event for client result cache tracing"

--//我有定義別名如下:
alias ooerr='/bin/grep ^10[0-9][0-9][0-9]  $ORACLE_HOME/rdbms/mesg/oraus.msg | grep -i $1'

--//仔細看才發現看來不一定是1開頭的事件.要重新修改腳本.修改如下:
$ alias ooerr='/bin/grep ^[0-9][0-9][0-9][0-9][0-9]  $ORACLE_HOME/rdbms/mesg/oraus.msg | grep -i $1'

$ ooerr 43905
43905, 0000, "result cache tracing event"

$ ooerr 'result cache'
10843, 00000, "Event for client result cache tracing"
12079, 00000, "do not invalidate result cache created during materialized view refresh"
43905, 0000, "result cache tracing event"
43906, 0000, "result cache service (qesrc) validation event"

$ ooerr 00001
00001, 00000, "unique constraint (%s.%s) violated"
30562, 00000, "SAMPLE percentage must be in the range [0.000001,100)"

--//btw:12c for windows 也提供oerr.bat程式,但是沒有oraus.msg 文件.至少我安裝的機器windows下沒有.從linux下拷貝過去也可以使用.
--//參考鏈接 blog.itpub.net/267265/viewspace-1869588/

--//這樣查詢就比較全面了.不過主要跟蹤事件相關的事件號應該還是10XXX開頭那些.