PL/SQL (MOSC)

MOSC Banner

The three first executions of a query return different results. Result Cache bug?

edited Dec 16, 2011 12:41AM in PL/SQL (MOSC) 6 commentsAnswered
Hi,

We work with Oracle 11g Enterprise Edition release 11.1.0.7.0. We remark a "temporary inconsistent data" problem. The three first executions of a query return different results.

Every day we load new data in a datawarehouse. When we check the new data of the fact table with a basic query, the result alter three times before it comes right. Then it stays fixed. The problem can't be reproduced. Only a fact column is affected by this problem. This column was inserted after the creation of the table (ALTER tab ADD column…).

I can't understand how the data is in the DB but is not directly return after the first query run. Is it possible that the "Result Cache" had a bug?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center