Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Shared Pool Tuneup
Hi List,
I have run some scripts for Tune up shared pool,here is the result of one
script which i run :
Script:
SELECT name,sharable_mem
FROM v$db_object_cache
WHERE sharable_mem > 10000
AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR
TYPE = 'FUNCTION' OR
TYPE = 'PROCEDURE')
AND KEPT = 'NO'
ORDER BY 2 DESC
here is the result:
NAME SHARABLE_MEM ----------------------------- -------------------------- DBMS_JAVA 56373 DBMS_STANDARD 24405 DBMS_UTILITY 24212 DBMS_SPACE_ADMIN 20832 DBMS_UTILITY 20508 DBMS_JAVA 15189 DBMS_OUTPUT 13063 DBMS_APPLICATION_INFO 12461 DBMS_SHARED_POOL 11148 DBMS_SHARED_POOL 10648
Question is, do i have to pin all of these objects in my shared_pool or NOT? Thanks
Hamid Alavi
Office 818 737-0526
Cell 818 402-1987
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: hamid.alavi_at_quovadx.com
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: 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 Tue May 21 2002 - 14:47:12 CDT
![]() |
![]() |