如何查询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占用空间”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注云技术行业资讯频道！

相关推荐: 怎么安装Ubuntu16.04 percona MySQL客户端

本篇内容介绍了“怎么安装Ubuntu16.04 percona MySQL客户端”的免费主机域名有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！ 1）获取安装源：wg…