Analysis of skew of spool files

Database
N/A

Analysis of skew of spool files

Hi

As spool file is one of the usual issue of complex queries or queries run upon large data sets, It would be good to have chance to look at skew of spool files. If it was a chance to somehow check/calculate skew of spool file - even if it is per query and steps of the query, it would be more than useful.

In fact, as there is a lot of spool files created by running a select, it would be good to know at least in which step of a query a spool file issue appears. Or, ideal state, to have information about skew of a specific spool.... whatever of this kind ...

Thanks,

Dag

1 REPLY
N/A

Re: Analysis of skew of spool files

Hi Dag,

if StepInfo is enabled QryLogStepsV will show details including spool for each step