Re: table size in bytes
From: Charles Thompson <thompsoc_at_groupwest.ca>
Date: 1995/03/29
Message-ID: <3lcb8r$4om_at_wolfe.wimsey.com>#1/1
Date: 1995/03/29
Message-ID: <3lcb8r$4om_at_wolfe.wimsey.com>#1/1
There are a few ways. I've used a query like the following :
select blocks * 512 /* assuming 512-byte block size ... see init.ora */
from dba_tables
You could also use the num_rows column in dba_tables and multiply the size in bytes per row.
-- =-=-=-=-=-=-=-=-= C h a r l e s T h o m p s o n =-=-=-=-=-=-=-=-= =-=-=-=-=-=-=-= thompsoc_at_groupwest.ca =-=-=-=-=-=-=-= =-=-=-=-=-=-= /\ =-=-=-=-=-=-= =-=--==-=-= \/ =-=-=-=-=-=Received on Wed Mar 29 1995 - 00:00:00 CEST