Re: base 2 or base 10?
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: Dave.Herring@xxxxxxxxxx
- Date: Wed, 28 Sep 2005 10:56:52 -0500
Dave,
> Is there any real performance benefit to using base 2 sizes vs. base 10 when
> dealing with datafiles and extents?
Oracle will round the extent size up to an even block size. So you
should use binary for extent sizes.
For datafiles, I would just use what is most convenient for you.
Convenience reduces mistakes. Far better to be off by one percent than
worry so much about saving a percent or two that you use K for file
size when you meant M.
Dennis Williams
--
//www.freelists.org/webpage/oracle-l
Other related posts:
