- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
extend v$diag_trace_file_contents so multiple chunks of a line can be ordered
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.
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.