Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Calling dbms_profiler.stop_profiler when not profiling
Will doing so have any adverse affects? I'd like to add dynamic
profiling to some code. If calling stop_profiler has no ill effect
when not profiling, it makes the code simpler. Eg, can I do this:
IF profiling_enabled THEN
DBMS_PROFILER.START_PROFILER(...);
END IF;
...
DBMS_PROFILER.STOP_PROFILER;
instead of this:
IF profiling_enabled THEN
DBMS_PROFILER.START_PROFILER(...);
END IF;
...
IF profiling_enabled THEN
DBMS_PROFILER.STOP_PROFILER;
END IF;
??
In testing, it appears to have no ill effect.
Thanks for any info.
-Chris Received on Fri Aug 20 2004 - 15:16:15 CDT