Re: Manual mem management in 10g
- From: Michael Ray <topshot.rhit@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Jun 2006 11:30:55 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
