Skip navigation

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

score 10
You have not voted. Active

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.

Comments

Vote history