ORa-4031 in PDB And CDB environment

The issue is the ORA-04031 and this is worked in base of the failed chunks.

Now as mentioned the best thing is to focus in the very first presented ORA-04031 issue (ORA-04031 ("shared pool","select inst_id, blk_num, blk...","SQLA","tmp")) as the next occurrences are triggered as consequence of this.

The shared patch from previous analyst will help with ORA-04031 ("shared pool","unknown object","KKSSP^1896","kglseshtSegs").

To solve the ORA-04031 ("shared pool","select inst_id, blk_num, blk...","SQLA","tmp") first presented ORA-04031 you need to execute shared Action Plan.

====Action Plan========

Please reset the shared pool parameter set at pdb p_eisp