When I’m using SQL Monitor and connect to a host appliction, the host appliction locks sometimes. When I disconnect SQL Monitor the host continues…
the host appliction locks sometimes
do you want to say that SQL Monitor application is locking your “host application”?
ok-this is clear.
now let us go further, so please place answers on next questions:
which host application we are speaking about?
how did you find out that SQL Monitor is the blocker?
If you maybe has SQL Tracker, Sell app that may help you in finding problems in running apps against oracle databases…
just come to my mind…do you have maybe have SQL Monitor (Toad) on the same hoot as your host app is?
if so, how are you sure that Windows resources are not a problem (mem, swap, cpu)?