DBService does not Always Print Long Running Sql Commands in the Sql Command History
Last updated on JULY 06, 2017
Applies to:Oracle Utilities Network Management System - Version 126.96.36.199 to 188.8.131.52.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 184.108.40.206 to 220.127.116.11.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
The NMS system appears to be hanging.
A 'cmd snapshot' was taken.
The ISIS dump for a specific service shows that it is waiting for a response from a DBService.
The ISIS dump for the corresponding DBService shows that it is waiting for a query task to finish.
However, all entries in 'SQL Command History' show that they have completed.
The issue can be reproduced at will with the following steps:
1. Run these commands in a terminal
Returns "250" ( the "select count(1) from dual" queries will completely fill up DBService's command history -- which stores only the most recent 250 commands. )
The Sql Command History will be filled with
sql command: 'select count(1) from dual' returned: 1 after 1 ms
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms