netrusov / ZabbixDBA

Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
MIT License
95 stars 54 forks source link

force close cursors after selectall_arrayref #91

Closed netrusov closed 4 years ago

netrusov commented 4 years ago

closes #77

for some reason there's this condition in DBI#selectall_arrayref which is the root cause of an ORA-01000 error

$sth->finish if defined $MaxRows;

I've added MaxRows parameter with default value 1000. I think it's more than enough for monitoring purposes