Re: Oracle versus MS Sqlserver 2000: Technical Comparison of the Features in the two databases

"P" <zarathustri_at_a.com> wrote in message news:<Qwgba.970$LT.2847_at_newsfeeds.bigpond.com>...
> Hello,
>
> What link do you mean?
>
> Porushh.
>
>
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> news:92eeeff0.0303100852.8dd3306_at_posting.google.com...
> > "P" <zarathustri_at_a.com> wrote in message
> news:<aqXaa.261$LT.1176_at_newsfeeds.bigpond.com>...
> >
> >
> > Good article. Please provide link to this if available.
> >
> > Thanks
> > /Rauf Sarwar

P said >>
c. No control over storage/space management to prevent fragmentation in

    Sql Serv. All pages (blocks) are always 8k and all extents are always

    8 pages (64k). This means you have no way to specify larger extents

    to ensure contiguous space for large objects. In Oracle, this is     fully configurable.
<<

It can be proven that the number of extents has little to no performance impact and hence Oracle has provided uniform extent tablespaces as an option since version 8.1. Many Oracle experts strongly encourage their use. I agree it is desirable for this to be configerable by the DBA, but I think the wording needs changing since contiguous space for a large object is not required for performance or maintenance reasons.

HTH -- Mark D Powell -- Received on Tue Mar 11 2003 - 08:40:52 CST