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.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…