How does oracle server deal with instance when the network connection is lost

The client I used to connect to the oracle server is PL/SQL developper.

By mistask,i executed an anonymous PL/SQL block within a loop that would forever running, so i pressed break button and waited for more than 开发者_如何学Python1 hour.

but the block was still running while the client shows tip "script cancelled".then i cutted off the net connection .

So my question is Why the Block is still running after "script cancelled" and how would the server deal with my instance when then net connection is lost.

---

This session has to be killed by the dba. If the loop is ever reaching a normal termination, the transaction will be rolled back. The reason for the rollback is that the server sees that the client has gone and won't get a commit, unless it was coded. If the loop has waits in it, for example because IO has to be done, or an other package has to be called, it will terminate.