RHEL5.4 Tuning to maximize concurrent connections

[Yaboto]

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

[Nighwish]

Hi

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

Regards.

[Yaboto]

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

[Alzhy]

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?

[Alzhy]

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

[Vladimir Fabecic]

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?