DB version: 11.2.0.4
Platform: Oracle Linux 6.7
I have a stored procedure which usually finishes execution in 3 hours. Today it has been running for 10 hours and still hasn't finished execution.
I got the SQL from v$session.sql_id . But, it just shows the procedure (in the package) like below.
BEGIN manh_batches_pkg.calc_current(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,:A5,:A6,:A7); END;
I want to know which SQL the stored procedure is stuck at. This procedure calls around 8 functions and 2 stored procedures within its code.