Why is it's worth to mention?
1st he fixed a problem I faced within extraordinary speed (< 4 hrs!):
declare /* xplan_exec_marker */ *** error before main block (
processing XPLAN_OPTIONS ) *** -- main block
*
ERROR at line 1:
ORA-06550: line 1, column 34:
PLS-00103: Encountered the symbol "*" when expecting one of the following:
begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior
--in setup.lst it's this error:
declare /* xplan_exec_marker */ -- process options
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 28
and 2nd: he didn't even announce it himself, so someone must do it :)
1 Kommentar:
Alberto is awesome! It is interesting how Carlos Sierra's SQLTXPLAIN is also improving significantly. It is almost as if these two are merging....
I had not used Alberto's xplan before, but now I am going to check it out.
Kommentar veröffentlichen