Oracle定期监控 LOB 增长

jiawang

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;

登录/注册后可看大图