My Oracle Support Banner

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

Last updated on JUNE 17, 2024

Applies to:

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

Goal

 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.

Solution

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
Goal
Solution
References

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