dimension of a table

[claude69]

Huy guy, i want know if exist a select that give back to me the exact dimension (mega bytes) of one table
Thanks

 

[appi]

Hi Claude,

try this : Install this view

rem
rem dba_file_view
rem
rem
create or replace view dba_file_data AS
SELECT
a.name tablespace,
a.dflminext min_extents,
a.dflmaxext max_extents,
a.dflinit init,
a.dflincr next,
a.dflextpct pct_increase,
d.name datafile,
b.blocks datafile_size,
c.maxextend maxextend,
c.inc ext_incr
FROM
ts$ a, file$ b, filext$ c, v$dbfile d
WHERE
a.ts#=b.ts#
and
b.file#=d.file#
and
b.file#=c.file#
/

and then use this query to find out :
rem
rem Name : free_space2.sql
rem
rem
set feed off
set flush off
set verify off
set pages 58 lines 175
column tablespace HEADING Name FORMAT a20
column min_extents HEADING 'MIN Ext' FORMAT 9999
column max_extents HEADING 'MAX Ext' FORMAT 9999999999
column init HEADING INITial FORMAT 999
column next HEADING NEXText FORMAT 999
column pct_increase HEADING 'PCT Inc' FORMAT 999
column datafile HEADING Datei FORMAT a28
column datafile_size HEADING Size FORMAT 999,999
column maxextend HEADING FileExtend FORMAT 999999999
column ext_incr HEADING 'Ext Incr' FORMAT 999
tti 'FILE SPACE REPORT'
spool C:\Test\Oracle\file_space_rep.txt
select * from dba_file_data;
spool off
clear columns
tti off
set feed on
set flush on
set verify on
set pages 22 lines 80


regards
Uwe

 

[claude69]

Tanks Uwe for your advice.
Have you a good Week End

Claude (Italy)