Query to know multiple tables count(*) in a schema

 SET SERVEROUTPUT ON;

DECLARE

val NUMBER;

BEGIN

FOR R IN (SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE OWNER='MANOJ'  ORDER BY TABLE_NAME) LOOP

EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || R.OWNER || '.' || R.TABLE_NAME INTO val;

DBMS_OUTPUT.PUT_LINE(R.TABLE_NAME || ',' || val );

END LOOP;

END;

===================

10:45

LOB Details:
 ========
select a.owner, a.table_name, a.column_name, a.segment_name , b.bytes/1024/1024/1024 size_GB
from dba_lobs a, dba_segments b
where a.segment_name = b.segment_name
and a.owner = b.owner and a.owner='&owner'
order by size_GB;First find the list of tables which have LOB columns:
select col.owner as schema_name,
col.table_name,
count(*) as column_count
from sys.dba_tab_columns col
inner join sys.dba_tables t on col.owner = t.owner
and col.table_name = t.table_name
where col.data_type in ('BLOB', 'CLOB', 'NCLOB', 'BFILE')
-- excluding some Oracle maintained schemas
and col.owner not in ('ANONYMOUS','CTXSYS','DBSNMP','EXFSYS', 'LBACSYS',
'MDSYS', 'MGMT_VIEW','OLAPSYS','OWBSYS','ORDPLUGINS', 'ORDSYS','OUTLN',
'SI_INFORMTN_SCHEMA','SYS','SYSMAN','SYSTEM', 'TSMSYS','WK_TEST',
'WKPROXY','WMSYS','XDB','APEX_040000', 'APEX_PUBLIC_USER','DIP', 'WKSYS',
'FLOWS_30000','FLOWS_FILES','MDDATA', 'ORACLE_OCM', 'XS$NULL',
'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', 'PUBLIC')
group by col.owner,
col.table_name
order by col.owner,
col.table_name;>> Once you get the list of tables, find the length of each LOB column and get the max.
Check actual space used by LOB
SELECT nvl((sum(dbms_lob.getlength( &lob_column ))),0) AS bytes FROM &table_name;

=======================================