Hi all, Trying to deal with SHARED_POOL sizing and perf tuning for an 8.1.6.0.0 DB that's used by 3rd party software. I can't seem to find if higher values of SESSION_CACHED_CURSORS adversely affects the shared pool in any way. Specifically, I'm wondering if the higher number of cached cursors can keep objects from being flushed from the shared pool.
I believe that higher values of SESSION_CACHED_CURSORS require more mem for the UGAs, but I'm looking for effects on the SGA. My apologies to Steve Adams -- I haven't read that far in his "Internals" book yet! :) TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
