--Reducing the Oracle E-Business Suite Data Footprint(Doc ID 752322.1)
set lines 160 pages 50000
col table_name for a30
col column_name for a30
col segment_name for a30
col segment_type for a15
col tablespace_name for a15
SELECT *
FROM (
SELECT A.TABLE_NAME,
A.COLUMN_NAME,
B.SEGMENT_NAME,
B.SEGMENT_TYPE,
B.TABLESPACE_NAME,
B.BYTES/1024/1024/1024 as SIZE_GB,
B.BLOCKS,
B.EXTENTS
FROM DBA_LOBS A, DBA_SEGMENTS B
WHERE A.SEGMENT_NAME = B.SEGMENT_NAME
ORDER BY B.BYTES DESC
)
WHERE ROWNUM <= 10;
set lines 160 pages 50000
col owner for a15
col segment_name for a30
col segment_type for a15
col tablespace_name for a15
SELECT *
FROM (
select owner,segment_name,segment_type,bytes/1024/1024/1024 as SIZE_GB from dba_segments order by bytes desc
)
WHERE ROWNUM <= 20;
Oracle EBS 大表数据清理方法总结
未经允许不得转载:徐万新之路 » Oracle EBS 大表数据清理方法总结
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。