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?