Storage Parameters for Interim Tables
You can change the storage parameters for all interim tables and indexes in General Ledger. Several concurrent programs in General Ledger use interim tables as temporary storage space for transaction data. These programs create interim tables when they start and drop them when they finish.
Although the default storage parameters meet the needs of most installations, you can increase interim table allocations if the default parameters are inadequate.
The following General Ledger concurrent programs use interim tables:
Posting: GL_POSTING_INTERIM
MassAllocations: GL_ALLOC_INTERIM
MassBudgets: GL_ALLOC_INTERIM
Translation: GL_TRANSLATION_INTERIM
Archive and Purge: GL_ARCHIVE_BALANCES, GL_ARCHIVE_BATCHES, GL_ARCHIVE_HEADERS, GL_ARCHIVE_LINES
Budget Posting: GL_BUDGET_INTERIM, GL_BUDGET_RANGE_INTERIM
Create Summary Accounts: GL_SUMMARY_INTERIM
Each table may contain one or more indexes. Refer to the General Ledger Applications Technical Reference Manual for more information on interim indexes.
Prerequisite
Determine the amount of storage space that you want to allocate to interim tables and indexes.
To set the storage parameters:
1. Navigate to the Storage Parameters window.
General Ledger automatically displays all the interim tables and indexes it uses and the corresponding default storage parameters. General Ledger indicates the Object Type (Table or Index) and the Object Name.
2. Enter the Tablespace where you want the interim table or index to reside.
3. Enter the size (in kilobytes) of the Initial Extent you want General Ledger to allocate when it creates the interim table or index.
4. Enter the size (in kilobytes) of the Next Extent you want General Ledger to allocate for the interim table or index. This size is a base value which may remain constant for each subsequent extent, or may change depending on the value you enter for percent increase. The default extent values vary with the individual table or index. To see an explanation for the default value of a particular table or index, refer to the Description.
5. Enter the Maximum number of extents allowed for the interim table or index.
6. Enter the Pctincrease, or percentage for which you want each next extent size to increase over the last extent allocated. If percentage increase is zero (0), then the size of each additional extent remains constant.
Suggestion: We recommend that you specify a percent increase of either 0 or 100 for your interim tables. Other values can increase the rate of fragmentation of your interim tablespace.
See Also
Tablespaces and Segments
(Oracle7 Server Concepts Manual)