sar question

[Haitham Hamad]

We get a snapshot of the sar command at a specified time for a daily report. Since we added a controller and two hard disks 2 weeks ago, we are realizing that the value of file-sz from the sar command is increasing every day since we added the controller. Today I am getting 1110/1227 when 2 weeks ago, I was getting 409/1227. All my other systems are showing 409/1227. I am afraid my Oracle database will shutdown if I reached the limit of 1227. Any ideas how to tackle this problem? Thanks

[Philip Chan_1]

Hi,

The file-sz column in sar corresponds to the nfile kernel parameter. To avoid overflow of it you could increase that parameter in SAM then you should be all right.

[John Waller]

It looks like you have found an application problem. You may want to try to install the lsof command from one of the free download sites to try to indentify the increased open files.

[Carlos Fernandez Riera · Accepted solution]

Search for nfiles on forum, there are several responses for similar questions:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0xa369dfe5920fd5118fef0090279cd0f9,00.html


http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0xcebb6af52b04d5118fef0090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x006b37f45ef7d4118fef0090279cd0f9,00.html