What happens to a long running SQL query when the connection is broken?

Question

Oracle

Launched the creation of indexes in the database. While executing the query, the connection between the client and the database was broken.
What is the fate of the request execution? When executed in v$session, I see my active session, which has been terminated. Will it run to the end or should the process and session be killed on the database server?

Answer 1

If the value of the SQLNET.EXPIRE_TIME=0 parameter, then Oracle will not know that the client is already disconnected, the current operation will be completed and the index will be created. In the case of DML operations, the transaction will be rolled back, because after it there should be a commit, and by that time Oracle will already understand that the client is disconnected and will rollback.