Library /sys$common/syshlp/SQL$HELP72.HLB  —  CREATE  STORAGE_AREA, Arguments  ALLOCATION_PAGES
    Syntax option:

    ALLOCATION IS number-pages PAGES

    The number of database pages initially allocated to the storage
    area. Rdb will automatically extend this allocation to account
    for internal structure pages, such as SPAM (spage management)
    pages. For example, an allocation of 25 will be increased to 27
    as shown in this example:

    SQL> alter database filename MF_PERSONNEL
    cont> add storage area DOC_EXAMPLE
    cont>   page format is uniform
    cont>   allocation 25;
    SQL> attach 'filename MF_PERSONNEL';
    SQL> show storage area DOC_EXAMPLE

         DOC_EXAMPLE
             Access is:      Read write
             Page Format:    Uniform
             Page Size:      2 blocks
             Area File:      USER_DISK:[DOC.DATABASES]DOC_EXAMPLE.RDA;1
             Area Allocation:          27 pages
             Extent:         Enabled
             Area Extent Minimum:      99 pages
             Area Extent Maximum:      9999 pages
             Area Extent Percent:      20 percent
             Snapshot File:  USER_DISK:[DOC.DATABASES]DOC_EXAMPLE.SNP;1
             Snapshot Allocation:      100 pages
             Snapshot Extent Minimum:  99 pages
             Snapshot Extent Maximum:  9999 pages
             Snapshot Extent Percent:  20 percent
             Locking is Row Level
             No Cache Associated with Storage Area
    No database objects use Storage Area DOC_EXAMPLE
Close Help