Database Performance

Project:thing
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

On a request from a client to decrease the numbers of extents on a database we restructured the database with larger extents using a new structured file. But now the client is complaining about database performance. Is really possible?

Errol


Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#1

when you decrease the number of extents, that will decrease number of open files in the system which is an OS setting I believe. In the moden system, that number is high and not usually the culprit of your performance issue. You need to find out the performance was before you decrease the extents and now you need to know what exactly the performance issue is now afterward. they are just too many possibilities and my guess is not with number of extents.