query for spool usage of a particular query

Database
Enthusiast

query for spool usage of a particular query

Friends , can someone share a DBQL query to find spool space used by a user id for a particular query.
I want to check max spool consumed by that query ,so to decide if i can increase spool space to that user.
Pleae share.
2 REPLIES

Re: query for spool usage of a particular query

Zenith

We can check the spool space when the SQL is running only by
Select
VProc,MaxSpool,CurrentSpool
from dbc.diskspace
where upper(databasename)="DATABASE"
order by 1
Enthusiast

Re: query for spool usage of a particular query

There is also a SpoolUsage field in the DBQLogTbl that should show the spool consumed by that query.