Home » RDBMS Server » Server Administration » Oracle 9i consuming memory (RHL 7.3)
Oracle 9i consuming memory (RHL 7.3) [message #62148] Wed, 30 June 2004 04:20 Go to next message
Jitendra Agrawal
Messages: 71
Registered: December 2003
Member
Hi all,

We are facing a strange problem with our new oracle installation. Oracle seems to consume all the system memory after 6-8 hours. Even if I shutdown all other applications using oracle the memory consumtion does not reduce significantly.

Has anyone faced this problem before on RHL7.3 with 9i?

Regards,
Jeet.
Re: Oracle 9i consuming memory (RHL 7.3) [message #62149 is a reply to message #62148] Wed, 30 June 2004 05:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are your semaphores in /etc/system set to the minimum values recomended by oracle?
Re: Oracle 9i consuming memory (RHL 7.3) [message #62150 is a reply to message #62149] Wed, 30 June 2004 05:15 Go to previous messageGo to next message
Jitendra Agrawal
Messages: 71
Registered: December 2003
Member
Hi,

There is no /etc/system on my machine !! Which file exactly I am supposed to look at.

Which file exactly? and what is the recommended value?

Jeet.
Re: Oracle 9i consuming memory (RHL 7.3)- i was wrong [message #62151 is a reply to message #62150] Wed, 30 June 2004 05:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i apologize.
i forgot that u are using linux.
there is not /etc/system for linux.
idea is to set the minimum kernel paramters.
please look here
http://download-east.oracle.com/docs/html/A96167_01/pre.htm#CHDHDABJ

u might be challenged with a username and password.
craate one for you. Its free!.
Re: Oracle 9i consuming memory (RHL 7.3)- i was wrong [message #62153 is a reply to message #62151] Wed, 30 June 2004 06:04 Go to previous message
Jitendra Agrawal
Messages: 71
Registered: December 2003
Member
Hi,

thnx for the link we had used the same document while installing oracle.

following are my kernel parameters

[[root@stp root]]# cd /proc/sys
sys sysvipc
[[root@stp root]]# cd /proc/sys/kernel/
[[root@stp kernel]]# cat sem
250 32000 32 128
[[root@stp kernel]]# cat shmmax
4294967295
[[root@stp kernel]]# cat shmmni
4096
[[root@stp kernel]]# cat shmall
2097152
[[root@stp kernel]]# cat /proc/sys/fs/file-max
399767
[[root@stp kernel]]# cat /proc/sys/net/ipv4/ip_local_port_range
32768 61000
[[root@stp kernel]]#

Do you think value of file-max might cause the reported behaviour?

Thanx and regards,
Jeet.
Previous Topic: 8.1.7 instance hangs during startup
Next Topic: 9i Partitioning options
Goto Forum:
  


Current Time: Fri Sep 20 14:22:14 CDT 2024