Oracle Seg Insert Hint—Defines how SQL loader loads data to the tDataSeg tables. The default setting, Append, enables FDM to append data to segment tables without finding available space on the table, as required by the Insert setting.
Oracle Segment Table Logging Value—Used, for segment tables, to turn logging on or off.
Oracle Work TableSpaceName—Specifies the tablespace name. The default is Users.
Oracle Work Storage Clause—Specifies storage defaults for the Work tablespace. These defaults override the system defaults and become the defaults for objects created in the specified tablespace.
Oracle Work Pct Free—In regard to the Work tablespace, specifies the portion of the data block that is reserved for later updates to the rows of the block. The default for PCTFREE is 10 percent. You can use any integer between 0 and 99, inclusive, provided that the sum of PCTFREE and PCTUSED does not exceed 100.
Oracle Work Init Trans—Specifies the initial number of transaction entries that are allocated within each data block that is allocated to the table. The value can range from 1 to 255. Each transaction that updates a block requires a transaction entry. The size of a transaction entry depends on the operating system. This parameter ensures that a minimum number of concurrent transactions can update the block and helps to avoid the overhead of dynamically allocating a transaction entry.
Oracle Work Max Trans—Specifies the maximum number of concurrent transactions (1–255) that can update a data block that is allocated to the work table.
Oracle Work Table Index TableSpaceName—Defines the FDM work table index tablespace name. The default is Users.
Oracle Work Table Bitmap Index Switch—On/Off switch used to toggle the work table bitmap index. This option should be ON for Oracle 9i and OFF Oracle 10g and 11g..
Oracle Data Map Seg TableSpaceName—Defines the FDM Data Map Seg table tablespace name. The default is Users.
Oracle Data Map Seg Storage Clause—Specifies storage defaults for the Data Map Seg tablespace. These defaults override the system defaults and become the defaults for objects created in the specified tablespace.
Oracle Data Map Seg Pct Free—In regard to the Data Map Seg table, specifies the portion of the data block that is reserved for later updates to the rows of the block. The default for PCTFREE is 10 percent. You can use any integer between 0 and 99, inclusive, provided that the sum of PCTFREE and PCTUSED does not exceed 100.
Oracle Data Map Seg Init Trans—Specifies the initial number of transaction entries (1–255) that are allocated within each data block that is allocated to the data map tablespaces. Each transaction that updates a block requires a transaction entry in the block. The size of a transaction entry depends on the operating system. This parameter ensures that a minimum number of concurrent transactions can update the block, and helps to avoid the overhead of dynamically allocating a transaction entry.
Oracle Data Map Seg Max Trans—Specifies the maximum number of concurrent transactions (1–255) that can update a data block that is allocated to the Data Map Seg table.
Oracle Data Seg TableSpaceName—Specifies the tablespace name for FDM Data Seg tables. The default is Users.
Oracle Data Seg Storage Clause—Specifies storage defaults for the Data Seg tablespace. These defaults override the system defaults and become the defaults for objects that are created in the specified tablespace.
Oracle Data Seg Pct Free—In regards to Data Seg tables, specifies the portion of the data block that is reserved for later updates to the rows of the block. The default for PCTFREE is 10 percent. You can use any integer between 0 and 99, inclusive, provided that the sum of PCTFREE and PCTUSED does not exceed 100.
Oracle Data Seg Init Trans—Specifies the initial number of transaction entries (1–255) that are allocated within each data block that is allocated to the Data Seg tables. Each transaction that updates a block requires a transaction entry in the block. The size of a transaction entry depends on the operating system. This parameter ensures that a minimum number of concurrent transactions can update the block and helps to avoid the overhead of dynamically allocating a transaction entry.
Oracle Data Seg Max Trans—Specifies the maximum number of concurrent transactions (1–255) that can update a data block that is allocated to the Data Seg table.