UCMDB Support Tip: Oracle Database connection job takes too long to finish - Issues
In the event "Oracle Database Connection by SQL" job takes a very long time to complete, and the user is prompted with a warning message regarding the maximum execution time in the UI. Furthermore, the communication.log is incomplete and very often cannot be retrieved at all is encountered.
In order to address this issue, it has been implemented to change trigger for Oracle database connection by SQL job to improve performance,which will be implemented into future HP uCMDB releases.
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."
Click the KUDOS star on the left to say 'Thanks'