Data-analysis-based facility for adjusting trace fields of a database trace

A computer system for facilitating trace processing in a database system, the computer system comprising:

• a memory;
• one or more processors in communication with the memory;
• and
• program code executable by the one or more processors via the memory to perform a method comprising:
• obtaining database trace data collected from database tracing, at least in part, a database system of the computing environment, the database tracing being for a level of database tracing of multiple levels of database tracing, and the level of database tracing comprising a trace hierarchy of trace fields used in the database tracing;
• data analyzing, by the one or more processors, the database trace data, and determining therefrom one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system;
• and
• applying, by the one or more processors, the one or more field-related rules to adjust for the level of database tracing the trace hierarchy of trace fields for a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.

A computer-implemented method for facilitating trace processing in a database system, the computer-implemented method comprising:

• obtaining database trace data collected from database tracing, at least in part, a database system of the computing environment, the database tracing being for a level of database tracing of multiple levels of database tracing, and the level of database tracing comprising a trace hierarchy of trace fields used in the database tracing;
• data analyzing, by the one or more processors, the database trace data, and determining therefrom one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system;
• and
• applying, by the one or more processors, the one or more field-related rules to adjust for the level of database tracing the trace hierarchy of trace fields for a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.