lists, reading materials from both url, need clarification or does anyone has a way how to prove it? is there event or oradebug for this case? I'm confusing on which part of memory affected by session_cached_cursors....SGA or PGA ? //www.freelists.org/post/oracle-l/SESSION-CACHED-CURSORS,6 http://www.dba-oracle.com/t_session_cached_cursors_optimal_size.htm -- thanks and regards ujang | oracle dba | mysql dba http://ora62.wordpress.com -- //www.freelists.org/webpage/oracle-l