"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a5porp$2sk$1_at_lust.ihug.co.nz>...
> There are no good formulae that I know of. Deletes and Inserts will tend to
> be the entire row length plus some overhead, updates just the length of the
> columns being updated. But add in rollback and indexes, and things get much
> stickier, and there's no magic formula for working it out ahead of time.
Estimating size of redo logs generation is pretty shitty task. Right
now I'm looking on small procedure that makes simple inserts, which
generates six time more redos than is inserted size. :-(
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Tue Mar 05 2002 - 02:21:37 CST
