Re: 7.3.2.3.0 On Netware 3.12

• Loosing buffers - never seen this happen.
• Jumping sequences - This will happen when you do a shutdown, or the sequences that are cached are aged out of the sga. The workaround would be 1) alter sequence_name nocache, or 2) pin the sequence.
• The only way I could see this happening is a "commit;" was not issued after doing the update (and before the insert). For example:

USER a table t1
select * from A.t1;
  c1 c2
  1001 1009
update A.t1 set c1 = 9999 where c1=1001;

USER B table t2
insert into B.t2 select * from A.t1;
select * from B.t2;
c1 c2
1001 1009

If a commit was not issued after user A issues the update user B will not see the changes.

Hans-Juergen Schmitz wrote:

> We have the following problems after an Upgrade of Oracle:
>
> - Loosing cache-buffers and not getting them back from Oracle
> (Rebooting der Novellserver helps)
> - Jumping sequences. Sequences seem to loose there cache and jump to
> the next 20-step, but not always.....
> - A INSERT (...) SELECT x,y,z,.... FROM SOMEVARDEFAULTS sometimes
> results in inserting OLD VALUES of the table SOMEVARDEFAULTS,
> which have bin overwritten by an update before.
>
> We had to do this upgrade because of a bug in Oracle 7.3 which
> appeared
> at deleting Rows of a table with more than one indexed column (Ora
> 600...). May be the third problem is a result of that.
>
> Did anyone else watch such mysterious things?
> (We have a patient database, which should not store old values...)
> Any workarounds?
> Is Oracle 7.3 a buggy version?
>
> thanks for any idea
>
> Hans-Juergen Schmitz
> Hospital for heartsurgery
> University of Regensburg (Germany)
Received on Tue Sep 30 1997 - 00:00:00 CDT