How to calculate table + index size

[abhaysk]

Originally posted by jmodic
Nope. At least not without trace-dumping all the blocks belonging to the particular segment and inspecting those dumps.

Why not...and why do u wana go for dumping all blocks to know which extent has how many rows.. crazy idea.. when it can be done in a single query ...

Select 
  Count(*) 
From 
  My_Table 
Where 
  Dbms_Rowid.Rowid_Relative_Fno(Rowid) = My_Extent's_Relative_File_Number
;


Or possibally

Select 
  Segment_Name  ,
  Extent_Id     ,
  A.CNT
From
(
Select 
  Dbms_Rowid.Rowid_Relative_Fno(Rowid) RFN ,
  Count(*) CNT
From
  My_Table
Group By
  Dbms_Rowid.Rowid_Relative_Fno(Rowid)
) A,
DBA_EXTENTS
Where
  Segment_Name = 'My_Table' And
  RELATIVE_FNO  = A.RFN
;

Ofcourse this will eat up CPU.

Hope i am correct in reading the requirement.

Abhay.