Two update statements waiting for gc cr create event

Team:

Thank you for checking my query.

RAC cluster environment with Oracle enterprise 19.15 patch update.

I had a scenario where two update statements with the same sql_id but different internal variable values and trying to update the same table and maybe the same subpartition as per the ASH report Top DB Objects listing. Both sessions came from the same RAC instance/node.

Currently, the tables and indexes are partitioned.

I checked for any possible known bugs/issues with 19.15.000 but none were found.

I was thinking of sub-partition by the mod of process id and instance id to avoid this issue.