High number of child cursor in VPD databases

Hello,

Has anyone encountered and addressed the issue with a high version count due to VPD?

In our databases, we have hundreds or even thousands of child cursors. GV$SQL_SHARED_CURSOR shows the main reason as "Authorization/translation check failed for the existing child cursor."

The issue is present in various Oracle 19 versions, likely not connected with a specific version. We have probably had this issue for a long time already.

Suggestions in (Doc ID 1326096.1) are not really helpful:

1. Avoid using VPD policies that generate variable predicates

⇒ not applicable in our cases.

2. Try to program the policy to generate uniform predicate using SYS_CONTEXT if that is applicable.