Oracle12c數(shù)據(jù)庫(kù)怎么查看表空間使用情況

本篇內(nèi)容主要講解“Oracle12c數(shù)據(jù)庫(kù)怎么查看表空間使用情況”，感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷，實(shí)用性強(qiáng)。下面就讓小編來(lái)帶大家學(xué)習(xí)“Oracle12c數(shù)據(jù)庫(kù)怎么查看表空間使用情況”吧!

通過(guò)以下sql語(yǔ)句可以查看Oracle12c數(shù)據(jù)庫(kù)中所有表空間的使用情況：

可以通過(guò)以下語(yǔ)句查看Oracle12c數(shù)據(jù)庫(kù)中所有表空間的使用情況：

1. SELECT F.TABLESPACE_NAME,
   

2.        (T.TOTAL_SPACE - F.FREE_SPACE) / 1024 "USED (GB)",
   

3.        F.FREE_SPACE / 1024 "FREE (GB)",
   

4.        T.TOTAL_SPACE / 1024 "TOTAL(GB)",
   

5.        (ROUND((F.FREE_SPACE / T.TOTAL_SPACE) * 100)) || '% ' PER_FREE
   

6.   FROM (SELECT TABLESPACE_NAME,
   

7.                ROUND(SUM(BLOCKS *
   

8.                          (SELECT VALUE / 1024
   

9.                             FROM V$PARAMETER
   

10.                            WHERE NAME = 'db_block_size') / 1024)) FREE_SPACE
    

11.           FROM CDB_FREE_SPACE
    

12.          GROUP BY TABLESPACE_NAME) F,
    

13.        (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES / 1048576)) TOTAL_SPACE
    

14.           FROM CDB_DATA_FILES
    

15.          GROUP BY TABLESPACE_NAME) T
    

16.  WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME;

可以通過(guò)添加篩選條件查看指定表空間的使用情況，代碼如下：

1. SELECT F.TABLESPACE_NAME,
   

2.        (T.TOTAL_SPACE - F.FREE_SPACE) / 1024 "USED (GB)",
   

3.        F.FREE_SPACE / 1024 "FREE (GB)",
   

4.        T.TOTAL_SPACE / 1024 "TOTAL(GB)",
   

5.        (ROUND((F.FREE_SPACE / T.TOTAL_SPACE) * 100)) || '% ' PER_FREE
   

6.   FROM (SELECT TABLESPACE_NAME,
   

7.                ROUND(SUM(BLOCKS *
   

8.                          (SELECT VALUE / 1024
   

9.                             FROM V$PARAMETER
   

10.                            WHERE NAME = 'db_block_size') / 1024)) FREE_SPACE
    

11.           FROM CDB_FREE_SPACE
    

12.          GROUP BY TABLESPACE_NAME) F,
    

13.        (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES / 1048576)) TOTAL_SPACE
    

14.           FROM CDB_DATA_FILES
    

15.          GROUP BY TABLESPACE_NAME) T
    

16.  WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME AND T.TABLESPACE_NAME LIKE 'ABC%';

到此，相信大家對(duì)“Oracle12c數(shù)據(jù)庫(kù)怎么查看表空間使用情況”有了更深的了解，不妨來(lái)實(shí)際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢(xún)，關(guān)注我們，繼續(xù)學(xué)習(xí)！