oracle查询单表占用空间的大小
SELECT segment_name AS TABLENAME,
BYTES B,
BYTES / 1024 KB,
BYTES / 1024 / 1024 MB
FROM user_segments
where segment_name = upper('tablename');
2022-12-31 15:29:42
oracle查询单表占用空间的大小
SELECT segment_name AS TABLENAME,
BYTES B,
BYTES / 1024 KB,
BYTES / 1024 / 1024 MB
FROM user_segments
where segment_name = upper('tablename');