spool usage and spool space

Database
N/A

spool usage and spool space

Hi

If few SQL queries are run and highest spool usage value among all queries is obtained from DBQLOGTBL

Then does this mean that minimum spool should be set to highest spool usage value among all queries?

For example: query 1 shows spool usage as 10GB, query 2 shows spool usage as 40 GB and query 3 shows spool usage as 25 GB.

Does this mean that minimum spool space allocated should be at least 40 GB?

Niteen

Tags (1)