anyone use shared_pool_reserved?

From: <ryan_oracle_at_cox.net>
Date: Mon, 10 Nov 2003 05:39:26 -0800
Message-ID: <F001.005D6385.20031110053926@fatcity.com>

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: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

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: ListGuru_at_fatcity.com (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). Received on Mon Nov 10 2003 - 07:39:26 CST