I have a schema and I look for the size by using the following

 select segment_type,sum(blocks) from dba_segments where owner='W_GBA_000' group by segment_type; 

SEGMENT_TYPE SUM(BLOCKS)
------------------ -----------
LOBINDEX 368
LOBSEGMENT 736
INDEX 648
TABLE 384

so the total number of block is 2136

if I run the following

 select * from tsq$ T ,sys.user$ u where t.user#=u.user# and u.name='W_GBA_000' ; 

SQL> select t.ts#,t.user#,t.blocks from tsq$ T ,sys.user$ u where t.user#=u.user# and u.name='W_GBA_000' ;

TS# USER# BLOCKS
---------- ---------- ----------
5 122 0
4 122 1496


TS# 5 is the Index Tablespace and TS# 4 is the User Tablespace.


I was expecting the same number of blocks , why nothing for index. May be I m comparing Apple & Bananas !!.

what is the blocks info providing in the TSQ$ ? could I use it to identify the Quota size of a schema ?

Regards
Gilles