| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Manual mem management in 10g
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?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Ray
Sent: Friday, June 30, 2006 11:31 AM
To: oracle-l_at_freelists.org
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 =
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_recovery_file_dest_size= 2147483648
standby_file_management = AUTO undo_management = AUTO undo_tablespace = UNDOTBS1
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-lReceived on Fri Jun 30 2006 - 11:07:50 CDT
 |
 |