Executing procedure, after having toggled on SQL Profiler, does not prompt for profiler comments and the run doesn't show up in Database | Optimize | DBMS Profiler Analysis. The Server Side Objects were run to create the Profiler tables and there is a Grant Execute on DBMS_Profiler.
e.g.
DECLARE
INVAL NUMBER;
BEGIN
INVAL := 1;
LOOPPROC ( INVAL ); ** Prodecure is executed without running DBMS_Profiler
COMMIT;
END;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center