oracle cartridge - server side limit lifetime of search

User f6e55a9bc3

04-05-2016 15:45:43

Is there a server parameter fin jcart.properties that will set a limit on the lifetime of tasks with long last_rescheduled values automatically?


We are working with a third party application, and cannot modify the running sql (unless there is a way to do that at the cartridge administrator).


At the moment, we are manually running t_get_taskinfo and then kill_task. Obviously we could automate this with a pl/sql queued job, but would prefer a server side parameter.

User f6e55a9bc3

04-05-2016 15:47:38

btw, Oracle 12.1.0.2.0 64 bit standard edition, jchem 6.2.1, running on RHEL

ChemAxon abe887c64e

05-05-2016 07:44:25

Hi John,


Unfortunately, there is not any appropriate parameter provided in our cartridge for setting this limitation.


Best regards,


Krisztina