Werk #4785: oracle_locks: New SQL for check

Component	Checks & agents
Title	oracle_locks: New SQL for check
Date	Jun 16, 2017
Level	Trivial Change
Class	Bug Fix
Compatibility	Compatible - no manual interaction needed
Checkmk versions & editions	1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Not yet released Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.5.0i1 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.4.0p6 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME) 1.2.8p24 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

The behavior of this check has been changed. There is no output for object_owner and object_name anymore. This has been removed for performance reasons. The check is moved from ASYNC to SYNC, due to very easy SQL for getting the data. The problem with lot of wrong alarms has been solved as well.

The old SQL is still existing for users who wants the object_owner and object_name in check result. Please be aware that the old problems are still there. Please make sure that the old check is configured as ASYNC-Check. Otherwise you risk high performance issues in mk_oracle!

Please define the following lines in mk_oracle.cfg to get the old behavior: SYNC_SECTIONS="instance sessions logswitches undostat recovery_area processes recovery_status longactivesessions dataguard_stats performance" ASYNC_SECTIONS="tablespaces rman jobs ts_quotas resumable locks_old"

To the list of all Werks