Performance tuning at oracle database level and performance tuning at web logic server level and con

[sai rama krishna]

Hi All,

I like to know how to do performance tuning at oracle database level and performance tuning at web logic server level , performance tuning at web logic server console (like increasing the thread counts) for a java application. Please advise

[Tim Holloway]

As a general rule, you want the Oracle database to be performing as well as possible, because it's probably being used by a lot of systems, not just WebLogic.

However, a poorly-performing webapp isn't going to immediately get better just because you tuned the database. The parts of the app that are hurting it may not even be using the database.

I'd typically measure what URLs are non-performant, look at what they are doing and then look to see if they are being dragged down by poor database performance.

[sai rama krishna]

Thank you for the great information. It makes more sense now.