Users are unable to see DML Changes after commit.
Posted on 2007-07-20
Here is another interesting thing came up in my environment. My users are complaining that they perform DML on tables some of them can see data others can't and sometime after few minutes some time after reboot sometime after a day user can see that data and sometime they never see that data and uses the other user's terminals and user id (System's USER ID not Oracle because it's the same user at the backend)
to see the reports.
Again My front end is Oracle 6i and Backend is Oracle 10g R2.
It sound illogical to me that this may be a parameter setting issue since some of the users can see data, but may be since it's my opinion.
Please comment and advice.