Posted by admin on 28th November 2012
11.2.0.3中Oracle引入了_cursor_obsolete_threshold隐藏参数，默认为100，表示一个parent cursor最多可以有100个child cursor;如果SQL需要第101个child cursor,则将该parent cursor and its 100 c[......]
Read more
Tags: oradebug
Posted in Oracle Experience | No Comments »
Posted by admin on 2nd January 2012
11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出，由于是undocumented,所以很多东西有待研究
Contents
ORADEBUG DOC
ORADEBUG DOC EVENT
ORADEBUG DOC EVENT NAME
ORADEBUG DOC EVENT NAME <event_name>
ORADEBUG DOC EVENT SCOPE
ORADEBUG DOC EVENT SCOPE SQL
ORADEBUG DOC EVENT FILTER
ORADEBUG DOC EVENT ACTION
ORADEBUG DOC COMPONENT
Refer to the SQL*P[......]
Read more
Tags: oradebug
Posted in Oracle Experience | No Comments »
