init parameter plsql_code_type braindump

  • Published on Feb 13 2013
  • # 20
  • oracle

Some code for plsql_code_type below;

Current setting

select *
from v$parameter 
where name = 'plsql_code_type'
/

breakdown per plsql_code_type

col owner for a18
col plsql_code_type for a18


select owner, plsql_code_type, count(*)
from dba_plsql_object_settings 
group by owner, plsql_code_type
order by owner, plsql_code_type
/

compile schema(s)
After changing init.ora paramter

begin
  for i in ( select * from dba_objects where owner like 'REMITJE' )
  loop
  execute immediate 'begin dbms_utility.compile_schema( :1); end;'
     using i.owner;
  end loop;
end;
/

 

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>