CREATE OR REPLACE PROCEDURE with_plscope_disabled 
IS 
BEGIN 
   NULL; 
END; 

ALTER SESSION SET plscope_settings = 'IDENTIFIERS:ALL' 

CREATE OR REPLACE PROCEDURE with_plscope_enabled 
IS 
BEGIN 
   NULL; 
END; 

ALTER SESSION SET plsql_optimize_level = 1 

CREATE OR REPLACE PROCEDURE slow_poke 
IS 
BEGIN 
   NULL; 
END; 

Which Program Units Are Not Fully Optimized?

SELECT *  
  FROM user_plsql_object_settings p  
 WHERE p.plsql_optimize_level < 2 

Which Program Units Can Be Analyzed with PL/Scope?

SELECT DISTINCT name  
  FROM user_plsql_object_settings ao  
 WHERE plscope_settings = 'IDENTIFIERS:ALL' 

alter session set plsql_warnings = 'ENABLE:PERFORMANCE,ERROR:5005' 

CREATE OR REPLACE FUNCTION no_return (check_in IN BOOLEAN) 
   RETURN VARCHAR2 
AS 
BEGIN 
   IF check_in 
   THEN 
      RETURN 'abc'; 
   ELSE 
      DBMS_OUTPUT.put_line ('Hello!'); 
   END IF; 
END no_return; 

Which Program Units Have Compile Warnings Set to Errors?

SELECT *  
  FROM user_plsql_object_settings p  
 WHERE p.plsql_warnings LIKE '%ERROR%'