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=CRUNCHER)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XXX)(INSTANCE_NAME=cssprod)(SERVER=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