Limit statements to be explained

When you produce Explain reports, limit the number of SQL statements to be examined.

There are various ways you can limit the output. You can specify only the plans or packages that you are interested in, or you can use the LIMIT, PACKLIMIT, and PACKAGES NO options.

To reduce attachment costs, it is always best to group the subsystems you are reporting.