Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] ORACLE memory utilization reach 99%

Clemens Bleile

2006-10-09

Replies:


Hi,

what di you mean with "stop accepting connection" ?

Do you get an error message, does it just hang or is the connect very slow? Try with sqlplus and send the error-message.

How much memory do you have in your system? What is SGA_MAX_SIZE, SGA_TARGET and PGA_AGGREGATE_TARGET? In addition send the output of "free".

Thanks

Clemens

--- Original Message ---
> Hi,
>
>  I have this machine that consistently show memory utilization
> reach
> 99% and then stop accepting connection. There are no alert log
> being
> generated in bdump. I have changed SGA_MAX, sessions_CACHE_CURSORS,
>
> open_cursors, sessions parameter in the past, what can be
> creating
> this?
>
>  This is a new machine that I recently moved to and has more
> memory
> than the previous machine (same application). The only thing
> I think
> is significantly different is the SGA_MAX size and the use of
> nic
> bonding.
>
>  Thanks.
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.