search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
646 stars 307 forks source link

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

Open nklamann opened 4 years ago

nklamann commented 4 years ago

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

tanelpoder commented 4 years ago

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

2) 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?