查询oracle表容量,查看字段存储方式
查询标容量:
select segment_name, bytes, bytes/1024/1024/1024 as GB from user_segments where segment_name = '大写的表名'
?
查看字段存储方式:
select a.id, dump(a.id)? from table a