session_cached_cursors

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 12 Mar 2009 17:11:30 +0700
Message-ID: <3edcb66e0903120311he89dbbbv5f032d68fc0eacef_at_mail.gmail.com>

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 ?

http://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
--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 12 2009 - 05:11:30 CDT

This message: [ Message body ]
Next message: Asif Momen: "Re: dba_extents vs dba_segments"
Previous message: Remigiusz Sokolowski: "Re: Are the OMS targets optional in Grid Control?"
Next in thread: Ujang Jaenudin: "Re: session_cached_cursors"
Maybe reply: Ujang Jaenudin: "Re: session_cached_cursors"
Maybe reply: Yong Huang: "Re: session_cached_cursors"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message