Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Database Sizing
littlechicken wrote:
> Hi all,
>
> I am not very knowledgable in this area so would appreciate any advice
> you guys can give.
>
> I need to provide a projected estimate of Oracle db tables. Essentially
> my problem is in trying to work out the size of one single row. I have
> a table which uses the varchar2, integer and date datatypes but I
> cannot seem to find anywhere how many storage bytes each of these use
> (with the exception of varchar).
>
> As far as I understand for integers and numbers it depends on the
> actual number entered - is this correct? If so - is there anyway I can
> estimate this based on the data I know will be entered.
>
> Also, I read somewhere that date takes 7 bytes of storage - is this
> correct?
>
> All help much appreicated,
> Thanks
The 10g enterprise manager has a GUI that will calculate this out for you.
( So do several other tools such as Toad, etc ).
If you want to you can double check calculated sizes from the tools with information that you derive. Received on Thu Feb 23 2006 - 09:06:19 CST