Extent Utilization

How can I tell how much of the database extents are in use? It looks like proutil -C dbanalys gives me info by area, not extent... For example, if I have quantity 5 of 1Gb extents in an area, and 2 Gb of data, can I tell if it's all packed into the first 2 extents or if it is spread around? (11.7 on RHEL)

Thanks -- Jim

You have posted to a forum that requires a moderator to approve posts before they are publicly available.

A bit of math will do it. Dividing the fixed extent sizes by the block size will give you the number of blocks in each physical file. DBAnalys will tell you how many active blocks there are.

WIth your example, each 1 GB extent has 262,144 4K blocks. DBAnalys tells you the block high water mark. Divide by 262,144 and you'll know what file new blocks will be formatted in and hence which files are already being used.

Paul

Paul Koufalis

White Star Software

pk@wss.com

@oeDBA (https://twitter.com/oeDBA)

ProTop: The #1 Free OpenEdge DB Monitoring Tool

http://protop.wss.com

You have posted to a forum that requires a moderator to approve posts before they are publicly available.