My Oracle Support Banner

Helpful Hints for Providing Database Query Information (Doc ID 2783370.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


 Pointers for providing data query information for problem analysis.

A frequent request for problem analysis of an issue is to query the database tables and provide the results.   The NMS application often makes many entries that can be within seconds or in some cases within the same second, having precise information is required.

SqlDeveloper, as well as other database tools  have capabilities to display the date and time values to the second.  Setting the NLS parameters should be done before saving the data for a report.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.