Re: diff bewteen 8i and 9i?

Two things David Austin told us that Howard didn't point out... the INTERNAL account and server manager are actually going away. (According to David, some people have successfully used 8i's server manager... but it hasn't been fully tested).

David talked about KEEP/RECYCLE/DEFAULT only to say that the documentation so far is written on beta software. At this point they're still supporting the multiple pools only for the default block size. But that doesn't mean they won't either get rid of them, or expand the support later.

David also mentioned that 9i is supposed to more fully support ANSI standard SQL. I am hoping that they're going to support scrolling cursors, so we can FETCH NEXT, PRIOR, FIRST, LAST, ABSOLUTE n, and RELATIVE n. Any mention of those Howard? How soon to you think schools participating in the Oracle Education programs will be able to get those 17 chapters?

Best!

Randall

Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3b150fe5.746875_at_news-server...
> On Wed, 30 May 2001 23:17:01 +1000, "Howard J. Rogers"
> <howardjr_at_www.com> wrote:
>
> >
> >Mmmm. Enough there to keep me busy for a while, I guess.
> >
>
> Not wrong. Quite a lot. I found the bitmapped blocks quite
> interesting. And of course, the multiple block size and individual
> caches for each block size. But haven't found the cache/tablespace
> yet, still good old KEEP/RECYCLE/DEFAULT only. That's a real bummer.
>
> Also, in the bit I saw, the SGA could be re-sized within limits. The
> individual bits inside the SGA can be re-sized, but the overall total
> size was still a constant.
>
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Sat Jul 21 2001 - 16:47:06 CDT