Database Maxspool

Database
Enthusiast

Database Maxspool

Hello,

I understand how maxspool works for users and profiles, but am uncertain if the same rules or sizing techniques apply when creating a database.  So when I am creating a database (NOT user, NOT profile) what impact does the Spool settings have on queries?  What would be a general rule of thumb for setting spool (and temp) space for a database?

Thanks for your assistance!

Excerpt from "Database Administration - 13.10 " PDF

When using the CREATE USER, CREATE DATABASE, or CREATE PROFILE statements to

assign spool space limits, consider the settings of the following space levels, which are listed in

the DBC.DiskSpaceV view.

 

MaxSpool

A value used to limit the number of bytes the system allocates to create spool

files for a user.

The value you specify may not exceed the value of the immediate parent

(database or user) at the time you create the user. If you do not specify a value,

MaxSpool defaults to the MaxSpool value of the parent.

Specify the spool limit of each user, taking into consideration the tables they

access, to reduce the impact of “runaway” transactions, such as accidental

Cartesian product joins.

1 REPLY
Junior Supporter

Re: Database Maxspool

Hi,

spool is only used for uers and not databases. You can create a user under another user or database. 

Since databases and users are very similar in TD, that's why it might be mentioned here.

I have never came across spool space given to database. its given to user directly or to profile , in which users are added.

When using the CREATE USER, CREATE DATABASE, or CREATE PROFILE statements to

assign spool space limits, consider the settings of the following space levels, which are listed in

the DBC.DiskSpaceV view. -