oradebug

Can not purge obsolete cursor in 11.2.0.3

November 28, 2012 11g, maintain, oracle No comments

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

11g Oradebug Infrastructure (Internal only)

January 2, 2012 11g, Internals, oracle No comments

11g Oracle 加强了oradebug 可以使用oradebug doc命令查看internal trace command,下面简述各种命令的输出，由于是undocumented,所以很多东西有待研究

Contents
ORADEBUG DOC
ORADEBUG DOC E[……]

Read more