Index 양 갯수 크기 조회
SET PAGES 1000 SET lines 130 COL SEGMENT_NAME FORMAT A50 col TABLESPACE_NAME FORMAT A6 COL EXTENTS FORMAT 999,999 COL tOT_MB FORMAT 999,999 spool tbl1 SELECT TABLESPACE_NAME, SEGMENT_NAME , BYTES/1024/1024 TOT_MB, SEGMENT_TYPE select count(*), sum(BYTES/1024/1024) TOT_MB FROM DBA_SEGMENTS WHERE TABLESPACE_NAME in (‘ARD’,’ARX’,’APD’,’APX’,’GLD’,’GLX’,’FAD’,’FAX’,’JAD’,’JAX’,’JGD’,’JGX’,’XTRD’,’XTRX’, ‘INVD’,’INVX’,’POD’,’POX’,’HRD’,’HRX’, ‘HXCD’,’HXCX’,’HXTD’,’HXTX’,’OTAD’,’OTAX’,’EHRD’,’EHRX’, ‘LGEIFD’,’LGEIFX’,’APPLSYSD’,’APPLSYSX’, ‘OED’,’OEX’,’ONTD’,’ONTX’,’WSHD’,’WSHX’,’ASOD’,’ASOX’,’QPD’,’QPX’) AND SEGMENT_TYPE IN (‘INDEX’) and owner !=’SYS’ and SEGMENT_NAME < ‘EPAY_RETIRED_INTERFACE_HR_N3’ and TABLESPACE_NAME <= ‘EPAY’ –and FREELIST_GROUPS not in (2,4)
SELECT sum(BYTES/1024/1024) TOT_MB FROM DBA_SEGMENTS WHERE TABLESPACE_NAME in (‘ARD’,’ARX’,’APD’,’APX’,’GLD’,’GLX’,’FAD’,’FAX’,’JAD’,’JAX’,’JGD’,’JGX’,’XTRD’,’XTRX’, ‘INVD’,’INVX’,’POD’,’POX’,’HRD’,’HRX’, ‘HXCD’,’HXCX’,’HXTD’,’HXTX’,’OTAD’,’OTAX’,’EHRD’,’EHRX’, ‘LGEIFD’,’LGEIFX’,’APPLSYSD’,’APPLSYSX’, ‘OED’,’OEX’,’ONTD’,’ONTX’,’WSHD’,’WSHX’,’ASOD’,’ASOX’,’QPD’,’QPX’) AND SEGMENT_TYPE IN (‘INDEX’) and SEGMENT_NAME <= ‘EPAY_RETIRED_INTERFACE_HR_N3’ and TABLESPACE_NAME <= ‘EPAY’ and owner !=’SYS’ –and FREELIST_GROUPS not in (2,4)
Comments