如何查询oracle clob占用空间

这篇文章主要介绍如何查询oracle clob占用空间，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

SELECT 'EDCRAWDATA' AS TABLE_NAME,
SUM(size_gb) AS TOTAL_GB
FROM (SELECT a.owner,
a.table_name,
a.column_name,
b.segment_name,
ROUND(b.BYTES / 1024 / 1024 / 1024) size_gb
FROM dba_lobs a,
dba_segments b
WHERE a.segment_name = b.segment_name
AND a.owner = 'EOL'
AND a.table_name = 'EDCRAWDATA'
UNION ALL
SELECT a.owner,
a.table_name,
a.column_name,
b.segment_name,
ROUND(b.BYTES / 1024 / 1024 / 1024) size_gb
FROM dba_lobs a,
dba_segments b
WHERE a.index_name = b.segment_name
AND a.owner = 'EOL'
AND a.table_name = 'EDCRAWDATA'
UNION ALL
SELECT A.owner,
'EDCRAWDATA',
'RAWDATA',
A.segment_name,
round(A.BYTES / 1024 / 1024 / 1024) size_gb
FROM DBA_SEGMENTS A
WHERE A.segment_name = 'EDCRAWDATA'
AND A.owner = 'EOL')

查询导出进度：

SELECT s.sid,
s.serial#,
dj.state,
dj.operation,
ds.job_name,
ds.session_type
FROM v$session s,
dba_datapump_sessions ds,
dba_datapump_jobs dj
WHERE s.SADDR = ds.saddr
AND ds.job_name = dj.job_name;

以上是"如何查询oracle clob占用空间"这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注行业资讯频道！