Oracle Query - Data changes during query execution

Question

I have a query that essentially sums a number column, and this query can take a very long time to execute. I'm curious what the result of the query will be if rows are deleted or added during execution of the query.

The answer depends on how Oracle executes queries. Does it query a snapshot of the DB at the point of execution of the query, or does it account for live data changes?

Thanks in advance!

Tony Andrews · Accepted Answer · 2013-05-13 15:37:28Z

3

The short answer is that the query works on a snapshot of the data at the time it started - "statement-level read consistency".

The long answer is in the documentation here.

answered May 13, 2013 at 15:37

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jknocek Over a year ago

Thanks for the quick and direct answer!

Collectives™ on Stack Overflow

Oracle Query - Data changes during query execution

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related