Max. size fixed database extents UNIX

RealHeavyDude

RealHeavyDude

Well-Known Member
OE 10.1C03 Sun Solaris 64Bit / 300 concurrent users / database 150 GB large.

As a preparation for D&L and storage area re-design I am looking on opionions on which extent sizes are reasonable. At the momemt I am thinking of having 5 - 10 GB large fixed extents dependingn on the size of the storage area plus one variable extent for each storage area.

Are 5 - 10 GB sized extents reasonable. Would you suggest larger extents or smaller ones?

Any comments are appreciated.

Thanks in advance,
RealHeavyDude.
 
I'm a "powers of 2" kind of guy and I use 8GB extents quite often.

There's no special reason for powers of 2 -- I just like them ;)

The main thing is to think about how fast your areas are likely to grow, how often you're likely to need to add extents and how you are going to mangage that process. Personally I don't like having to add extents very often so I tend to go with big ones that give me plenty of extra space.

The "all variable" approach also has some attractions.
 
Hello Tom,

thanks for your swift reply.

Then I would say that my predecessor as DBA advisor was a "power of 0.5" kinda guy. Obviously he liked the idea to not have database extents larger than 500 MB :eek:, therefore the database as it is right now consists of more than 200 extents - which already caused problems with file handles :blush1:.

For managabilty reasons I tend to have as few extents as possible per storage area.

Best regards,
RealHeavyDude.
 
Lots of small extents was an old wisdom. Some people haven't figured out that there is a new wisdom yet... :)
 
That is one issue I have seen over the years: I've seen so many people developing Progress applications who started out in V5 or V6 and just happened to become DBAs. To me it appears as if they haven't recognized the need to stay uptodate with the Progress technologie and modern computer systems since all commands they know from back then still work the same way they did back then.

Some weeks ago I was asked by the IT manager of a Progress shop which serves a few customers if the AI is working finally in OE10.2A and what my recommendation would be if it does not ...

Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top