0227windows下模糊查詢oracle事件的指令碼

lfree發表於2017-02-27

[20170227]windows下模糊查詢oracle事件的指令碼.txt

$ cat ooerr.bat
@@echo off
rem disp oracle error
rem /bin/grep ^10[0-9][0-9][0-9] $ORACLE_HOME/rdbms/mesg/oraus.msg | grep -i %1%
rem
grep ^10[0-9][0-9][0-9] D:\app\oracle\product\12.1.0\dbhome_1\RDBMS\mesg\oraus.msg | grep -i %1%
                       
--//指向正確的路徑,能找到oraus.msg就ok了.grep許多地方能扎到.例子

D:\tools\rlwrap>ooerr undo
ooerr undo
/    aho        10/23/92 - add event to test truncate index undo (10603)
/    wbridge    01/13/92 - add event 10300 to avoid undo compatibility check
10015, 00000, "Undo Segment Recovery"
10016, 00000, "Undo Segment extend"
10017, 00000, "Undo Segment Wrap"
10023, 00000, "Create Save Undo Segment"
10024, 00000, "Write to Save Undo"
10026, 00000, "Apply Save Undo"
10041, 00000, "dump undo records skipped"
10044, 00000, "free list undo operations"
10048, 00000, "Undo segment shrink"
10201, 00000, "consistent read undo application"
10218, 00000, "dump uba of applied undo"
10221, 00000, "show changes done with undo"
10226, 00000, "trace CR applications of undo for data operations"
10251, 00000, "check consistency of transaction table and undo block"
10291, 00000, "die in tbsdrv to test control file undo"
10449, 00000, "enable trace of kst for undo manageability features diagnostics"
10511, 00000, "turn off SMON check to cleanup undo dictionary"

D:\tools\rlwrap>ooerr 10046
10046, 00000, "enable SQL statement timing"

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2134319/,如需轉載,請註明出處,否則將追究法律責任。

相關文章