How BRM Behaves Inserting Records In Partitions Based On Non-Poid Column (Doc ID 2105648.1)

Last updated on APRIL 03, 2023

Applies to:

Goal

Scenario:

* During a performance testing activity on a custom table where partition was created based on poid and indexes also created, experienced some performance issue wherein pcm_op_search is taking more time than expected.

Question:

* In this context, one would like to know how brm will behave if one creates partition on non-poid columns. Whether records will be inserted in correct partition or not?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.