oracle code / sql monitoring, what are the tools for this ?
Posted on 2014-10-23
I'm pretty familiar with Oracle tracing / tkprofs to monitor sql statements.
But how can PL/SQL code that's not actual SQL statements be monitored, for performance considerations ?
Can the Oracle DBA see what non-Sql statements are being executed, their timing, etc. ?
Also, specifically, if the code was in a non-SQL infinite loop, would the DBA be able to see the line of code it was on ?
while v_flag is FALSE
if substr(In_value,v_counter,1) = v_compare_value then
v_position_of_value := v_counter;
v_flag := TRUE;
v_counter := v_counter + 1;
if it was looping through and never got to v_flag := TRUE, would the DBA be able to pinpoint the line of code ? And if they could, could it show it was on the "while" statement ?