In order to help with insert contention and select performance the best partitioning scheme we have found for Oracle has been to use hash partitions on sym_data and sym_node.
sym_data was partitioned by data_id and sym_data_event was partitioned by node_id.
Labels: