ADSM-L

Re: Fragmented Database Maybe?

2003-02-28 11:26:03
Subject: Re: Fragmented Database Maybe?
From: "Thomas A. La Porte" <tlaporte AT ANIM.DREAMWORKS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 28 Feb 2003 08:21:14 -0800
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>          

<Prev in Thread] Current Thread [Next in Thread>