Oracle Performance bottleneck (Urgent)
Posted on 2002-05-29
We have developed a multithreaded application using Proc. Our OS platform is solaris 2.8 (sun fire 4800 with 4cpu and 4GB RAM) and oracle version is 8.1.6.
we are initially linked our application with single threaded pro*c runtime library, in this configuration transaction speed was very high.
But since our application is multithreaded one hence we linked our application with multithreaded Pro*c runtime library (by specifing "exec sql enable threads"). After this we have observed our application performance has detoriated drastically.
Please provide any solution urgently.