Table size Huge - records are low
Hi Team,
We are using 19c oracle database.
Table size is 25 GB but has only 80000 records. We are in process of migrating the table from one db to other. It takes for expdp 1 hour to export. What can we check in this case.
exported "XXTTD"."XXTTD_FA_INVEST_REG_TBL" 25.97 GB 85666 rows
SQL> col TABLE_NAME for a30
SQL> ;
1 SELECT s.owner, s.segment_name AS table_name, s.segment_type,
2 ROUND(s.bytes/1024/1024,2) AS seg_mb,
3 s.blocks, s.extents
4 FROM dba_segments s
5 WHERE s.owner = '&OWNER'
6 AND s.segment_name = 'XXTTD_FA_INVEST_REG_TBL'
7* AND s.segment_type = 'TABLE'
0