Marzo de 2002 02:08 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: How TO KNOW TABLE SIZE
Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema
_
I usually do
select sum(bytes) from dba_Segments
where segment_name = 'TABLENAME';
HTH
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> How can I know how much space a table occupied?
> Can BLOCKS columns in dba_tables helps?
> Or I have to use dba_extents and dba_segments
> tables?
> Thx
> -Se
This is what I use. Hope it helps.
spool table_space_usage.log
set pagesize 0
set linesize 80
select substr (segment_name,1,20)
,bytes / 1024 kbytes
,extents
Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema
_
MSN Photos is the easiest way to share and print your photos:
http://pho
