--查看Oracle数据库中表空间信息的命令方法: SELECT A.A1 "表空间名称", C.C2 "类型", C.C3 "区管理", (B.B2 / 1024 / 1024) "表空间大小M", (B.B2 - A.A2) / 1024 / 1024 "已使用M", SUBSTR((B.B2 - A.A2) / B.B2 * 100, 1, 5) "利用率" FROM (SELECT TABLESPACE_NAME A1, SUM(NVL(BYTES, 0)) A2 FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME B1, SUM(BYTES) B2 FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) B, (SELECT TABLESPACE_NAME C1, CONTENTS C2, EXTENT_MANAGEMENT C3 FROM DBA_TABLESPACES) C WHERE A.A1 = B.B1 AND C.C1 = B.B1; --查看Oracle数据库中数据文件信息的命令方法 SELECT B.FILE_NAME "物理文件名", B.TABLESPACE_NAME "表空间", B.BYTES / 1024 / 1024 "大小M", (B.BYTES - SUM(NVL(A.BYTES, 0))) / 1024 / 1024 "已使用M", SUBSTR((B.BYTES - SUM(NVL(A.BYTES, 0))) / (B.BYTES) * 100, 1, 5) "利用率" FROM DBA_FREE_SPACE A, DBA_DATA_FILES B WHERE A.FILE_ID = B.FILE_ID GROUP BY B.TABLESPACE_NAME, B.FILE_NAME, B.BYTES ORDER BY B.TABLESPACE_NAME; -- 查看数据文件 SET linesize 1000; select file#,status,name from v$datafile; SELECT group#,sequence#,status,archived FROM v$log; SELECT * FROM v$logfile; SELECT * FROM v$controlfile;
查看oracle数据库格式,查询Oracle数据库表空间和数据文件方法
最新推荐文章于 2023-10-10 18:33:26 发布