Physical Modeling › Oracle Physical Property Editors › Oracle Storage Properties Dialog

Oracle Storage Properties Dialog

Open the Oracle Storage Properties Dialog when you click on the Storage Properties button in various property editors. Use the Oracle Storage Properties Dialog to assign various storage properties for an Oracle tablespace.

The following describes the options for the Oracle Storage Properties Dialog:

• TABLESPACE

  A drop-down list box where you can select a tablespace from the current model to which you assign storage properties. If you need to edit the properties of a tablespace you select, click the button to open the Oracle Tablespace Editor.

• Extents

  Enter values for the following options for Extents:

  • INITIAL

    Specifies in bytes the size of the object's first extent.

  • NEXT

    Specifies in bytes the size of the next extent to allocate to the object.

  • PCTINCREASE

    Specifies the percent by which the third and subsequent extents grow over the preceding extent.

  • MINEXTENTS

    Specifies the total number of extents to allocate when the object is created.

• Maxextents

  When you select this option, select one of the following options for Maxextents:

  • UNLIMITED
  • VALUE

    If you select this option, enter a value in the text box.

• Space Usage

  Enter values for the following options for Space Usage:

  • PCTFREE

    Specify the limit Oracle should use to determine when additional rows can be added. The value of this parameter is expressed as a whole number and interpreted as a percentage.

  • PCTUSED

    Specify the space to be reserved for each data block for future expansion. The value of this parameter is expressed as a whole number and interpreted as a percentage. This option appears only when you are in the Oracle Table Editor or the Oracle Materialized Views Editor.

• Buffer Pool

  Select this check box if you want to specify a default buffer pool. When you select this option, select one of the following options for Buffer Pool:

  • KEEP

    Puts blocks from the segment into the KEEP buffer pool.

  • RECYCLE

    Puts blocks from the segment into the RECYCLE buffer pool.

  • DEFAULT

    Specifies DEFAULT to indicate the default buffer pool.

• Number Transactions

  Enter the values for the following options for Number Transactions:

  • INITRANS

    Specify the initial number of concurrent update transactions allocated for data blocks.

  • MAXTRANS

    Specify the maximum number of concurrent update transactions for any given data block. Note: This option is not available for Oracle 10g.

• Freelists

  Enter values for the following options for Freelists:

  • FREELISTS

    For objects other than tablespaces, specify the number of free lists for each of the free list groups for the table, partition, cluster, or index.

  • FREE GROUPS

    Specifies the number of groups of free lists for the database object you are creating.

• Redo Log

  When you select this option, select one of the following options for Redo Log:

  • LOGGING
  • NO LOGGING