multiples connections drop sessions about pyora HOT 11 CLOSED

Hi,

The slowness is when you try to use Pyora or it's affecting the Oracle itself?

from pyora.

Is affecting the oracle itself .. in my view .. every function of the pyora uses a session, I have case of 30 banks, each with 83 selects that gives a total of 2190 starting from a single host, and in banks they are slow Due to several selects at once .. per session .. if it were several selects entering a time pool, I think it would look better for the bank

from pyora.

Did you try to increase the interval of the items?

from pyora.

Yes. I have increased several but the more select enter, the more it fills ..

from pyora.

I do not run active, because the bank is not mine, it's client, and it's redhat versions 5, 4, as long as python 2.6 runs, I'd rather not risk it.

from pyora.

@lsa1es you can run below query to check PyOra users logon/logoff operations
SELECT username, action_name, Count(*) FROM dba_audit_trail WHERE timestamp > SYSDATE - 1 GROUP BY username, action_name ORDER BY 3 DESC;

for me pyora user is in first place (significant difference with 2nd user), around 36K logon and 36K logoff in 24h time window , I found same issue as yours with my current configuration, will check if increasing check interval will reduce it or not.

Regards,
Aidin

from pyora.

@aidin300 ,

Did you get issues with latency too?

from pyora.

no, at lease I'm not aware of.

from pyora.

@aidin300 this is still an issue? I think you could increase the interval of each check to avoid too many logon/logoff operations.

from pyora.

it would be great if you can increase check interval or use a connection pool in python

from pyora.

Good idea. Going try play with this next weekend. 👍

from pyora.