CODEWITHSUNDEEP
sqloracle11g
jknocek
jknocek

Reputation: 13

Oracle Query - Data changes during query execution

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!

Upvotes: 0

Views: 52

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132570

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.

Upvotes: 3

Related Questions