Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to terminate running PL/SQL anonymous block?

foxhoundOct 7 2021

I have run pl/sql anonymous block which is infinite loop. Then now I wish to terminate it before it will fail by itself. In this particular case it results in 'ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT'.
Is it possible to terminate only the execution of the block without terminating its session?
Where can I take a look at running sessions/transactions/queries/plsql blocks to identify the running anonymous block?
The only way to terminate it is to login as privileged user or as my regular user but with some roles?

This post has been answered by User_H3J7U on Oct 7 2021
Jump to Answer

Comments

Post Details

Added on Oct 7 2021
1 comment
433 views