oracle如何查看數(shù)據(jù)庫(kù)大小

小億
689
2024-05-06 20:57:56
欄目: 云計(jì)算

在Oracle數(shù)據(jù)庫(kù)中，您可以使用以下查詢來查看數(shù)據(jù)庫(kù)的總大小和表空間的使用情況：

  1. 查看數(shù)據(jù)庫(kù)的總大小：
SELECT SUM(bytes)/1024/1024 AS "Database Size (MB)" FROM dba_data_files;
  1. 查看每個(gè)表空間的使用情況：
SELECT tablespace_name, SUM(bytes)/1024/1024 AS "Tablespace Size (MB)", SUM(bytes)/1024/1024 - SUM(blocks)/1024/1024 AS "Tablespace Used (MB)" 
FROM dba_data_files 
GROUP BY tablespace_name;
  1. 查看每個(gè)表的大?。?/li> 
SELECT table_name, SUM(bytes)/1024/1024 AS "Table Size (MB)" 
FROM dba_segments 
GROUP BY table_name;

請(qǐng)注意，以上查詢需要具有適當(dāng)?shù)臋?quán)限才能成功運(yùn)行。

0 踩