Re: Another angle on this....

Jim,

TYVM, very interesting. For me, the top 2 links were broken, and the Ask Tom information was a bit fragmented with all kinds of other stuff though I was kind of able to guess at the multi-versioning stuff.

But the last URL pointing me at the appropriate documentation from 8i was great. Clever, as I expected, and I imagine essential for large datasets and/or enormous transaction volumes. And there are manual overrides for locking too for the really retentive. Excellent.

The "don't necessarilly see recent commited updates from other users" thing explains more fully some behaviour that I'd observed in Oracle and found mildly irritating but hadn't complained about because I'd already guessed it might be linked to this kind of volume performance issue. So thats why when I commit parameter-file UPDATES in PL/SQL in order to change behaviour in my app if I then use my app immediately I don't always see the change. I guess you can imagine how jarring that was to me. I thought I'd gone nuts at first.

Regards

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:II8d8.106169$Pz4.416729_at_rwcrnsc53...
> See:
>

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a88856/c0
> 1intro.htm#3932
>

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a88856/c0
> 2servr.htm#21536
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:527304::NO::F4950_P8_DISPLAYID,F
> 4950_P8_CRITERIA:1502605216980,%7Btransactions%7D
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:527304::NO::F4950_P8_DISPLAYID,F
> 4950_P8_CRITERIA:652424147595,%7Btransactions%7D
>

http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c23cnsis.htm#17
> 882
> "Heinz Kiosk" <no.spam_at_ntlworld.com> wrote in message
> news:dG5d8.2873$hM6.289452_at_news6-win.server.ntlworld.com...
> > > Let me give you the reverse complaint list. One for
> > > which there is no work-around in SQL Server.
> > >
> > > 1. No multiversioning.
> > >
> > > Didn't need any others. That one is more than enough. When you figure
> out
> > > how to code around that in TransactSQL let Bill Gates know.
> > Yeah, right, like I'd help *him*.
> > >
> > > Daniel Morgan
> > >
> >
> > What do you mean by multi-versioning anyway Dan? The briefest of
> > explanations or a URL will suffice. I stumbled briefly around oracle.com
> > looking for it but I couldn't come up with anything conclusive. Various
> > possibilities but no 100% hit with the title, "This is what Daniel was
> > referring to, Tom"
> >
> > Regards
> >
> >
> >
> >
> >
>
>
Received on Thu Feb 21 2002 - 11:09:16 CST