Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Segment management auto clause

Re: Segment management auto clause

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 14 May 2003 04:35:32 +1000
Message-ID: <NKawa.33877$1s1.492365@newsfeeds.bigpond.com>


The test results I got were posted right here not so very long ago (late last year, I believe).

3% extra space utilisation, 17+% extra full scan time.

Repeated ad nauseam on Windows and Linux, and demo'd off the top of my head every time I do the 9i New Features course (ie, on Solaris too, and without much effort).

And ask Jonathan about having 20%+ of his Buffer Cache full of bitmap blocks.

Regards
HJR Received on Tue May 13 2003 - 13:35:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US