0227windows下模糊查詢oracle事件的指令碼
[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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 精確查詢和模糊查詢Oracle
- 查詢等待事件及處理指令碼事件指令碼
- Mybatis中Oracle的拼接模糊查詢MyBatisOracle
- Oracle特殊符號的模糊查詢Oracle符號
- 【Oracle】 檢查log fie sysnc 等待事件的指令碼Oracle事件指令碼
- elasticsearch的模糊查詢Elasticsearch
- Oracle隱形引數查詢指令碼Oracle指令碼
- 查詢Tuxedo積壓的Oracle診斷指令碼UXOracle指令碼
- mysql 模糊查詢MySql
- 【DBA 指令碼】查詢current open cursor的指令碼指令碼
- 10 行 Python 程式碼寫的模糊查詢Python
- pgsql查詢優化之模糊查詢SQL優化
- Oracle效能問題檢查 - 常用查詢指令碼(final)Oracle指令碼
- MyBatis模糊查詢LIKEMyBatis
- sql日期模糊查詢SQL
- mybatis - [07] 模糊查詢MyBatis
- LINQ中的模糊查詢
- Mysql高效的模糊查詢(轉)MySql
- Java ——MongDB 插入資料、 模糊查詢、in查詢Java
- sql 模糊查詢問題SQL
- mybatis做like模糊查詢MyBatis
- Mybatis各種模糊查詢MyBatis
- 反向索引與模糊查詢索引
- Oracle查詢並批量編譯無效物件指令碼Oracle編譯物件指令碼
- mybatis 對特殊字元的模糊查詢MyBatis字元
- python 當中的模糊查詢Python
- Oracle鎖調查的指令碼Oracle指令碼
- int 被當作模糊查詢
- DB常用指令碼 - 查詢正在執行的active session及對應sql ,等待事件指令碼SessionSQL事件
- 加密的手機號,如何模糊查詢?加密
- SQL使用模糊查詢like的優化SQL優化
- 一些常用查詢指令碼指令碼
- mysql like查詢 - 根據多個條件的模糊匹配查詢MySql
- 使用Excel進行快速模糊查詢的方法Excel
- 實現城市列表的排序及模糊查詢排序
- Mybatis中模糊查詢的各種寫法MyBatis
- Python中使用MySQL模糊查詢的方法PythonMySql
- 報表怎麼做模糊查詢