When the P1 Text of a Wait is “file#”, would be very nice to be able to easily see the file name associated with the file# – click on the file number and display the file name or have a file-name column which is populated when appropriate (probably later is preferable).
That seems like a good idea. I made a change so that instead of seeing "file#’, you’ll see "File: ’ and then the file name.
John, for some reason, for “direct path reads”, Oracle has decided to populate P1 Text with “file number” instead of “file#”. If possible, I’d appreciate it if that was also included in this change.
Sure, I can take care of that.