8.1.6.3 shared pool
Date: Thu, 8 May 2008 09:43:17 -0500
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C5303043AD1@CWYMSX06.Corp.Acxiom.net>
Got an old 8.1.6.3 DB running Siebel and just this week been getting
4031s but don't see anything big in memory.
This is test DB, but copy of production with same initora except for sps which I increased on Monday.
increased sps from 100000000 to
204800000 and got around first problem.User says he's got new data, but not doing anything different. He also said he broke data up into smaller batches.
Now I flush the pool and it's still pretty well used
Ran
-- What is currently in the shared memory?
col name for a40
col Memory for 999,999,999
select type
,name
,sum(sharable_mem) Memory
,kept
from v$db_object_cache
where type NOT IN ('NOT LOADED')
group by type
,name
,kept
order by sum(sharable_mem)
;
But didn't see much using memory.
What am I missing?
TIA,
Larry
09:28:29 LNW>ALTER SYSTEM FLUSH SHARED_POOL;
09:28:37 LNW>@SP
DB Shared Pool Size Free Bytes Percent Free
------- ---------------- ---------------- ------------ SBL6QA 204,800,000 10,658,900 5.20454102 SBL6QA 204,800,000 32,768 .016 DB Shared Pool Size POOL Free Bytes Percent Free ------- ---------------- ----------- ---------------- ------------ SBL6QA 204,800,000 shared pool 10,603,544 5.17751172 09:28:40 LNW>SHOW PARAMETERS pool NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_COL_PLUS_SHOW_PARAM ------------------------------------ ------- ------------------------------ buffer_pool_keep string buffer_pool_recycle string java_pool_size string 32768 large_pool_size string 0 shared_pool_reserved_size string 10240000 shared_pool_size string 204800000 *************************************************************************The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 08 2008 - 09:43:17 CDT