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 <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
>
>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 <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>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.
