Path: news.easynews.com!easynews!sn-xit-02!sn-post-01!supernews.com!news.demon.nl!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: size of a table Date: Wed, 10 Oct 2001 19:38:47 +0200 Message-ID: Reply-To: "Sybrand Bakker" References: <3BC48229.DF95BDFF@savvion.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: news.demon.nl 1002737168 news:10799 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 43 Xref: easynews comp.databases.oracle.server:120848 X-Received-Date: Wed, 10 Oct 2001 11:07:43 MST (news.easynews.com) "maz" wrote in message news:3BC48229.DF95BDFF@savvion.com... > Hello, > > is it possible to calculate the amount of space that is being used by a > table? > how about a column? > > I have looked at some oracle DBA books that nothing is mensioned on this > topic! > > thanx in advance, > > -maz > > -- > ---------------------Use e-mail. It saves trees---------------------- > Maz Mohammadi Senior Member of the Technical Staff > mailto:maz@savvion.com (408)330-3101 > http://www.savvion.com Savvion Inc. > > "Programming today is a race between software engineers striving to > build bigger and better idiot-proof programs, and the Universe trying > to produce bigger and better idiots. So far, the Universe is winning." > -- Rich Cook You probably bought the wrong dba books Look at dba_segments for object allocation select vsize(columnname) from to get the actual allocation for a column Hth, Sybrand Bakker Senior Oracle DBA