Forum Stats

  • 3,768,292 Users
  • 2,252,772 Discussions


How to terminate running PL/SQL anonymous block?

foxhound Member Posts: 22 Red Ribbon

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'.

  1. Is it possible to terminate only the execution of the block without terminating its session?
  2. Where can I take a look at running sessions/transactions/queries/plsql blocks to identify the running anonymous block?
  3. The only way to terminate it is to login as privileged user or as my regular user but with some roles?

Best Answer