To which size should INITIAL and NEXT be set when defining DEFAULT STORAGE for a TEMPORARY tablespace?
DB_BLOCK_SIZE+(multiple of SORT_AREA_SIZE) Temporary segments are based on the default storage parameters of the tablespace. For the TEMPORARY tablespace, INITIAL and NEXT should be equal to each other and a multiple of SORT_AREA_SIZE plus DB_BLOCK_SIZE. PCTINCREASE should always be equal to zero.
Related Questions
- Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
- If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good?
- To which size should INITIAL and NEXT be set when defining DEFAULT STORAGE for a TEMPORARY tablespace?