Dictionary and Spool Space Requirements
After you determine how much space remains when overhead is accounted for, determine how much space is required for the data dictionary and spool.
Reserve approximately 80 MB for growth of system tables and the WAL log. However, optimum space for the WAL log must be based on the number of rows dropped or updated by concurrently running transactions during your peak workload.
User TEMP Space Requirements
The TEMPORARY clause in the CREATE DATABASE and CREATE USER statements permits you to allocate default space within this database or user for inserting data into global temporary tables materialized by users. Vantage reserves temporary space before spool space for any user defined with this attribute.
Disk usage for a materialized global temporary table is charged against the temporary space allocation of the user who referenced the table.
Global temporary tables also require a minimum of 512 bytes from the PERM space of the containing database or user. This space is used for the GTT table header.
If no default temporary space is defined for a database, then the space allocated for any global temporary tables created in that database is set to the maximum temporary space allocated for its immediate owner.
Subtract the TEMP amount allocated to this database.
CRASHDUMPS User Space Requirements
Subtract the PERM amount allocated to this user. The crashdump user space has a default allocation of 1 GB.
If you modified the default amount when you set up the Crashdumps user, subtract the actual current amount.
User Spool Space Requirements
Whenever you create a new user, reserve a minimum of 20% of user permanent space for spool space. Determine the optimum amount of space according to your application environment. This takes into account average table size, protection choices, number of rows involved in commonly used transactions, and so forth.
The optimum allocation depends on your application environment. If your requirement is to perform the calculations according to the formulas provided in this section, and the calculated amount exceeds 20% of permanent space, use the actual figure plus 5%. To determine an allowance based on your applications, use the formulas in this section.