On Fri, 28 Feb 2003, Farren Minns wrote:
>Hi Richard and thanks for the response.
[...]
>However, the reason for my post was more that I was concerned about the
>number of bytes moved figures (below). The 5000Mb volume is either plainly
>being shown incorrectly, or perhaps something more serious is afoot.
>
>Is this something anyone has seen before?
>
> 5000Mb - 947,912,704
> 2500Mb - 2,621,440,000
> 1000Mb - 1,048,576,000
What you are seeing is the difference between assigned capacity
and percentage utilized (see the output of q db).
It would appear that your database has an assigned capacity of
8500MB (5000 + 2500 + 1000), and a percent utilization of 51.8%,
with the second and third of your data volumes being full, and
all new database pages being allocated from the 5000MB volume.
-- Tom
Thomas A. La Porte, DreamWorks SKG
<mailto:tlaporte AT anim.dreamworks DOT com>
|