-none- 2004-07-14 - By -not available-
Subject: RE: 4031 - errors
Kathy, hi how are you?
Got in here a couple days late but we had a sever problem with 4031s
and after looking on metalink I used this script to see how busy the
shared_pool_reserve was.
SPOOL $DBS/Sharedpoolreserved.$ORACLE_SID
COL name FOR A05
COL REQUEST_FAILURES FOR 999,999 HEA "REQUEST|FAILURES "
COL LAST_FAILURE_SIZE FOR 999,999,999 HEA "LAST |FAILURE |SIZE "
select name
,free_space
,avg_free_size
,used_space
,avg_used_size
,request_failures
,last_failure_size
,TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24 MI SS ') DATE_AN_TIME
from db
,v$shared_pool_reserved
;
SPOOL OFF
name is just the our INTERNAL DB name like CHICago, JACKsonville,
DALLas etc. to tell one PROD from another.
We had a lot of free space and minimized the SPR to give more memory
to SP. We didn 't have any more problems
Larry
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of
Paula_Stankus@(protected)
Sent: Wednesday, July 14, 2004 9:28 AM
To: oracle-l@(protected)
Subject: RE: ORA-04031 (See ORA-04031.ora-code.com)
Platform:
Oracle 9.2.0.5
Solaris 2.9
ArcSDE 8.3
I am running a DSS - geodatabase with 30 concurrent users. I am getting =
ORA-04031 (See ORA-04031.ora-code.com) errors.
I have verified that last_failure_size > shared_pool_reserved_min_alloc. =
According to Note: 146599.1 it states that I should increase the =
hidden parameter "_shared_pool_reserved_min_alloc " to lower the number =
of objects being cached. =20
It is currently set at 4400 - how much lower would I need to go????
It also states I should consider increasing the =
shared_pool_reserved_size and shared_pool_size but these parameters seem =
adequate to me:
40M for shared_pool_size
4M for shared_pool_reserved_size
I have gone through NOTE: 1012046.6 "Calculating Shared Pool size " and =
based on that my shared_pool_size is more than adequate.
How can I more specifically size the shared pool, shared reserved pool =
as I know that if I size too large then I can start incurring overhead.
**********************************************************************
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 re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
