Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Row Size Question

Re: Row Size Question

From: Colm Hoban <colm.hoban_at_respironics.com>
Date: Thu, 29 Oct 1998 07:21:33 -0500
Message-ID: <36385DCD.46A@respironics.com>


David Spencer wrote:
>
> Hi Folks,
>
> I'm attempting to estimate the amount of disk space an Oracle7 database
> requires. I have about a hundred tables and know approximately how many
> rows will be in each table. What I need is a way to find how many bytes
> a row in a given table will occupy. The column types (mostly) have a
> fixed size. Is there a tool or command that does this?
>
> thanks,
> David Spencer

Try using the analyze command on the required tables... HTH Received on Thu Oct 29 1998 - 06:21:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US