Sql patch creation impact in busy systems

  • From: GG <grzegorzof@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 9 Nov 2020 19:07:21 +0100

Hello,

got hit by some all_synonyms bug in PDB 12.1, quick solution seems to be add hint via

sys.dbms_sqldiag_internal.i_create_patch (for 3 sql_ids)

but is it safe in ExaCS environment running hundreds of sessions ?

Should we expect spike not only casued by hard parse for those sql_ids ?

Easy fallback via drop sql patch but same questions remain.

Have not find anything documented how this works .

Regards.

Greg


--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » Sql patch creation impact in busy systems - GG