Project: | thing |
Component: | Miscellaneous |
Category: | support request |
Priority: | normal |
Assigned: | Unassigned |
Status: | active |
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
#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.