[clug] table/tablespace growth prediction tools

[Rousak, Boris]

The db in mind is Oracle 9.2.0.5
 
What I am attempting to do is collect some data on the growth of
tablespaces, then try to extrapolate that a little into the future and
provide justification for more disk requirements. Hopefully pretty
graphs etc will help my case :)
 
I was hoping there is a tool already out in the wild but if not, then
yeah, will need to code my own :)
 
Thanks for the mysql "heads up" - while not a problem yet, I am sure it
will make itself know shortly.
 
Cheers,
Boris

	-----Original Message-----
	From: Leigh Purdie [mailto:intersect at gmail.com] 
	Sent: Thursday, 19 January 2006 11:18 AM
	To: Rousak, Boris
	Cc: linux at lists.samba.org
	Subject: Re: [clug] table/tablespace growth prediction tools
	
	
	Hi Boris,
	
	Do you have any particular DB in mind, and are you particularly
interested in row counts, or disk space availability?
	
	The reason I ask, is that some databases (eg: mysql) utilise a
process whereby the space allocated to deleted rows (or more to the
point, deleted rows that use varchar, blob or text fields) is not
actually returned to the system unless an 'OPTIMIZE TABLE' command is
used.
	
	As such, depending on your usage profile, you may see gradually
increasing 'tidal surges' of data, that take up disk space, and never
seem to release it back again - though your actual row count does jump
up and down as expected.
	
	I suspect something like a 'simple moving average' algorithm
might be appropriate for prediction (again, depending on the complexity
of your usage profile) - the algorithm is used a lot for share market
stuff, so there should be plenty of examples out there.
	
	Regards,
	
	Leigh.
	
	
	On 1/19/06, Rousak, Boris <Boris.Rousak at industry.gov.au> wrote: 

		Greets to all,
		
		Has anyone heard of/can recommend any OSS tools which
can be used to
		monitor but more importantly to predict the expected
growth of tables
		and tablespaces in a database. The monitoring I can do
with shell/sql 
		script but the prediction part is a bit trickier.
		
		So, any hints, tips, words of wisdom would all be
greatly appreciated.
		
		Cheers,
		Boris
		
	
************************************************************************
* 
		The information contained in this e-mail, and any
attachments to it,
		is intended for the use of the addressee and is
confidential.  If you
		are not the intended recipient you must not use,
disclose, read,
		forward, copy or retain any of the information.  If you
received this 
		e-mail in error, please delete it and notify the sender
by return
		e-mail or telephone.
		
		The Commonwealth does not warrant that any attachments
are free
		from viruses or any other defects.  You assume all
liability for any 
		loss, damage or other consequences which may arise from
opening
		or using the attachments.
	
************************************************************************
*
		
		
		--
		linux mailing list
		linux at lists.samba.org
		https://lists.samba.org/mailman/listinfo/linux
		



*************************************************************************
The information contained in this e-mail, and any attachments to it,
is intended for the use of the addressee and is confidential.  If you
are not the intended recipient you must not use, disclose, read,
forward, copy or retain any of the information.  If you received this
e-mail in error, please delete it and notify the sender by return
e-mail or telephone.

The Commonwealth does not warrant that any attachments are free
from viruses or any other defects.  You assume all liability for any
loss, damage or other consequences which may arise from opening
or using the attachments.
*************************************************************************