重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: Oracle定期监控 LOB 增长 [打印本页]

作者: jiawang 时间: 2026-7-15 10:17
标题: Oracle定期监控 LOB 增长
SELECT
s.segment_name,
l.table_name,
l.column_name,
ROUND(s.bytes/1024/1024/1024,2) curr_gb
FROM dba_lobs l
JOIN dba_segments s ON l.owner=s.owner AND l.segment_name=s.segment_name
WHERE ROUND(s.bytes/1024/1024/1024,2) > 10 -- 大于10GB的LOB监控
ORDER BY curr_gb DESC;