Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Sizing
See "Administrator's Guide", Managing Schema Objects, for how to estimate
storage requirements.
In general, for VARCHAR2 and NUMBER datatypes the actual storage used
depends on the actual values stored (i.e., strings may be shorter than
maximum defined length). Numbers are stored as packed decimal
(ceil(length/2) + 1); plus there is some row overhead.
I've attached two files to help you estimate:
Willy Chua <willy_at_dfi.com> wrote in article
<3426edeb.426973082_at_client1.news.psi.net>...
> I wanted to know where I can find the actual data storage being used
> by ORACLE (7.x) datatypes and other storage considerations.
begin 600 tfsrowsz.sql
<encoded_portion_removed>
end
begin 600 tfsclcsz.sql
<encoded_portion_removed>
end
Received on Tue Sep 23 1997 - 00:00:00 CDT
![]() |
![]() |