tpt-oracle icon indicating copy to clipboard operation
tpt-oracle copied to clipboard

column sizes in asqlmon and dasqlmon could be nicer (imho)

Open nklamann opened this issue 6 years ago • 1 comments

I suggest to make some adjustments to columns sizes in asqlmon.sql and dasqlmon.sql and could provide a pull request

nklamann avatar Oct 30 '19 08:10 nklamann

I have planned this for a while:

  1. have asqlmon/dasqlmon without the lengthy predicate columns in the end at all and have a clone script asqlmonx.sql/dasqlmonx.sql (X meaning extended output)

OR

  1. Just comment out the lengthy predicate columns completely as I've ended up not using the full plan details in asqlmon much, just find where the time is going and then look up the full plan with DMBS_XPLAN.DISPLAY_AWR or similar tool. Can always uncomment as needed (and we won't have an extra pair of script variations)

So, let's go with 2?

As far as other columns are concerned, would you want to increase or decrease any of their lenghts?

tanelpoder avatar Nov 01 '19 01:11 tanelpoder