Return
-
Title
PL\SQL Profiling not collecting data even after running the Server Side Objects -
Description
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;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.