System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

RHEL5.4 Tuning to maximize concurrent connections

 
Yaboto
Super Advisor

RHEL5.4 Tuning to maximize concurrent connections

Hi,

 

I am using RHEL5.4 OS on 2 different servers: one for a banking application and one for Oracle Database.

The issue is that the performance is so low during day time transactions posting and during the Close Of Business or End Of Day.

The surprising thing is that the performance statistics at the Systems level (Processor, memory, network, Storage IO etc...) is not showing any bottleneck. In all the cases the ressources utilization is bellow 25%.

 

There are about 3,200 concurrent user connections.

 

Do you have any idea about what is going on ?

 

Please help.

 

Best Regards,

Yaboto

5 REPLIES 5
Nighwish
Frequent Advisor

Re: RHEL5.4 Tuning to maximize concurrent connections

Hi

 

 

If the botleneck is not in the O.S., try to check DB and aplication ( apache, tom cat etc.. )

 

Regards.

Yaboto
Super Advisor

Re: RHEL5.4 Tuning to maximize concurrent connections

 

Can you please specify some of those parameters ? Are they kernel parameters ?

Alzhy
Honored Contributor

Re: RHEL5.4 Tuning to maximize concurrent connections

It is likely a Database issue -- tuning.

 

Is this a NEW environment? Have you just migrated Databases on Linux?

 

Check I/O on the DB server -- iostat, sar, vmstat... post if you can.

 

If the DB server is Oracle -- what version? What sized SGAs, what's installed memory on server.. what is CPU type?

Hakuna Matata.
Alzhy
Honored Contributor

Re: RHEL5.4 Tuning to maximize concurrent connections

also .. (if Oracle DB) -- have you observed all the Oracle on Red Hat (or Linux)  best practices? for eg -- HugeMem settings, etc?

 

Hakuna Matata.
Vladimir Fabecic
Honored Contributor

Re: RHEL5.4 Tuning to maximize concurrent connections

I also think it is Oracle issue.

One more thing: did you try to use more than one oracle listener?

And what is your database (and patch) version?

In vino veritas, in VMS cluster