Forum Stats

  • 3,824,848 Users
  • 2,260,430 Discussions
  • 7,896,330 Comments

Discussions

extend v$diag_trace_file_contents so multiple chunks of a line can be ordered

berx
berx Member Posts: 219 Silver Badge
edited May 26, 2020 4:37AM in Database Ideas - Ideas

If a tracefile has lines longer than 4000 byte, at the moment (19.7) the line is broken down into several pieces.

In this example, the PARSING IN CURSOR is real line 219.

all following lines belong to line 220 of the file - but all except the last are shown as line 219.

v$diag_trace_file_contents_chunks.png

Unfortunately there is no way to order these lines.

The underlying x$dbgtfview has an column INDX which can be used, if externalized.

Beside fixing the wrong line number for all but the last chunk, I suggest an additional column to oder the chunks of a line.

To give proper credits This observation was done by Jeff Holt.

Jeff Holt
1 votes

Active · Last Updated