Hi,

you can run the amazingly useful "show tree" command (unsupported) against
the activity log tree to find out how much of the database it's using up.

show tree Activity.Log

add up leaf-nodes and non-leaf-nodes for the number of pages used.
I find its usually less then 0.1%.

(!show tree scans the database trees and for some it can take a LONG time!)

From: Leo Humar <lhumar AT BIGPOND.NET DOT AU>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Database Space???
Date: Mon, 13 Nov 2000 10:20:16 +1100
The activity log is a possible reason for this.

Because the activity log is stored in the database, the size of the
activity
log must be factored into the amount of space allocated for the database.
The activity log size is dependent on the length of time the activity log
information is retained. When the length of time is increased, the amount
of
accumulated data also increases and additional database storage is required

You will have to us give more information about your policies and the last
couple of days of events so we are able to asses the possible causes.

Leo Humar
LCS Pty Ltd
lhumar AT bigpond.net DOT au

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

-----Original Message-----
From: Saad Al-Sakran <sakransa AT KFSHHUB.KFSHRC.EDU DOT SA>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: 12 November 2000 19:36
Subject: Database Space???


Hi ever one
My database size is increasing sharply and I do not do any changing if u
have any possible causes please tell me what is the proper way to deal with
this situation.

Thanks for all
best regards
Saad Al-Sakran
LAN Administrator

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.