PLSCOPE_SETTINGS='IDENTIFIERS:ALL' downsides?

  • From: Matt McPeak <mcpeakm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: Oracle List <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 18 Oct 2021 16:17:04 +0000 (UTC)

Is there a reason (any at all), not to alter all the custom packages in my 
database to compile them with PLSCOPE_SETTINGS='IDENTIFIERS:ALL'?  Performance? 
 Security?  Anything?
If there are reasons not to do it in production, I'm considering giving out 
DBAs a script to turn it on for everything as part of their instance-cloning 
procedures, so it would be turned on in all non-production environments.  That 
script would include an ALTER SYSTEM SET PLSCOPE_SETTINGS='IDENTIFIERS:ALL', so 
that PLScope data will be maintained as developers do their work.  Any reasons 
this is a bad idea?
Thanks,Matt


Other related posts: