| max number of extents for individual objects [message #180944] |
Wed, 05 July 2006 23:04  |
rs350z
Messages: 2
Registered: July 2006
Location: oregon
|
Junior Member |
|
|
how many extents would an object have to have to be extreme? in my opinion, i would like to keep them to a maximum of 1000 to 2000 but i know of companies that have 30,000, 40,000, and even up to 90,000 extents for individual objects. these companies have indicated that the number of extents does not matter any longer. your opinions.
thanks
|
|
|
|
| Re: max number of extents for individual objects [message #180980 is a reply to message #180944] |
Thu, 06 July 2006 02:50  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
An object would have as many extents as were required to store the requisite data.
| Quote: |
in my opinion, i would like to keep them to a maximum of 1000 to 2000
|
So in a segment with an extent size of say 64k block size 4k avg row length 1k, what would you do when your table exceeds the relatively small number of rows and passes your threshold of 2000 extents? Delete the rows?
Jim
|
|
|
|
| Re: max number of extents for individual objects [message #181000 is a reply to message #180980] |
Thu, 06 July 2006 04:31 |
rs350z
Messages: 2
Registered: July 2006
Location: oregon
|
Junior Member |
|
|
|
to keep the extents manageable, i would adjust the size of the extents. there are 3 extent sizes i would use for all of my tablespaces and by using these sizes, you would keep the maximum number of extents below 2000. for example, i have used 128mb extent sizes for quite a few very large tables. you only need to make sure that the extent size is a multiple of your block size.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
