Maximum Nr. of extents ?
Patricia asked for the maximum number of extents per table. Neil Truby said about 240 by a documented formula; Norman Erickson Lugtu said 233 on Sun for a non-fragmented table, with error -271 on exceeding it. neurologic said there is no fixed number (tables failed at 217, 189, 180). Patricia had one with 385 extents; Norman explained the limit applies per fragment.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi guys, Anyway we can find out the maximum number of extents that a specific table can reach ? Let me know, Pati Sent via Deja.com http://www.deja.com/ Before you buy.
There is an impenetrable formula in the documentation somwhere. It usually works out at about 240. <patricia_br@my-deja.com> wrote in message news:8uc7rf$2ck$1@nnrp1.deja.com... > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > > Sent via Deja.com http://www.deja.com/ > Before you buy.
On Sun, the maximum number of extents is 233 on a non-fragmented table. You will get error -271 if the server attempts to get a new extent with the said max extent. In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.
There is no solid number for the maximum number of extents that a table can hold. One of my databases had a table run out at 217, a buddy of mine had tables run out at 189 and 180. Do not rely on any formulas or magic numbers for this issue, they are all wrong. Duff In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.
Thank you guys, I got a gift from a previous DBA: I have a table with 385 extents and over 40 million records. I better do something about it fast. Are you guys hiring ? :-) Patricia In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.
It is possible to have that number of extents if the table is fragmented. Remember that the extent limit of around 200, is per fragment. In article <8ucl1f$f0h$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Thank you guys, > > I got a gift from a previous DBA: I have a table with 385 extents and > over 40 million records. I better do something about it fast. Are you > guys hiring ? :-) > > Patricia > > In article <8uc7rf$2ck$1@nnrp1.deja.com>, > patricia_br@my-deja.com wrote: > > Hi guys, > > > > Anyway we can find out the maximum number of extents that a specific > > table can reach ? > > > > Let me know, > > Pati > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.