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:
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
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
-Seema
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
_
MSN Photos is the easiest way to share