I got the links this morning. You have to have an otn account (which is
free), so I am pretty sure that if you don't have an account then those
links would be broken.
"Heinz Kiosk" <no.spam_at_ntlworld.com> wrote in message
news:vT9d8.4259$hM6.513403_at_news6-win.server.ntlworld.com...
> 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 - 21:57:42 CST
