I checked v$db_object_cache on several of our instances and found that none of our objects in the shared pool take up much space.
Does anyone have any objects need to to go to the reserved pool? Like what? All the shared pool is storing are execution plans, etc... how could that take up enough space to warrant its moving to a reserve pool? Per the book Im reading, you want to move objects that have a large value in 'sharable_mem' in v$object_cache? What type of object would have a value large enough to warrant a move? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
