Hello ,
on 12c database,
for the size of the table in gigabytes I am using :
SELECT round(SUM (bytes) / 1024 / 1024 / 1024 ) size_in_GB , segment_name, owner
FROM dba_segments
WHERE segment_type = 'TABLE'
AND owner NOT IN ('SYS',
'SYSTEM',
'OUTLN',
'XDB',
'WMSYS',
'OJVMSYS')
GROUP BY segment_name, owner
ORDER BY 1 desc
and now I am trying to figure out how to implement in the query above ¸query that would give me also the row count for the each table from the list :
I am usually counting rows from the table witth
select cont(*) from table_name ;
But I don't know how to have that simple row count query result in the same output with the table segment size , so for each table segment size,
that I can have the column with the row count.
Iw ould appreciate any comment or advice how to do that .
;