VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Can not purge obsolete cursor in 11.2.0.3

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:
Posted in Oracle Experience | No Comments »

11g Oradebug Infrastructure (Internal only)

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:
Posted in Oracle Experience | No Comments »