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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center