Forum Stats

  • 3,768,292 Users
  • 2,252,772 Discussions
  • 7,874,519 Comments

Discussions

How to terminate running PL/SQL anonymous block?

foxhound
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?
Tagged:

Best Answer

Answers