On Oct 9, 2006, at 5:45 PM, CLEMENS.BLEILE@(protected):

>
> Hi,
>
> what di you mean with "stop accepting connection" ?
>

the client will get database connection error.

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

No slowdown, just client having problem to connect.

> 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".


This is a AMD64 system running 64 bit version of Oracle 10g

Value when I gotten into problem.


Physical memory : 8 gig
SGA_MAX_SIZE : 4.2 gig
SGA_TARGET : 2.2 gig

Aggregate PGA : 783 MB


Don't have the free output at that point but the current value is

        total     used     free   shared   buffers  
cached
Mem:     8125976   7581276   544700       0   546020  
6226444
-/+ buffers/cache:   808812   7317164
Swap:    4200988       0   4200988

with the new (current) setting of

SGA_MAX_SIZE : 3.2 gig
SGA_TARGET : 3.2 gig
Aggregate PGA : 783 MB

Quesiton :

In "Oracle Database 10g - Linux Administration", there was a section
where configuring oracle for > 2.7 GB SGA.

It recommended the following
1. Creating a ram disk by doing
 umount /dev/shm
 mount -t ramfs ramfs /dev/shm
 chown oracle:dba /dev/shm

2. change /etc/security/limits.conf
 oracle soft memlock 3145728
 oracle hard memlock 3145728

3. echo 8589934592 > /proc/sys/kernel/shmmax


I have often assume the above only apply to 32-bit linux systems, does
it apply to 64-bit version of SUSE ? since share memory parameter are
handle by orarun.





>
> 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