Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

berxMay 25 2020 — edited May 26 2020

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

Post Details

Added on May 25 2020
#active, #database-ideas, #database-ideas-ideas
0 comments
238 views