I am oracle DBA, and have been using toad for several years now and I must say I love it. I have thought this a lot and now I thought that I’d make a such suggestion.
It is very convenient to compile objects via “Schema Browser” buttons, but I really am missing such COMPILE options without DEBUG. And hence, I often have to write specific DDL’s to compile without debug option.
The reason for this is ofcourse optimization. As we all know, compiling with DEBUG option, disables most of the optimizations, so it has impact on performance.
TOAD version: 188.8.131.52
It would be nice to have such option, to compile all the objects (classes, triggers, procedures, functions, packages etc) without DEBUG option, on future releases.