total number of records in each schema?

Hi,

How to find total number of records under each user/schema?

assuming you analyze,
select owner, sum(num_rows)
from dba_Tables
group by owner

Tks Martis.

how to find out the same without analyzing schema/tables?