HM process dont answer

[violant]

I think it ORACLE test wait for user request. ORACLE ODBC tests work fine, but when I Enable ORACLE DB tests - thread count increased after some time.
I use Oracle client 10.2.0.4. I test Oracle DB version 10.2.0.4(3). But oci.dll have fileversion 10.2.0.1 (right click by file- Properties).
Can you post right file (maybe you check it) oci.dll.
I write console tool that check thread count and restart HM.

[KS-Soft]

We used the same version of oci.dll (10.2.0.1) and as I remember it worked fine but now we cannot connect to the server at all. While ODBC test still works fine...

I write console tool that check thread count and restart HM

Isn't it better just stop using this DLL and switch to ODBC test method if it works fine?
(Some Oracle ODBC drivers have bugs as well. ODBC drivers from version 8 and version 10g have problems. Version 9 works fine as we now)

Also, HostMonitor can check itself (Oracle DLL is running unside application address space and using resources of the process).
E.g. you may use WMI test method and query like Select HandleCount from Win32_Process where Caption='hostmon.exe'

Regards
Alex

[violant]

Isn't it better just stop using this DLL and switch to ODBC test method if it works fine?

I think about this. Can try. Now I just disable Oracle DB test.

I try to add ODBC test. Connect only. With DLL reply time 233ms, with ODBC connect only - 3344ms.

E.g. you may use WMI test method and query like Select HandleCount from Win32_Process where Caption='hostmon.exe'

When count of thread increasing hostmon process behaves inadequately. So I better use outside util.

[KS-Soft]

I try to add ODBC test. Connect only. With DLL reply time 233ms, with ODBC connect only - 3344ms.

H'm.. it works fine on our system. Also we rebooted system and Oracle OCI.DLL now is working as well.
- Oracle test: ~80 ms
- ODBC test using Microsoft ODBC for Oracle version 2.575.1022 ~70 ms
- ODBC test using Oracle in XEClient version 10.02.00.01 ~ 120 ms

Yes, Oracle ODBC driver is the slowest, as usually, but not too much.

Its strange picture. According to our tests and to reports from our customers - free SQL servers work better than expensive Oracle. Well may be not the server but clients had many bugs for sure. MySQL clients had problems as well.
While PostgreSQL works pretty fast and reliable; MS SQL client works fine as we know.

Regards
Alex

[violant]

ODBC test using Microsoft ODBC for Oracle version 2.575.1022

I use native Oracle ODBC driver version 10.02.00.04

А situation was stabilized now.
Some test have 80 ms reply time - some 3500 ms. I don't now any dependences.
Microsoft Oracle ODBC driver don't test.
But on native Oracle ODBC driver work stable - thats perfect , reply time- that not substantially.