Re: Manual mem management in 10g

From: Michael Ray <topshot.rhit_at_gmail.com>
Date: Fri, 30 Jun 2006 11:30:55 -0400
Message-id: <44A543AF.6040505@gmail.com>

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

Received on Fri Jun 30 2006 - 10:30:55 CDT