Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can an object have too many extents?

How many extents would an object have to have to be extreme?

How many extents would an object have to have to be extreme? I personally would like to keep them to a maximum of 1,000 to 2,000, but I know of companies that have 30,000, 40,000, even up to 90,000 extents for individual objects. These companies have indicated that the number of extents does not matter any longer. Your opinion?
In older versions of Oracle, a high number of extents was undesirable. But if you are storing your tables and indexes in Locally Managed Tablespaces, which is the only extent management algorithm I use anymore, then you will not have a problem with your segments as it pertains to the number of extents. I have tables that have many thousands of extents and I do not have performance problems.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close