niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Server
AIX parameters for Oracle
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Vincent M
*nix forums Guru


Joined: 22 Feb 2005
Posts: 1332

PostPosted: Thu Jul 20, 2006 6:58 pm    Post subject: AIX parameters for Oracle Reply with quote
Hi,

AIX 5.1 Oracle 9.2.0.4

I have the following parameters:
minservers 40
maxservers 200
maxreqs 4096

I have often the following :
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.

According the documentation, i have to increase maxservers
Is there any issue to set 300 for maxservers
and maxreqs 8192 ?

I plan to set , according the documentation,
vmtune -c 8
vmtune -r 32 -R 64 ( MINPGAHEAD, MAXPGAHEAD )

Have you any experiences about these parameters ?

Thanks in advance ...
Back to top
Matthias Hoys
*nix forums Guru


Joined: 18 Apr 2005
Posts: 400

PostPosted: Thu Jul 20, 2006 7:19 pm    Post subject: Re: AIX parameters for Oracle Reply with quote
"astalavista" <nobody@nowhere.com> wrote in message
news:44bfd23d$0$25331$636a55ce@news.free.fr...
Quote:
Hi,

AIX 5.1 Oracle 9.2.0.4

I have the following parameters:
minservers 40
maxservers 200
maxreqs 4096

I have often the following :
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.

According the documentation, i have to increase maxservers
Is there any issue to set 300 for maxservers
and maxreqs 8192 ?

I plan to set , according the documentation,
vmtune -c 8
vmtune -r 32 -R 64 ( MINPGAHEAD, MAXPGAHEAD )

Have you any experiences about these parameters ?

Thanks in advance ...



Yes, you have to increase maxservers and maxreqs, and the error will go
away. Don't forget to reboot the server for the new settings to become
active.

PS : why are you still on AIX 5.1 ? There were some async i/o bugs fixed in
5.2, I don't think 5.1 is still supported by IBM.
Back to top
Andreas Piesk
*nix forums beginner


Joined: 21 Nov 2005
Posts: 18

PostPosted: Thu Jul 20, 2006 9:06 pm    Post subject: Re: AIX parameters for Oracle Reply with quote
astalavista wrote:
Quote:
I have the following parameters:
minservers 40
maxservers 200
maxreqs 4096

how many CPUs and how many disks does the system have?

regards,
-ap
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Mon Dec 01, 2008 8:20 pm | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Move Oracle 10g database to another location Selt Server 0 Fri Jul 21, 2006 2:14 pm
No new posts Oracle runtime Spitfire Server 0 Fri Jul 21, 2006 1:18 pm
No new posts Oracle Text Score Computation jatinder.1975@gmail.com Server 0 Fri Jul 21, 2006 1:00 pm
No new posts positional parameters of a var SumGuy shell 5 Fri Jul 21, 2006 12:38 am
No new posts Can a trigger insert records into another oracle server Tauqir Server 2 Fri Jul 21, 2006 12:27 am

Share Prices | Deals On Products | Free Hosting Tutorials | Cheap Magazine | Bad Credit Mortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2263s ][ Queries: 16 (0.1287s) ][ GZIP on - Debug on ]