RE: Installing 8.1.7

So
essentially this takes us back to the old 505 extents per segment rule when dealing with a db_block_size of 8192..
<SPAN
class=749395615-25092001> 
Cheers
for the info..
<SPAN
class=749395615-25092001> 
<SPAN
class=749395615-25092001>Regards
<SPAN
class=749395615-25092001> 
<SPAN
class=749395615-25092001>Mark

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Jacques Kilchoer   [mailto:Jacques.Kilchoer_at_quest.com]Sent: Tuesday, September 25,   2001 16:42To: 'ORACLE-L_at_fatcity.com'Cc:   'mark_at_cool-tools.co.uk'Subject: RE: Installing   8.1.7
> -----Original Message----- >

  From: Mark Leith [<A
  href="mailto:mark_at_cool-tools.co.uk">mailto:mark_at_cool-tools.co.uk]
> > I got a theory question..

  Just because I'm not going to be > putting it in   to > practice myself really :0) <FONT   size=2>> > When using all of the below (LMT   & UNIFORM EXTENTS, with the default >   recommended extent sizes): > <FONT
  size=2>> How do you determine the max size a table should be for a
> particular extent >

  size? Do any of you adopt a method of saying: >
> Right, once a table reaches 500 extents, then it
  should be > moved to a larger <FONT
  size=2>> extent TS?
  Steve Adams has written an interesting article on the   subject: Planning Extents <A
  href="http://www.ixora.com.au/tips/creation/extents.htm"   target=_blank>http://www.ixora.com.au/tips/creation/extents.htm

  <<...For this reason, we recommend that the number of   extents per segment in locally managed tablespaces be limited to the number of   rows that can be accommodated in the extent map within the segment header   block - that is, approximately (db_block_size / 16) - 7.>>   I personally move a table when it approaches 1000 extents, out   of habit more than anything else. Received on Tue Sep 25 2001 - 12:26:27 CDT