When it compiles with debugging information, Isn't it optimized?
When it compiles with debugging information, Isn't it optimized?
1) 11.2.0.2 At the time of the compile in those without debugging information
SQL> ALTER SESSION SET PLSQL_DEBUG = FALSE
2 /
セッションが変更されました。
SQL> select name, value from V$PARAMETER
2 where name = 'plsql_optimize_level'
3 /
NAME
------------------------------------------------------------------------------
VALUE
------------------------------------------------------------------------------
plsql_optimize_level
2
SQL> create or replace
2 procedure ttt is
3 v_code NUMBER;
4 v_errm VARCHAR2(64);
5 BEGIN
6 IF TO_DATE('20112233','YYYYMMDD') > SYSDATE THEN
7 NULL;
8 END IF;
9 EXCEPTION
10 WHEN OTHERS THEN
11 v_code := SQLCODE;
12 v_errm := SUBSTR(SQLERRM, 1, 64);
13 DBMS_OUTPUT.PUT_LINE('Error code ' || v_code || ': ' || v_errm);
14 END;
15 /
プロシージャが作成されました。
SQL> set serveroutput on
0