To enable a memory-protect cursor:
event = "10049 trace name context forever, level 2"

/******10049必须要重启库方可***********/
SQL> alter system set event = '10049 trace name context forever, level 2' scope=spfile;

System altered

SQL> alter system set event = '10049 trace name context forever off' scope=spfile;

System altered

/***白大师用10049分析library cache lock/pin 及session_cached_cursor*****/
http://www.oraclefans.cn/forum/showblog.jsp?rootid=5649&op=allcomm#43118

ITPub博客

event 10049与library cache lock_pin