random server freezes
Hi!
I'm using Oracle 10g2 on Centos 5 x64
Server Dell R900
Due to database low performance we decided to increase server physical memory from 16G to 22G and mem distribution changed this way:
Before Oracke 5G (4sga + 1pga), 11G to OS needs
After Oracle 15G(10sga+5pga), 7G to OS needs.
I was using 80-20 rule of thumb and decided that 7G must be sufficient since it is even more than 20%.
Our DB server in dedicated mode and there are about 150 users using database.
So, after 1 week of monitoring there were several issues with server:
- Oracle listener went down several times
- Server has been freezing 2 times so I had to restart it physically (nothing in alert log and system journal too)
Can it be issue with low memory size left to OS?
I am new to oracle administration, so, any clue on this would be appreciated much.
Thanks.
Edited by: user9339570 on May 1, 2013 7:52 AM