Oracle数据库的一些语句
1.查看Oracle中表空间及表数据大小
SELECT SEGMENT_NAME,
(SUM(BYTES) / 1024 / 1024 / 1024) || ‘GB’ AS TABLE_SIZE
FROM USER_EXTENTS
GROUP BY SEGMENT_NAME
ORDER BY TABLE_SIZE DESC;
(LOB字段会占据很大空间)
2、根据segment_name,就可以从 dba_lobs 表里查到是哪个表,哪个字段,具体的SQL如下:
SELECT * FROM DBA_LOBS WHERE SEGMENT_NAME LIKE ‘SYS_LOB0000090035C00005$$’;