Re: max extents....

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 29 Oct 1998 16:58:18 GMT
Message-ID: <71a6ra$c7g$2@bignews.shef.ac.uk>

In article <36389A43.EAF1777E_at_bigfoot.com>, dcowles_at_bigfoot.com says...
>
>So is the answer here that you can set extents to max out anywhere you want,
>but it's actually limited by the db_block size? (121,249,505 etc.,)

It depends on what Oracle version you are on. It used to be limited by block size eg 121 extents for 2k blocks, but since 7.3 (maybe 7.2??) the restriction is removed amd you can have as many extents as you want.

I still have an aversion to segments with hundreds of extents however, and tend to set these parameters rather conservatively.

Cheers
Martin.

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. Received on Thu Oct 29 1998 - 10:58:18 CST