| what happens in the engine when a query is aborted? [message #152906] |
Tue, 27 December 2005 14:50  |
cumin
Messages: 82
Registered: August 2005
|
Member |
|
|
If a SELECT query is aborted (i.e. the SQL*PLUS window is closed) are there any processes that continue, related to that query? I believe when a CREATE TABLE SELECT query is aborted, there is some cleanup/rollback work that does continue, which is where my question is coming from.
|
|
|
|
| Re: what happens in the engine when a query is aborted? [message #152964 is a reply to message #152906] |
Wed, 28 December 2005 02:47  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
When Oracle detects that the client aborted, it will rollback all changes made by the transaction - leaving the database in a consistent state.
If a SELECT is aborted, it just stops - no rollback required. However, if the SELECT is part of a transaction, the transaction still needs to be rolled back.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
