Hi team,
I have created stored procedure , inside there will be insert statement with parallel select statement. if try to execute. below table getting locks whenever i use to execute.
when i monitor session information in plsql developer below table getting lock. the process still running almost 4 or 5 hours ..still not disconnecting ..
TBL_TEST
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE TBL_TEST';
INSERT INTO TBL_TEST
SELECT *
FROM TBL_TEST_EMP;
COMMIT;
END;
Kindly advise it.