No question at this time
DBA Top 10
1 B. Vroman 15300
2 M. Cadot 12400
3 J. Schnackenberg 7400
4 T. Boles 6950
5 A. Kavsek 6900
6 M. Hidayathullah ... 3300
7 T. P 1300
8 G. Lambregts 1100
8 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48245
Total active users1631
Act. users last 24h3
Act. users last hour0
Registered user hits last week190
Registered user hits last month742
Go up

sar -v
Next thread: Add new port on Cluster Listener
Prev thread: Please help on REGISTRAR='RFS' AND APPLIED='NO';

Message Score Author Date
Hi Guys I am experiencing issues with the file ...... Tso P Aug 02, 2018, 16:33
For those who you use sar, where is the file-sz ge...... Tso P Aug 03, 2018, 11:46
Thanks guys, the issues I had was due to filesyste...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Tso P Aug 13, 2018, 10:57

Follow up by mail Click here


Subject: sar -v
Author: Tso P, South Africa
Date: Aug 02, 2018, 16:33, 17 days ago
Os info: solaris 11
Oracle info: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Error info: File table overflow
Message: Hi Guys

I am experiencing issues with the file table overflow...

When I run sar -v I get the following:


10:40:00 proc-sz ov inod-sz ov file-sz ov lock-sz
10:41:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:42:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:43:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:44:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:45:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:46:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:47:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:48:00 74/30000 0 0/129797 0 19459/19459 0 0/0
10:49:00 74/30000 0 0/129797 0 19460/19460 0 0/0
10:50:01 74/30000 0 0/129797 0 19460/19460 0 0/0


When I try to list the files I get File table overflow error.

When do one set the max size for the file-sz?

Please Help

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sar -v
Author: Tso P, South Africa
Date: Aug 03, 2018, 11:46, 16 days ago
Message: For those who you use sar, where is the file-sz get changed so that it can allow 30000?

Please help...

Thanks in advance...

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sar -v
Author: Tso P, South Africa
Date: Aug 13, 2018, 10:57, 6 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Thanks guys, the issues I had was due to filesystem configurations. I had to increase the vxfs vxfs_ninode=1000000 on /etc/system then that solved our issue.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here