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@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Friday, June 30, 2006 11:31 AM
To: oracle-l@(protected)
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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l