I need a way in Oracle to query the size of the segments as well as the amount of rows for all segment types which are a 'Table'.

Is there a way to combine the statement below (which calculates the size) and the 'count' function?

```
SELECT s.segment_type, (s.bytes / 1024 / 1024) mb, s.segment_name, l.*, s.*
FROM dba_segments s, dba_lobs l
where s.segment_name = l.segment_name(+)
and   s.owner='TEST' order by bytes desc

```