RE: Manual mem management in 10g
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jun 2006 12:07:50 -0400
Michael, I could easily be wrong but I think you are getting 04030
errors because you have allocated too much of your total available
memory to the SGA and do not have enough left to be allocated to the
PGA's of your user sessions. Have your tried reducing your SGA_TARGET
to say 800M or 1G and seeing if this eliminates the 04030 errors while
still allowing the database to perform well enough?
Why can't you use the -3G or better yet /PAE switch to make more than 2G
available?
-- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Ray
Sent: Friday, June 30, 2006 11:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Manual mem management in 10g
Powell, Mark D wrote:
> Michael, Being that a 4030 is process memory not a shared pool error
> like the 04031 error what are the automated memory management values
> for your system? How much total memory does it have? How many
> concurrent sessions are there normally? Are there other Oracle
> databases running on the same server? What is the edition and exact
version number?
Win2003 STANDARD Edition w/ 4GB RAM but we can't use use /3GB switch so
Oracle can only have 2GB. This is EE Oracle and only 1 instance on the
box, which has a primary standby on another box.
There are 73 records in v$session, which should be typical, and 131
threads, which sounds right for that many sessions.
Here are the non-standard parameters (sga_target is near the top and
pga_aggrgegate_target is at the end).
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 142606336
__large_pool_size = 8388608
__java_pool_size = 8388608
__streams_pool_size = 0
sga_target = 1258291200
control_files =
C:\ORACLE\PRODUCT\10.2.0\ORADATA\CSSPROD\CONTROL01.CTL,
E:\ORACLE\ORADATA\CSSPROD\CONTROL02.CTL,
C:\ORACLE\PRODUCT\10.2.0\ORADATA\CSSPROD\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 1090519040
compatible = 10.2.0.1.0
log_archive_config = DG_CONFIG=(cssprodblade,cssprodcruncher)
log_archive_dest_1 = location="e:\oracle\archive\",
valid_for=(ONLINE_LOGFILE,ALL_ROLES)
log_archive_dest_2 =
service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=CRUNCHE
R)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XXX)(INSTANCE_NAME=cssprod)(S
ERVER=dedicated)))",
LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1
reopen=300 db_unique_name="cssprodcruncher" register net_timeout=180
valid_for=(online_logfile,primary_role)
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
standby_archive_dest =
log_archive_trace = 0
log_archive_format = LOG%T_%R_%S.ARC
fal_client = cssprodblade
fal_server = cssprodcruncher
archive_lag_target = 0
db_file_multiblock_read_count= 16
db_recovery_file_dest =
c:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
standby_file_management = AUTO
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 16777216
remote_login_passwordfile= EXCLUSIVE
db_domain = XXX
service_names = XXX
dispatchers = (PROTOCOL=TCP) (SERVICE=cssprodXDB)
job_queue_processes = 10
audit_file_dest =
C:\ORACLE\PRODUCT\10.2.0\ADMIN\CSSPROD\ADUMP
background_dump_dest =
C:\ORACLE\PRODUCT\10.2.0\ADMIN\CSSPROD\BDUMP
user_dump_dest =
C:\ORACLE\PRODUCT\10.2.0\ADMIN\CSSPROD\UDUMP
core_dump_dest =
C:\ORACLE\PRODUCT\10.2.0\ADMIN\CSSPROD\CDUMP
db_name = cssprod
db_unique_name = cssprodblade
open_cursors = 300
pga_aggregate_target = 418381824
dg_broker_start = TRUE
--
Sincerely,
Michael Ray
Topshot Systems LLC
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
