When you have made all available tuning changes for a particular table but post speed is still not satisfactory, then consider setting up Horizontal Partitioning to speed up post.
If you know a particular column that can be used for Horizontal Partitioning condition, then you can set up horizontal partitioning based on column conditions.
If you don't have a column to use for column conditions, then you can set up Hash Partitioning in SharePlex which essentially generates partitions based on rowids.
A table with heavy insert activities in a long running transaction would be a good candidate for Hash Partitioning.
To set up horizontal partitioning by HASH, you only need one entry in the SHAREPLEX_PARTITION table on source.
PARTITION_SCHEME NOT NULL VARCHAR2(30)
DESCRIPTION VARCHAR2(61)
TARGET_TABLE_OWNER VARCHAR2(30)
TARGET_TABLE_NAME VARCHAR2(30)
ROUTE NOT NULL VARCHAR2(4000)
PRIORITY NUMBER
ORDERING NUMBER
OPTIONS VARCHAR2(32)
COL_CONDITIONS NOT NULL VARCHAR2(1024)
The OPTIONS column must be set to “HASH” followed by the number of partitions required (maximum 99). The COL_CONDITIONS set to “ROWID”.
The ROUTE column must be configured such that SharePlex can create named queues for the different hash partitions.
